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 po_vendors pvd,' ||

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 po_vendors pvd,' ||
250: ' po_vendor_sites pvs,' ||
251: ' ap_invoices ai,' ||
252: ' fnd_languages base,' ||
253: ' fnd_languages lang' ||

Line 354: P_vendor_name_from po_vendors.vendor_name%TYPE;

350: --MLS function for "Supplier Open Balance Report"
351: -------------------------------------------------------------
352: FUNCTION APXSOBLX RETURN VARCHAR2 IS
353:
354: P_vendor_name_from po_vendors.vendor_name%TYPE;
355: p_vendor_name_to po_vendors.vendor_name%TYPE;
356: cursor_id INTEGER;
357: selectstmt VARCHAR2(1500);
358: lang_str VARCHAR2(500) := NULL;

Line 355: p_vendor_name_to po_vendors.vendor_name%TYPE;

351: -------------------------------------------------------------
352: FUNCTION APXSOBLX RETURN VARCHAR2 IS
353:
354: P_vendor_name_from po_vendors.vendor_name%TYPE;
355: p_vendor_name_to po_vendors.vendor_name%TYPE;
356: cursor_id INTEGER;
357: selectstmt VARCHAR2(1500);
358: lang_str VARCHAR2(500) := NULL;
359: l_language VARCHAR2(4);

Line 379: ' FROM po_vendors pvd,' ||

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