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