APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on PM_MATL_DTL

Line 34: PM_MATL_DTL BD,

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(+)
38: AND BH.BATCH_STATUS in (-1,0,1,2,3,4)

Line 119: PM_MATL_DTL BD,

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(+)
123: AND BH.BATCH_STATUS in (-1,0,1,2,3,4)