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
            );

Comments

  1. 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.

    ReplyDelete
  2. Very intersting notes on ebusiness Suite
    Please 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

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Shipping Network SQL Query

Oracle Ar Invoice Numbering Sequence alter to avoid missing in between by cache

How to call Auto invoice Import Program from Back end