APPS.AP_REPORTS_MLS_LANG dependencies on PO_VENDOR_SITES

Line 17: FROM po_vendor_sites pvs,

13: l_base FND_LANGUAGES.LANGUAGE_CODE%TYPE;
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

Line 81: ' po_vendor_sites pvs,'||

77:
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,'||

Line 122: ' po_vendor_sites pvs,'||

118: -- in Release 11i, we need to use ap_invoice_distributions to get the 'PREPAY' information.
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,'||

Line 250: ' po_vendor_sites pvs,' ||

246:
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' ||

Line 380: ' po_vendor_sites pvs,' ||

376:
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' ||