APPS.INV_LOT_AG dependencies on MTL_LOT_NUMBERS

Line 23: from mtl_lot_numbers

19: ORGANIZATION_ID ,
20: CREATION_DATE,
21: EXPIRATION_DATE,
22: ORIGINATION_DATE
23: from mtl_lot_numbers
24: where trunc(expiration_date) <= nvl(origination_date,creation_date);
25:
26: cursor cur_lots_all is
27: select ROWID,

Line 33: from mtl_lot_numbers;

29: ORGANIZATION_ID ,
30: CREATION_DATE,
31: EXPIRATION_DATE,
32: ORIGINATION_DATE
33: from mtl_lot_numbers;
34:
35: lot_rec cur_lots_all%rowtype;
36:
37: BEGIN

Line 68: update mtl_lot_numbers

64: then
65:
66: -- Updater the AGE column.
67: --dbms_output.put_line('before update');
68: update mtl_lot_numbers
69: set age= trunc(sysdate) - trunc(nvl(lot_rec.origination_date,lot_rec.creation_date))
70: where rowid = lot_rec.rowid;
71: end if;
72: end loop;

Line 94: update mtl_lot_numbers

90: if var_enabled > 0
91: then
92: -- Updater the AGE column.
93: --dbms_output.put_line('before update');
94: update mtl_lot_numbers
95: set age= trunc(sysdate) - trunc(nvl(lot_rec.origination_date,lot_rec.creation_date))
96: where rowid = lot_rec.rowid;
97: end if;
98: end loop;