APPS.AP_REPORTS_MLS_LANG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

         SELECT DISTINCT(NVL(lang.language_code, l_base)) language_code
         FROM po_vendor_sites pvs,
              ap_invoices inv,
              po_vendors pv,
              ap_holds h,
              fnd_languages lang
         WHERE inv.vendor_site_id = pvs.vendor_site_id
         AND   inv.payment_status_flag in ('N', 'P')
         AND   pv.vendor_id = pvs.vendor_id
         AND   h.invoice_id = inv.invoice_id
         AND   h.hold_lookup_code = 'INVALID PO'
         AND   h.release_lookup_code is null
         AND   lang.nls_language (+) = pvs.language;

Line: 33

     select language_code
        INTO l_base
        from fnd_languages
        where installed_flag = 'B';

Line: 65

      selectstmt 	VARCHAR2(1500);

Line: 79

      selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
                    ' FROM   po_vendors pvd,'||
                    '        po_vendor_sites pvs,'||
                    '        ap_invoices ai,'||
                    '        ap_invoices pp,'||
                    '        ap_invoice_prepays  aipp,'||
                    '        fnd_languages base,'||
                    '        fnd_languages lang'||
                    ' WHERE  aipp.invoice_id = ai.invoice_id'||
                    ' AND    aipp.prepay_id  = pp.invoice_id'||
                    ' AND    ai.vendor_id = pp.vendor_id'||
                    ' AND    ai.vendor_id = pvd.vendor_id'||
                    ' AND    pvd.vendor_id  = pvs.vendor_id'||
                    ' AND    pvs.vendor_site_id = ai.vendor_site_id'||
                    ' AND    base.installed_flag = ''B'' '||
                    ' AND    lang.nls_language (+) = pvs.language';

Line: 98

         selectstmt := selectstmt||' AND ai.vendor_id = :p_vendor_id';

Line: 102

         selectstmt := selectstmt||' AND ai.invoice_id = :p_invoice_id';

Line: 106

         selectstmt := selectstmt||' AND pp.invoice_id = :p_prepay_id';

Line: 110

        selectstmt := selectstmt||' AND aipp.last_update_date >=  :p_start_date';

Line: 114

        selectstmt := selectstmt||' AND aipp.last_update_date <= :p_end_date';

Line: 120

      selectstmt := selectstmt||' UNION SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
                    ' FROM   po_vendors pvd,'||
                    '        po_vendor_sites pvs,'||
                    '        ap_invoices ai,'||
                    '        ap_invoice_distributions aid,'||
	            '        ap_invoice_distributions aid2,'|| --3984580
                    '        fnd_languages base,'||
                    '        fnd_languages lang'||
                    ' WHERE  aid.invoice_id = ai.invoice_id'||
                    ' AND    aid.line_type_lookup_code  = ''PREPAY'' '||
                    ' AND    ai.vendor_id = pvd.vendor_id'||
                    ' AND    pvd.vendor_id  = pvs.vendor_id'||
                    ' AND    pvs.vendor_site_id = ai.vendor_site_id'||
                    ' AND    base.installed_flag = ''B'' '||
                    ' AND    nvl(aid.reversal_flag,''N'') != ''Y'' '||
                    ' AND    lang.nls_language (+) = pvs.language'||
                    ' AND    aid2.invoice_distribution_id = aid.prepay_distribution_id'||--3984580
                    ' AND    aid2.line_type_lookup_code = ''ITEM'' '; --3984580

Line: 141

         selectstmt := selectstmt||' AND ai.vendor_id = :p_vendor_id';

Line: 145

         selectstmt := selectstmt||' AND ai.invoice_id = :p_invoice_id';

Line: 149

         selectstmt := selectstmt||' AND aid2.invoice_id = :p_prepay_id';  --3984580

Line: 156

        selectstmt := selectstmt||' AND ai.invoice_date >=  :p_start_date';

Line: 160

        selectstmt := selectstmt||' AND ai.last_update_date <= :p_end_date';

Line: 167

      dbms_sql.parse(cursor_id, selectstmt, dbms_sql.v7);

Line: 232

      selectstmt 	VARCHAR2(1500);

Line: 248

      selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
                    ' FROM   po_vendors pvd,'					  ||
                    '        po_vendor_sites pvs,'				  ||
                    '        ap_invoices ai,'					  ||
                    '        fnd_languages base,'                                 ||
                    '        fnd_languages lang'                                  ||
                    ' WHERE  ai.vendor_id = pvd.vendor_id'			  ||
                    ' AND    pvd.vendor_id = pvs.vendor_id'			  ||
                    ' AND    ai.vendor_site_id  = pvs.vendor_site_id'		  ||
                    ' AND    base.installed_flag = ''B'' '			  ||
                    ' AND    lang.nls_language (+) = pvs.language';

Line: 262

         selectstmt := selectstmt||' AND pvd.vendor_type_lookup_code = :p_vendor_type';

Line: 265

         selectstmt := selectstmt||' AND ai.pay_group_lookup_code = :p_pay_group';

Line: 269

         selectstmt := selectstmt||' AND ai.vendor_id = :p_vendor_id';

Line: 273

         selectstmt := selectstmt||' AND ai.invoice_type_lookup_code = :p_invoice_type';

Line: 277

         selectstmt := selectstmt||' AND ai.invoice_id = :p_invoice_id';

Line: 281

        selectstmt := selectstmt||' AND ai.invoice_date >=  :p_start_date';

Line: 285

        selectstmt := selectstmt||' AND ai.invoice_date <= :p_end_date';

Line: 292

      dbms_sql.parse(cursor_id, selectstmt, dbms_sql.v7);

Line: 357

     selectstmt 	VARCHAR2(1500);

Line: 378

      selectstmt := 'SELECT DISTINCT(NVL(lang.language_code, base.language_code))'||
                    ' FROM   po_vendors pvd,'					  ||
                    '        po_vendor_sites pvs,'				  ||
                    '        ap_invoices ai,'					  ||
                    '        fnd_languages base,'                                 ||
                    '        fnd_languages lang'                                  ||
                    ' WHERE  ai.vendor_id = pvd.vendor_id'			  ||
                    ' AND    pvd.vendor_id = pvs.vendor_id'			  ||
                    ' AND    ai.vendor_site_id  = pvs.vendor_site_id'		  ||
                    ' AND    base.installed_flag = ''B'' '			  ||
                    ' AND    lang.nls_language (+) = pvs.language'                ||
                    ' AND    pvd.vendor_name between nvl(:p_vendor_name_from,''A'') and nvl(:p_vendor_name_to,''Z'')';

Line: 396

         dbms_sql.parse(cursor_id, selectstmt, dbms_sql.v7);