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 251: ' ap_invoices ai,' ||

247: -- Create a query string to get languages based on the parameters
248: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
249: ' FROM po_vendors pvd,' ||
250: ' po_vendor_sites pvs,' ||
251: ' ap_invoices ai,' ||
252: ' fnd_languages base,' ||
253: ' fnd_languages lang' ||
254: ' WHERE ai.vendor_id = pvd.vendor_id' ||
255: ' AND pvd.vendor_id = pvs.vendor_id' ||

Line 381: ' ap_invoices ai,' ||

377: -- Create a query string to get languages based on the parameters
378: selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
379: ' FROM po_vendors pvd,' ||
380: ' po_vendor_sites pvs,' ||
381: ' ap_invoices ai,' ||
382: ' fnd_languages base,' ||
383: ' fnd_languages lang' ||
384: ' WHERE ai.vendor_id = pvd.vendor_id' ||
385: ' AND pvd.vendor_id = pvs.vendor_id' ||