APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on MTL_SYSTEM_ITEMS

Line 46: MTL_SYSTEM_ITEMS ITEM_FK_V,

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,
47: IC_WHSE_MST IW,
48: EDW_LOCAL_INSTANCE inst,
49: OPI_PMI_UOMS_MST UOM,
50: GEM_LOOKUPS LKUP

Line 132: FROM MTL_SYSTEM_ITEMS ITEM_FK_V,

128: /* ITEM_FK */
129: SELECT
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;