APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on EDW_ITEMS_PKG

Line 130: avg(nvl(vsize(EDW_ITEMS_PKG.ITEM_ORG_FK(ITEM_FK_V.INVENTORY_ITEM_ID,

126:
127: CURSOR ITEM_PK IS
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