APPS.AP_REPORTS_MLS_LANG dependencies on FND_LANGUAGES

Line 13: l_base FND_LANGUAGES.LANGUAGE_CODE%TYPE;

9: FUNCTION APXVDLET RETURN VARCHAR2 IS
10:
11: lang_str VARCHAR2(500) := NULL;
12: -- Bug 2633773 , to remove cartesian join in cursor languages_cursor
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,

Line 21: fnd_languages lang

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')
24: AND pv.vendor_id = pvs.vendor_id
25: AND h.invoice_id = inv.invoice_id

Line 35: from fnd_languages

31:
32: -- Bug 2633773 , select base language code into local variable
33: select language_code
34: INTO l_base
35: from fnd_languages
36: where installed_flag = 'B';
37:
38:
39: FOR languages IN languages_cursor LOOP

Line 85: ' fnd_languages base,'||

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'||
88: ' AND aipp.prepay_id = pp.invoice_id'||
89: ' AND ai.vendor_id = pp.vendor_id'||

Line 86: ' fnd_languages lang'||

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'||
88: ' AND aipp.prepay_id = pp.invoice_id'||
89: ' AND ai.vendor_id = pp.vendor_id'||
90: ' AND ai.vendor_id = pvd.vendor_id'||

Line 126: ' fnd_languages base,'||

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'||
128: ' WHERE aid.invoice_id = ai.invoice_id'||
129: ' AND aid.line_type_lookup_code = ''PREPAY'' '||
130: ' AND ai.vendor_id = pvd.vendor_id'||

Line 127: ' fnd_languages lang'||

123: ' ap_invoices ai,'||
124: ' ap_invoice_distributions aid,'||
125: ' ap_invoice_distributions aid2,'|| --3984580
126: ' fnd_languages base,'||
127: ' fnd_languages lang'||
128: ' WHERE aid.invoice_id = ai.invoice_id'||
129: ' AND aid.line_type_lookup_code = ''PREPAY'' '||
130: ' AND ai.vendor_id = pvd.vendor_id'||
131: ' AND pvd.vendor_id = pvs.vendor_id'||

Line 252: ' fnd_languages base,' ||

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' ||
256: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||

Line 253: ' fnd_languages lang' ||

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' ||
256: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||
257: ' AND base.installed_flag = ''B'' ' ||

Line 382: ' fnd_languages base,' ||

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' ||
386: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||

Line 383: ' fnd_languages lang' ||

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' ||
386: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||
387: ' AND base.installed_flag = ''B'' ' ||