APPS.OPI_EDW_RES_UTIL_FOPM_SZ SQL Statements

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

Line: 9

	select count(*)
	FROM

      (
       select
       ORGN_CODE,
       trunc(trans_date) trans_date ,
       resources,sum(resource_usage) RSRC_USAGE
       FROM
       PC_TRAN_PND
       WHERE completed_ind=1
       GROUP BY
       ORGN_CODE,trunc(trans_date),resources
      ) PCPND,
      (
       select
       a.ORGN_CODE,
       a.resources,
       trunc(trans_date) trans_date,
       AVG(DAILY_AVAIL_USE) DAILY_AVAIL,
       MAX(a.USAGE_UM) USAGE_UM,
       MAX(GREATEST(a.LAST_UPDATE_DATE,TRANS_DATE)) LAST_UPDATE_DATE
       FROM
       (
        SELECT
             RS.ORGN_CODE,
             RS.RESOURCES,
             RD.DAILY_AVAIL_USE,
             decode(RD.USAGE_UM,NULL,RS.STD_USAGE_UM,RD.USAGE_UM) USAGE_UM,
             RS.LAST_UPDATE_DATE
         FROM
              (SELECT  ORG.ORGN_CODE,
                       RSRC.RESOURCES,
                       RSRC.STD_USAGE_UM,
                       GREATEST(ORG.LAST_UPDATE_DATE,RSRC.LAST_UPDATE_DATE) LAST_UPDATE_DATE
                  FROM SY_ORGN_MST ORG,
                       CR_RSRC_MST RSRC
              ) RS,
              CR_RSRC_DTL RD
              WHERE RS.RESOURCES = RD.RESOURCES(+)
              AND RS.ORGN_CODE = RD.ORGN_CODE(+)
         ) a,
       PC_TRAN_PND b
       WHERE b.completed_ind=1
       GROUP BY
       A.ORGN_CODE,a.resources,trunc(trans_date)
      ) RSRC,
      EDW_LOCAL_INSTANCE inst,
      SY_ORGN_MST SY,
      GL_PLCY_MST GPM,
      OPI_PMI_UOMS_MST UOM
WHERE PCPND.orgn_code(+)= RSRC.ORGN_CODE and
      PCPND.trans_date(+)=RSRC.trans_date and
      PCPND.resources(+) = RSRC.resources and
      RSRC.ORGN_CODE = SY.ORGN_CODE AND
      SY.CO_CODE = GPM.CO_CODE AND
      UOM.UM_CODE = RSRC.USAGE_UM
      AND RSRC.TRANS_DATE  between p_from_date and p_to_date;

Line: 95

	SELECT
            avg(nvl(vsize(RSRC.TRANS_DATE||'-'||rsrc.ORGN_CODE||'-'||RSRC.RESOURCES||'-OPM'),0)) RES_UTIL_PK,
            avg(nvl(vsize(RESOURCE_USAGE),0))
            FROM
            PC_TRAN_PND RSRC
            WHERE
            last_update_date between
            p_from_date  and  p_to_date;

Line: 106

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

Line: 112

	SELECT  avg(nvl(vsize(RESOURCES||'-OPM'), 0))
	FROM CR_RSRC_MST;

Line: 116

	SELECT  avg(nvl(vsize(UOM_CODE), 0))
	FROM OPI_PMI_UOMS_MST;

Line: 119

	SELECT  avg(nvl(vsize(ORGN_CODE), 0))
	FROM SY_ORGN_MST;

Line: 123

	SELECT          avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
           (BH.TRANS_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
	FROM
          PC_TRAN_PND  BH,
          SY_ORGN_MST  OM,
          GL_PLCY_MST  PM,
          GL_SETS_OF_BOOKS SOB
          WHERE
          BH.ORGN_CODE = OM.ORGN_CODE
          AND OM.CO_CODE      = PM.co_code
          AND PM.SET_OF_BOOKS_NAME=SOB.name;