APPS.GML_AUTO_ALLOC dependencies on IC_LOCT_INV

Line 378: FROM ic_lots_mst l, ic_loct_inv b, ic_lots_sts s

374: l.lot_id, l.lot_created, l.expire_date,
375: l.qc_grade, b.whse_code, b.location,
376: b.loct_onhand, b.loct_onhand2, 0,
377: 0, 0, 0, 0, 0
378: FROM ic_lots_mst l, ic_loct_inv b, ic_lots_sts s
379: WHERE l.item_id = V_item_id
380: AND whse_code = V_whse_code
381: AND expire_date > V_trans_date
382: AND l.inactive_ind = 0