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.GMI_RESERVATION_UTIL dependencies on IC_LOTS_MST

Line 3960: From ic_lots_mst

3956: --END BUG#3503593
3957:
3958: Cursor get_grade IS
3959: Select qc_grade
3960: From ic_lots_mst
3961: Where lot_id = p_lot_id;
3962:
3963: Cursor get_location(p_locator_id IN NUMBER) IS
3964: Select location

Line 5128: FROM IC_LOTS_MST

5124: l_api_name CONSTANT VARCHAR2 (30) := 'validate_lot_number';
5125:
5126: CURSOR get_lot_no (opm_item_id IN NUMBER) IS
5127: SELECT lot_no
5128: FROM IC_LOTS_MST
5129: WHERE item_id = opm_item_id
5130: AND lot_no = p_lot_number ;
5131:
5132: BEGIN

Line 5520: FROM ic_lots_mst ic

5516: l_return NUMBER;
5517:
5518: CURSOR cur_lot_id_with_sublot IS
5519: SELECT ic.lot_id
5520: FROM ic_lots_mst ic
5521: WHERE ic.item_id = l_ic_item_mst_rec.item_id
5522: AND ic.lot_no = p_lot_number
5523: AND ic.sublot_no = p_sublot_number;
5524:

Line 5527: FROM ic_lots_mst ic

5523: AND ic.sublot_no = p_sublot_number;
5524:
5525: CURSOR cur_lot_id_with_lot IS
5526: SELECT ic.lot_id
5527: FROM ic_lots_mst ic
5528: WHERE ic.item_id = l_ic_item_mst_rec.item_id
5529: AND ic.lot_no = p_lot_number
5530: AND ic.sublot_no IS NULL;
5531: