7:
8: CURSOR c_cnt_rows IS
9: select count(*)
10: FROM
11: PM_BTCH_HDR BH,
12: PM_MATL_DTL BD,
13: IC_ITEM_MST IM,
14: (SELECT
15: POD.BATCH_ID,
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,
40: SY_ORGN_MST OM,
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;
131:
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
184: WHERE