eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CREATE_ASBN_INVOICE dependencies on AP_INVOICES_INTERFACE

Line 147: select ap_invoices_interface_s.nextval

143: if ((X_asbn_header.invoice_num is not null) and
144: (X_asbn_header.invoice_date is not null) and
145: (nvl(X_asbn_header.invoice_amount, 0) > 0)) then
146:
147: select ap_invoices_interface_s.nextval
148: into l_invoice_id
149: from sys.dual;
150:
151: -- Bug 4723269 : Pass org_id to create_ap_batches

Line 263: to 'Y' in ap_invoices_interface table. */

259:
260: /* Bug 5107497: As per eTax project, no need to populate Tax lines in
261: ap_invoice_lines_table. We have to populate control_amount
262: with tax amount specified in ASBN and set calc_tax_during_import_flag
263: to 'Y' in ap_invoices_interface table. */
264: UPDATE ap_invoices_interface
265: SET calc_tax_during_import_flag = 'Y',
266: control_amount = X_asbn_header.tax_amount
267: WHERE invoice_id = l_invoice_id;

Line 264: UPDATE ap_invoices_interface

260: /* Bug 5107497: As per eTax project, no need to populate Tax lines in
261: ap_invoice_lines_table. We have to populate control_amount
262: with tax amount specified in ASBN and set calc_tax_during_import_flag
263: to 'Y' in ap_invoices_interface table. */
264: UPDATE ap_invoices_interface
265: SET calc_tax_during_import_flag = 'Y',
266: control_amount = X_asbn_header.tax_amount
267: WHERE invoice_id = l_invoice_id;
268:

Line 375: insert into AP_INVOICES_INTERFACE (

371: BEGIN
372:
373: x_group_id := substr('ASBN-'||TO_CHAR(p_invoice_id),1,80);
374:
375: insert into AP_INVOICES_INTERFACE (
376: INVOICE_ID,
377: INVOICE_NUM,
378: INVOICE_DATE,
379: VENDOR_ID,