APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on MTL_SYSTEM_ITEMS

Line 44: MTL_SYSTEM_ITEMS ITEM_FK_V,

40: SY_ORGN_MST OM,
41: GL_PLCY_MST PM,
42: FM_OPRN_MST OPRM,
43: FM_OPRN_DTL OPRD,
44: MTL_SYSTEM_ITEMS ITEM_FK_V,
45: IC_WHSE_MST IW,
46: GL_SETS_OF_BOOKS SOB,
47: EDW_LOCAL_INSTANCE inst,
48: OPI_PMI_UOMS_MST UOM

Line 144: FROM MTL_SYSTEM_ITEMS ITEM_FK_V,

140: /* ITEM_FK */
141: SELECT
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;