APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on PM_BTCH_HDR

Line 33: FROM PM_BTCH_HDR BH,

29: BD.COST_ALLOC,
30: BD.LINE_NO,
31: BH.CREATION_DATE,
32: GREATEST(BH.LAST_UPDATE_DATE, BD.LAST_UPDATE_DATE) LAST_UPDATE_DATE
33: FROM PM_BTCH_HDR BH,
34: PM_MATL_DTL BD,
35: FM_ROUT_HDR RT
36: WHERE BH.BATCH_ID = BD.BATCH_ID
37: AND BH.ROUTING_ID=RT.ROUTING_ID(+)

Line 118: PM_BTCH_HDR BH,

114: avg(nvl(vsize(BD.PLAN_QTY),0)),
115: avg(nvl(vsize(RT.ROUTING_NO),0)),
116: avg(nvl(vsize(RT.ROUTING_VERS),0))
117: FROM
118: PM_BTCH_HDR BH,
119: PM_MATL_DTL BD,
120: FM_ROUT_HDR RT
121: WHERE BH.BATCH_ID = BD.BATCH_ID
122: AND BH.ROUTING_ID=RT.ROUTING_ID(+)

Line 160: PM_BTCH_HDR BH,

156: CURSOR TRX_DATE_PK is
157: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
158: (BH.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
159: FROM
160: PM_BTCH_HDR BH,
161: SY_ORGN_MST OM,
162: GL_PLCY_MST PM,
163: GL_SETS_OF_BOOKS SOB
164: WHERE