[Home] [Help]
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
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,'||
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,'||
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*/
254: ' ap_invoices ai,' ||
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' ||
390: ' WHERE ai.vendor_id = pvd.vendor_id' ||