APPS.AP_REPORTS_MLS_LANG dependencies on PO_VENDORS

Line 19: po_vendors pv,

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
23: AND inv.payment_status_flag in ('N', 'P')

Line 80: ' FROM po_vendors pvd,'||

76: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(5));
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,'||

Line 121: ' FROM po_vendors pvd,'||

117: -- Added the following as part of the fix for 890934. Since the ap_invoice_prepays is obsolete
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

Line 249: ' FROM ap_suppliers pvd,' || /*Bug 13630276: Changed table from po_vendors*/

245: p_end_date := fnd_date.canonical_to_date(fnd_request_info.get_parameter(7));
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 ap_suppliers pvd,' || /*Bug 13630276: Changed table from po_vendors*/
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*/

Line 360: P_vendor_name_from po_vendors.vendor_name%TYPE;

356: --MLS function for "Supplier Open Balance Report"
357: -------------------------------------------------------------
358: FUNCTION APXSOBLX RETURN VARCHAR2 IS
359:
360: P_vendor_name_from po_vendors.vendor_name%TYPE;
361: p_vendor_name_to po_vendors.vendor_name%TYPE;
362: cursor_id INTEGER;
363: selectstmt VARCHAR2(1500);
364: lang_str VARCHAR2(500) := NULL;

Line 361: p_vendor_name_to po_vendors.vendor_name%TYPE;

357: -------------------------------------------------------------
358: FUNCTION APXSOBLX RETURN VARCHAR2 IS
359:
360: P_vendor_name_from po_vendors.vendor_name%TYPE;
361: p_vendor_name_to po_vendors.vendor_name%TYPE;
362: cursor_id INTEGER;
363: selectstmt VARCHAR2(1500);
364: lang_str VARCHAR2(500) := NULL;
365: l_language VARCHAR2(4);

Line 385: ' FROM po_vendors pvd,' ||

381: end if;
382:
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' ||