DECLARE BEGIN mo_global.set_policy_context ('S', 204); fnd_global.apps_initialize (1318, 50559, 220); INSERT INTO ra_interface_lines_all (interface_line_context, interface_line_attribute1, interface_line_attribute2, batch_source_name , set_of_books_id, line_type, description, currency_code, amount, cust_trx_type_name, cust_trx_type_id, term_id , conversion_type, conversion_date, trx_date, gl_date, line_number, quantity, unit_selling_price , primary_salesrep_id, purchase_order, uom_code, org_id, orig_system_bill_customer_id , orig_system_bill_address_id, orig_system_bill_contact_id, orig_system_ship_customer_id , orig_system_ship_address_id, orig_system_ship_contact_id, orig_system_sold_customer_id, paying_customer_id , paying_site_use_id, tax_code, vat_tax_id, sales_order, sales_order_line, sales_order_date, inventory_item_id,deferral_exclusion_flag ) VALUES ('LEGACY', 'TEST_CONT-3', '12345-3', 'LEGACY' , 1, 'LINE', 'TEST', 'USD', 1500, 'Invoice', 1, 1041 --non standard term_id from ra_terms , 'Corporate', SYSDATE, SYSDATE, SYSDATE, 1, 1, 1500 , 1006, 'TEST123', 'Ea', 204, 1006 , 1034, NULL, 1006 , 1034, 1013, 1006, 1006 , 1025, 'Standard', NULL, '12345-3', '1', SYSDATE, 167742,'Y' ); INSERT INTO ra_interface_salescredits_all (interface_line_context, interface_line_attribute1, interface_line_attribute2, salesrep_id , sales_credit_amount_split, sales_credit_percent_split, sales_credit_type_id, org_id ) VALUES ('LEGACY', 'TEST_CONT-3', '12345-3', 1006 , 1500, 100, 1, 204 ); COMMIT; END;