APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on IC_ITEM_MST

Line 42: IC_ITEM_MST IM,

38: AND BH.BATCH_STATUS in (-1,0,1,2,3,4)
39: AND BD.LINE_TYPE=1
40: ) B,
41: SY_ORGN_MST OM,
42: IC_ITEM_MST IM,
43: IC_PLNT_INV PI,
44: GL_SETS_OF_BOOKS SOB,
45: GL_PLCY_MST PM,
46: MTL_SYSTEM_ITEMS ITEM_FK_V,

Line 134: IC_ITEM_MST IM

130: avg(nvl(vsize(EDW_ITEMS_PKG.ITEM_ORG_FK(ITEM_FK_V.INVENTORY_ITEM_ID,
131: IW.MTL_ORGANIZATION_ID,NULL,TO_NUMBER(NULL),NULL)), 0))
132: FROM MTL_SYSTEM_ITEMS ITEM_FK_V,
133: IC_WHSE_MST IW,
134: IC_ITEM_MST IM
135: WHERE ITEM_FK_V.SEGMENT1= IM.ITEM_NO
136: AND ITEM_FK_V.ORGANIZATION_ID = IW.MTL_ORGANIZATION_ID;
137:
138: CURSOR INST_PK IS