eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_AUTO_ALLOC dependencies on IC_LOTS_MST

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

Line 400: FROM ic_item_mst i, ic_lots_mst l, ic_tran_pnd t

396: SELECT
397: P_session_id,t.item_id, -1, -1, l.lot_no, l.sublot_no, t.lot_id, l.lot_created,
398: l.expire_date, l.qc_grade, t.whse_code, t.location, 0, 0, t.trans_qty,
399: t.trans_qty2, 0, 0, 0, 0
400: FROM ic_item_mst i, ic_lots_mst l, ic_tran_pnd t
401: WHERE t.item_id = V_item_id
402: AND whse_code = V_whse_code
403: AND expire_date > V_trans_date
404: AND l.item_id = t.item_id