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.

[Home] [Help]

APPS.AP_REPORTS_MLS_LANG dependencies on AP_INVOICES

Line 18: ap_invoices inv,

14:
15: CURSOR languages_cursor is
16: SELECT DISTINCT(NVL(lang.language_code, l_base)) language_code
17: FROM po_vendor_sites pvs,
18: ap_invoices inv,
19: po_vendors pv,
20: ap_holds h,
21: fnd_languages lang
22: WHERE inv.vendor_site_id = pvs.vendor_site_id

Line 82: ' ap_invoices ai,'||

78: -- Create a query string to get languages based on the parameters
79: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
80: ' FROM po_vendors pvd,'||
81: ' po_vendor_sites pvs,'||
82: ' ap_invoices ai,'||
83: ' ap_invoices pp,'||
84: ' ap_invoice_prepays aipp,'||
85: ' fnd_languages base,'||
86: ' fnd_languages lang'||

Line 83: ' ap_invoices pp,'||

79: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
80: ' FROM po_vendors pvd,'||
81: ' po_vendor_sites pvs,'||
82: ' ap_invoices ai,'||
83: ' ap_invoices pp,'||
84: ' ap_invoice_prepays aipp,'||
85: ' fnd_languages base,'||
86: ' fnd_languages lang'||
87: ' WHERE aipp.invoice_id = ai.invoice_id'||

Line 123: ' ap_invoices ai,'||

119:
120: selectstmt := selectstmt||' UNION SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
121: ' FROM po_vendors pvd,'||
122: ' po_vendor_sites pvs,'||
123: ' ap_invoices ai,'||
124: ' ap_invoice_distributions aid,'||
125: ' ap_invoice_distributions aid2,'|| --3984580
126: ' fnd_languages base,'||
127: ' fnd_languages lang'||

Line 254: ' ap_invoices ai,' ||

250: /*' po_vendor_sites pvs,' ||*/ /*Bug 13630276:commented table*/
251: ' hz_party_sites zps,' || /*Bug 13630276: Added table*/
252: ' hz_parties zp,' || /*Bug 13630276: Added table*/
253: ' hz_locations zl,' || /*Bug 13630276: Added table*/
254: ' ap_invoices ai,' ||
255: ' fnd_languages base,' ||
256: ' fnd_languages lang' ||
257: ' WHERE ai.vendor_id = pvd.vendor_id(+)' || /*Bug 13630276: added outer join*/
258: /*' AND pvd.vendor_id = pvs.vendor_id' ||

Line 387: ' ap_invoices ai,' ||

383: -- Create a query string to get languages based on the parameters
384: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
385: ' FROM po_vendors pvd,' ||
386: ' po_vendor_sites pvs,' ||
387: ' ap_invoices ai,' ||
388: ' fnd_languages base,' ||
389: ' fnd_languages lang' ||
390: ' WHERE ai.vendor_id = pvd.vendor_id' ||
391: ' AND pvd.vendor_id = pvs.vendor_id' ||