APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on IC_ITEM_MST

Line 13: IC_ITEM_MST IM,

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,
16: PBH.PLANT_CODE,
17: POD.ACTIVITY,

Line 146: IC_ITEM_MST IM

142: avg(nvl(vsize(EDW_ITEMS_PKG.ITEM_ORG_FK(ITEM_FK_V.INVENTORY_ITEM_ID,
143: IW.MTL_ORGANIZATION_ID,NULL,TO_NUMBER(NULL),NULL)), 0))
144: FROM MTL_SYSTEM_ITEMS ITEM_FK_V,
145: IC_WHSE_MST IW,
146: IC_ITEM_MST IM
147: WHERE ITEM_FK_V.SEGMENT1= IM.ITEM_NO
148: AND ITEM_FK_V.ORGANIZATION_ID = IW.MTL_ORGANIZATION_ID;
149:
150: CURSOR INST_PK IS