APPS.FII_AP_OP_INDICATOR_SUM_C SQL Statements

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

Line: 99

    l_stmt := 'INSERT INTO '||g_fii_schema||'.FII_AP_OP_IND_SUMMARY_TEMP1 (
               operating_unit_pk_key,
               operating_unit_name,
               trading_partner_pk_key,
               trading_partner_name,
               inv_lines_count,
               inv_count,
               inv_amount)
     SELECT org.OPER_OPERATING_UNIT_PK_KEY operating_unit_pk_key,
            org.oper_name operating_unit_name,
            partner.TPRT_TRADE_PARTNER_PK_KEY trading_partner_pk_key,
            partner.tprt_name trading_partner_name,
            count(invl.inv_line_pk_key) inv_lines_count,
            count(distinct invl.inv_fk_key) inv_count,
            sum(nvl(invl.inv_line_amt_g, 0)) inv_amount
     FROM  fii_ap_inv_lines_f invl,
           edw_organization_m org,
           edw_trd_partner_m partner
     WHERE invl.org_fk_key = org.orga_organization_pk_key
     AND   invl.org_fk_key > 0
     AND   invl.supplier_fk_key = partner.TPLO_TPARTNER_LOC_PK_KEY
     AND   invl.supplier_fk_key > 0
     AND   invl.inv_date between to_date('''
          ||to_char(g_cur_qtr_start_date, 'DD-MM-YYYY')
          ||''', ''DD-MM-YYYY'') and  to_date('''
          || to_char(g_today, 'DD-MM-YYYY') || ''', ''DD-MM-YYYY'')
     GROUP BY org.OPER_OPERATING_UNIT_PK_KEY,
              org.oper_name,
              partner.TPRT_TRADE_PARTNER_PK_KEY,
              partner.tprt_name';

Line: 137

    	edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP1');

Line: 141

    l_stmt := 'INSERT INTO '||g_fii_schema||'.FII_AP_OP_IND_SUMMARY_TEMP2 (
               operating_unit_pk_key,
               operating_unit_name,
               trading_partner_pk_key,
               trading_partner_name,
               inv_payment_amount,
               inv_payment_count)
	 select org.OPER_OPERATING_UNIT_PK_KEY operating_unit_pk_key,
           org.oper_name operating_unit_name,
           partner.TPRT_TRADE_PARTNER_PK_KEY trading_partner_pk_key,
           partner.tprt_name trading_partner_name,
           sum(nvl(invp.payment_amt_g, 0)) inv_payment_amount,
           count(invp.inv_payment_pk) inv_payment_count
    from  fii_ap_inv_paymts_f invp,
          edw_organization_m org,
          edw_trd_partner_m partner
    WHERE invp.org_fk_key = org.orga_organization_pk_key
    AND   invp.org_fk_key > 0
    AND   invp.supplier_fk_key = partner.TPLO_TPARTNER_LOC_PK_KEY
    AND   invp.supplier_fk_key > 0
    AND   invp.creation_date between to_date('''
          ||to_char(g_cur_qtr_start_date, 'DD-MM-YYYY')
          ||''', ''DD-MM-YYYY'') and  to_date('''
          || to_char(g_today, 'DD-MM-YYYY') || ''', ''DD-MM-YYYY'')
    GROUP BY org.OPER_OPERATING_UNIT_PK_KEY,
             org.oper_name,
             partner.TPRT_TRADE_PARTNER_PK_KEY,
             partner.tprt_name';

Line: 177

    edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP2');

Line: 215

  l_state := 'Insert into FII_AP_OP_INDICATOR_SUMMARY';

Line: 216

  l_stmt := 'insert into '||g_fii_schema||'.FII_AP_OP_INDICATOR_SUMMARY (
                    operating_unit_pk_key,
                    operating_unit_name,
                    trading_partner_pk_key,
                    trading_partner_name,
                    inv_lines_count,
                    inv_count,
                    inv_amount,
                    inv_payment_count,
                    inv_payment_amount)
				 select f.operating_unit_pk_key,
                    f.operating_unit_name,
                    f.trading_partner_pk_key,
                    f.trading_partner_name,
                    sum(f.inv_lines_count),
                    sum(f.inv_count),
                    sum(f.inv_amount),
                    sum(f.inv_payment_count),
                    sum(f.inv_payment_amount)
             FROM  (select operating_unit_pk_key,
                           operating_unit_name,
                           trading_partner_pk_key,
                           trading_partner_name,
                           inv_amount,
                           inv_lines_count,
                           inv_count,
                           0 inv_payment_amount,
                           0 inv_payment_count
                    FROM ' ||g_fii_schema||'.fii_ap_op_ind_summary_temp1
                    UNION ALL
                    SELECT operating_unit_pk_key,
                           operating_unit_name,
                           trading_partner_pk_key,
                           trading_partner_name,
                           0 inv_amount,
                           0 inv_lines_count,
                           0 inv_count,
                           inv_payment_amount,
                           inv_payment_count
                    FROM ' ||g_fii_schema||'.fii_ap_op_ind_summary_temp2) f
             GROUP BY f.operating_unit_pk_key,
                      f.operating_unit_name,
                      f.trading_partner_pk_key,
                      f.trading_partner_name';

Line: 268

  	edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_INDICATOR_SUMMARY');

Line: 326

  SELECT tablespace_name
  INTO   g_tablespace
  FROM   all_tables
  WHERE  table_name = 'FII_AP_OP_INDICATOR_SUMMARY'
  AND    owner = g_fii_schema;