APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on PM_OPRN_DTL

Line 35: PM_OPRN_DTL POD,

31: POD.PLAN_RSRC_USAGE,
32: POD.PLAN_START_DATE,
33: POD.LAST_UPDATE_DATE
34: FROM
35: PM_OPRN_DTL POD,
36: PM_BTCH_HDR PBH
37: WHERE POD.BATCH_ID=PBH.BATCH_ID
38: ) BR,
39: CR_RSRC_DTL CR,

Line 126: PM_OPRN_DTL POD,

122: avg(nvl(vsize(((POD.PLAN_RSRC_USAGE
123: /POD.PLAN_RSRC_QTY)
124: *POD.ACTUAL_RSRC_QTY)),0)) STND_RSRC_USAGE
125: FROM
126: PM_OPRN_DTL POD,
127: PM_BTCH_HDR PBH
128: WHERE POD.BATCH_ID=PBH.BATCH_ID AND
129: POD.last_update_date between
130: p_from_date and p_to_date;

Line 179: PM_OPRN_DTL POD,

175: CURSOR TRX_DATE_PK is
176: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
177: (POD.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
178: FROM
179: PM_OPRN_DTL POD,
180: PM_BTCH_HDR BH,
181: SY_ORGN_MST OM,
182: GL_PLCY_MST PM,
183: GL_SETS_OF_BOOKS SOB