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_TRAN_PND

Line 23: FROM ic_tran_pnd

19: CURSOR Cur_check_alloc IS
20: SELECT 1
21: FROM sys.dual
22: WHERE EXISTS (SELECT 1
23: FROM ic_tran_pnd
24: WHERE line_id = V_line_id
25: AND (lot_id > 0 OR location <> P_default_loct)
26: AND delete_mark = 0
27: AND doc_type = 'OPSO'

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