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
)
VALUES (152303, 1, 'ITEM', 1.00, '10-SEP-2014',187777
);
(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
)
VALUES (152303, 1, 'ITEM', 1.00, '10-SEP-2014',187777
);
Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.
ReplyDeleteVery intersting notes on ebusiness Suite
ReplyDeletePlease do share your articles like this.THis link also useful to Find info On Oracle apps-jobs,interview tips,Resume preparation,functional issuesOracle eBusiness Suite