Posts

Showing posts from November, 2014

AP Invoice Interface Script

INSERT INTO apps.ap_invoices_interface             (invoice_id, invoice_num, vendor_id, vendor_site_id,              invoice_amount, invoice_currency_code, invoice_date,              description, pay_group_lookup_code,              SOURCE, org_id             )      VALUES (152303, 'INV100', '974078', '75199',              1.00, 'ZMW', '10-SEP-2014',              'This Invoice is created for test purpose', '',              'LEASES', 2899             ); INSERT INTO apps.ap_invoice_lines_interface             (invoice_id, line_number, line_type_lookup_code, amount,ACCOUNTING_DATE ,DIST_CODE_COMBINATION_ID         ...