APPS.OPI_EDW_OPI_LOT_M_SZ dependencies on MTL_LOT_NUMBERS

Line 10: MTL_LOT_NUMBERS

6: p_num_rows OUT NOCOPY NUMBER) IS
7: CURSOR c_cnt_rows IS
8: select count(*) cnt
9: FROM
10: MTL_LOT_NUMBERS
11: where last_update_date between p_from_date and p_to_date ;
12: BEGIN
13:
14: OPEN c_cnt_rows;

Line 62: MTL_LOT_NUMBERS ;

58: avg(nvl(vsize(LAST_UPDATE_DATE), 0)),
59: -- CREATION_DATE
60: avg(nvl(vsize(CREATION_DATE), 0))
61: FROM
62: MTL_LOT_NUMBERS ;
63: --WHERE
64: --last_update_date between p_from_date and p_to_date ;
65:
66: CURSOR c_2 IS