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 255: ' fnd_languages base,' ||

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*/
254: ' ap_invoices ai,' ||
255: ' fnd_languages base,' ||
256: ' fnd_languages lang' ||
257: ' WHERE ai.vendor_id = pvd.vendor_id(+)' || /*Bug 13630276: added outer join*/
258: /*' AND pvd.vendor_id = pvs.vendor_id' ||
259: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||*/ /*Bug 13630276: commented the old joins*/

Line 256: ' fnd_languages lang' ||

252: ' hz_parties zp,' || /*Bug 13630276: Added table*/
253: ' hz_locations zl,' || /*Bug 13630276: Added table*/
254: ' ap_invoices ai,' ||
255: ' fnd_languages base,' ||
256: ' fnd_languages lang' ||
257: ' WHERE ai.vendor_id = pvd.vendor_id(+)' || /*Bug 13630276: added outer join*/
258: /*' AND pvd.vendor_id = pvs.vendor_id' ||
259: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||*/ /*Bug 13630276: commented the old joins*/
260: ' AND zps.party_site_id = ai.party_site_id' || /*Bug 13630276: added join*/

Line 388: ' fnd_languages base,' ||

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' ||
390: ' WHERE ai.vendor_id = pvd.vendor_id' ||
391: ' AND pvd.vendor_id = pvs.vendor_id' ||
392: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||

Line 389: ' fnd_languages lang' ||

385: ' FROM po_vendors pvd,' ||
386: ' po_vendor_sites pvs,' ||
387: ' ap_invoices ai,' ||
388: ' fnd_languages base,' ||
389: ' fnd_languages lang' ||
390: ' WHERE ai.vendor_id = pvd.vendor_id' ||
391: ' AND pvd.vendor_id = pvs.vendor_id' ||
392: ' AND ai.vendor_site_id = pvs.vendor_site_id' ||
393: ' AND base.installed_flag = ''B'' ' ||