APPS.GMI_LOCT_INV_PVT dependencies on IC_LOTS_MST

Line 167: update ic_lots_mst

163: NULL; /* Not a yielding transaction */
164: ELSE
165: /* 3739308 - Set the dates to MAX date if the item is grade controlled and intervals
166: are NULL or zero */
167: update ic_lots_mst
168: set (lot_created, expire_date, retest_date, expaction_date) =
169: ( select nvl(lot_created, p_tran_rec.trans_date),
170: nvl(expire_date, decode (grade_ctl + nvl(shelf_life,0), 0,
171: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0))),