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_ITEM_MST

Line 10: FROM ic_item_mst

6: V_grade_wanted VARCHAR2, V_sched_shipdate DATE) RETURN NUMBER IS
7: CURSOR Cur_get_item_details IS
8: SELECT item_no, lot_ctl, loct_ctl, grade_ctl, alloc_class, item_um, item_um2, dualum_ind,
9: lot_indivisible
10: FROM ic_item_mst
11: WHERE item_id = V_item_id;
12: ItemDetailsRec Cur_get_item_details%ROWTYPE;
13:
14: CURSOR Cur_get_whse_details IS

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