APPS.EDW_OPI_LOT_MOPM_SZ dependencies on IC_ITEM_MST

Line 50: IC_ITEM_MST IIM

46: avg(nvl(vsize(LOT_NO||DECODE(SUBLOT_NO,NULL,NULL,'-'||SUBLOT_NO) ||'('|| IIM.ITEM_NO ||')'),0)) NAME,
47: avg(nvl(vsize(LT.LOT_ID||'-'||LT.ITEM_ID||'-'||'OPM'||'-'),0)) LOT_PK,
48: avg(vsize('LOTD'))
49: FROM IC_LOTS_MST LT,
50: IC_ITEM_MST IIM
51: WHERE LT.ITEM_ID = IIM.ITEM_ID
52: AND LT.LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;
53: BEGIN
54: OPEN CUR_INSTANCE_SIZE;