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.AP_XML_INVOICE_INBOUND_PKG dependencies on AP_INVOICES_INTERFACE

Line 35: from ap_system_parameters_all sys,ap_invoices_interface h

31:
32: update ap_invoice_lines_interface
33: set DIST_CODE_COMBINATION_ID =
34: (select FREIGHT_CODE_COMBINATION_ID
35: from ap_system_parameters_all sys,ap_invoices_interface h
36: where sys.org_id = h.org_id and h.invoice_id = p_invoice_id)
37: where line_type_lookup_code = 'FREIGHT' and
38: invoice_id = p_invoice_id;
39:

Line 207: from ap_invoices_interface h

203: l_tax_code varchar2(30);
204:
205: cursor inv_csr is
206: select h.invoice_id, h.vendor_id
207: from ap_invoices_interface h
208: where h.source like 'XML GATEWAY' and
209: h.status is NULL and
210: h.vendor_name is NOT NULL;
211:

Line 221: update ap_invoices_interface

217: fetch inv_csr bulk collect into l_inv_ids, l_vendor_ids;
218: close inv_csr;
219:
220: forall i in nvl(l_inv_ids.first,1)..nvl(l_inv_ids.last,0)
221: update ap_invoices_interface
222: set vendor_name = null
223: where invoice_id = l_inv_ids(i);
224: --
225: -- populate tax_code for line_type tax

Line 342: from ap_invoices_interface

338: lookup_code = 'INVOICE NUMBER';
339:
340: cursor l_email_csr(c_request_id in NUMBER) is
341: select distinct vendor_email_address
342: from ap_invoices_interface
343: where request_id = c_request_id
344: and vendor_email_address is not null; --bug4065112
345:
346: cursor l_message_csr(c_request_id in NUMBER,

Line 395: from ap_invoices_interface h,

391: -- Bug 4065112 starts
392: ,group_id, external_doc_ref
393: -- Bug 4065112 ends
394:
395: from ap_invoices_interface h,
396: ap_interface_rejections r,
397: ap_lookup_codes lc
398: where h.request_id = c_request_id
399: and nvl(r.notify_vendor_flag, 'N') = 'Y'

Line 401: and r.parent_table = 'AP_INVOICES_INTERFACE'

397: ap_lookup_codes lc
398: where h.request_id = c_request_id
399: and nvl(r.notify_vendor_flag, 'N') = 'Y'
400: and h.invoice_id = r.parent_id
401: and r.parent_table = 'AP_INVOICES_INTERFACE'
402: and h.vendor_email_address = c_vendor_email_address
403: and lc.lookup_code = r.reject_lookup_code
404: and lc.lookup_type = 'REJECT CODE'
405: union all

Line 452: from ap_invoices_interface h,

448: fnd_global.newline
449: -- Bug 4065112 starts
450: ,group_id, external_doc_ref
451: -- Bug 4065112 ends
452: from ap_invoices_interface h,
453: ap_invoice_lines_interface l,
454: ap_interface_rejections r,
455: ap_lookup_codes lc
456: where h.request_id = c_request_id

Line 503: l_group_id ap_invoices_interface.group_id%TYPE;

499: l_org_id NUMBER;
500: l_invoice_line_number VARCHAR2(30);
501: l_invoice_line_number_tmp NUMBER;
502: -- Bug 4065112 starts
503: l_group_id ap_invoices_interface.group_id%TYPE;
504: l_external_doc_ref ap_invoices_interface.external_doc_ref%TYPE;
505: l_call_3c4_invoice_id ap_invoices_interface.invoice_id%TYPE;
506: -- Bug 4065112 ends
507:

Line 504: l_external_doc_ref ap_invoices_interface.external_doc_ref%TYPE;

500: l_invoice_line_number VARCHAR2(30);
501: l_invoice_line_number_tmp NUMBER;
502: -- Bug 4065112 starts
503: l_group_id ap_invoices_interface.group_id%TYPE;
504: l_external_doc_ref ap_invoices_interface.external_doc_ref%TYPE;
505: l_call_3c4_invoice_id ap_invoices_interface.invoice_id%TYPE;
506: -- Bug 4065112 ends
507:
508: begin

Line 505: l_call_3c4_invoice_id ap_invoices_interface.invoice_id%TYPE;

501: l_invoice_line_number_tmp NUMBER;
502: -- Bug 4065112 starts
503: l_group_id ap_invoices_interface.group_id%TYPE;
504: l_external_doc_ref ap_invoices_interface.external_doc_ref%TYPE;
505: l_call_3c4_invoice_id ap_invoices_interface.invoice_id%TYPE;
506: -- Bug 4065112 ends
507:
508: begin
509: ap_debug_pkg.print('Y','AP_XML_INVOICE_INBOUND_PKG.notify_supplier(+)');

Line 838: FROM ap_invoices_interface h, ap_invoice_lines_interface l

834: SET taxable_flag = 'Y'
835: WHERE line_type_lookup_code = 'ITEM'
836: AND invoice_id IN
837: (SELECT h.invoice_id
838: FROM ap_invoices_interface h, ap_invoice_lines_interface l
839: WHERE h.invoice_id = l.invoice_id
840: AND h.source = 'XML GATEWAY'
841: AND h.group_id = p_group_id
842: AND l.line_type_lookup_code = 'TAX'

Line 901: FROM AP_INVOICES_INTERFACE

897: l_misc_ccid number;
898:
899: cursor org_csr is
900: SELECT distinct ORG_ID
901: FROM AP_INVOICES_INTERFACE
902: WHERE GROUP_ID = p_group_id
903: AND SOURCE = 'XML GATEWAY';
904:
905: begin

Line 945: FROM AP_INVOICES_INTERFACE

941: decode(LINE_TYPE_LOOKUP_CODE,'FREIGHT',decode(l_freight_ccid,'','Y','N'),
942: 'MISCELLANEOUS',decode(l_misc_ccid,'','Y','N'))
943: WHERE INVOICE_ID in
944: (SELECT INVOICE_ID
945: FROM AP_INVOICES_INTERFACE
946: WHERE GROUP_ID = p_group_id
947: AND NVL(ORG_ID,TO_NUMBER(NVL(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
948: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10)), '-99'))) =
949: NVL(l_org_id,TO_NUMBER(NVL(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),