APPS.OPI_EDW_COGS_FOPM_SZ SQL Statements

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

Line: 10

  SELECT COUNT(*) INTO p_num_rows
  FROM (
     SELECT SH.order_id
     FROM
         OP_ORDR_HDR SH,
         OP_ORDR_DTL SD,
         SY_ORGN_MST OM,
         GL_PLCY_MST  PM
     WHERE SH.order_id = sd.order_id
      AND SH.orgn_code = OM.orgn_code
      AND OM.co_CODE  = PM.co_code
      AND SD.LINE_STATUS >= 20
      AND GREATEST(SH.LAST_UPDATE_DATE, SD.LAST_UPDATE_DATE,PM.LAST_UPDATE_DATE)
      between p_from_date and p_to_date);

Line: 41

    SELECT  avg(nvl(vsize(itp.trans_id), 0)) trx_id,
      avg(nvl(vsize(itp.trans_um), 0)) um,
      avg(nvl(vsize(itp.line_id), 0))   line_id,
      avg(nvl(vsize(itp.WHSE_CODE), 0)) WHSE_code,
      avg(nvl(vsize(itp.LOCATION), 0))   location,
      avg(nvl(vsize(itp.TRANS_QTY), 0))  qty,
      avg(nvl(vsize(ilm.lot_no),0)) Lot_no,
      avg(nvl(vsize(itp.item_id),0)) item_id
      FROM IC_TRAN_PND ITP,IC_LOTS_MST ILM
      WHERE ITP.last_update_date between p_from_date  and  p_to_date
         AND ITP.LOT_ID  = ILM.LOT_ID
         AND ITP.ITEM_ID = ILM.ITEM_ID
         AND ITP.COMPLETED_IND =1
         AND ITP.DOC_TYPE in ('OPSO');

Line: 57

    SELECT avg(nvl(vsize(ooh.order_no), 0))  order_no,
      avg(nvl(vsize(ood.line_no), 0))        line_no,
      avg(nvl(vsize(ood.BILLING_CURRENCY), 0))  CURRENCY,
      avg(nvl(vsize(OOD.SHIPCUST_ID), 0))       cust_id
      FROM op_ORDR_hdr ooh,
           op_ordr_Dtl ood
      WHERE GREATEST(ooh.last_update_date,ood.last_update_date) between p_from_date  and  p_to_date;

Line: 67

    SELECT
      avg(nvl(vsize(instance_code), 0))
      FROM	EDW_LOCAL_INSTANCE ;

Line: 72

    SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, SOB_ID) ),0)) date_fk,
           AVG(NVL(VSIZE(SOB_ID),0)) SOB_ID,
           AVG(NVL(VSIZE(ORG_ID),0)) ORG_ID
      FROM gl_plcy_mst;