APPS.EDW_OPI_LOT_MOPM_SZ dependencies on IC_LOTS_MST

Line 11: FROM IC_LOTS_MST LT

7: p_to_date IN DATE,
8: p_num_rows OUT NOCOPY NUMBER) IS
9: BEGIN
10: SELECT count(*) into p_num_rows
11: FROM IC_LOTS_MST LT
12: WHERE lt.last_update_date between p_from_date and p_to_date;
13: --dbms_output.put_line ('Number of rows : '||p_num_rows);
14: EXCEPTION
15: WHEN OTHERS THEN

Line 49: FROM IC_LOTS_MST LT,

45: avg(nvl(vsize(LT.LOT_DESC),0)) LOT_DESC,
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