APPS.GMI_RESERVATION_UTIL dependencies on IC_LOTS_MST

Line 3948: From ic_lots_mst

3944: --END BUG#3503593
3945:
3946: Cursor get_grade IS
3947: Select qc_grade
3948: From ic_lots_mst
3949: Where lot_id = p_lot_id;
3950:
3951: Cursor get_location(p_locator_id IN NUMBER) IS
3952: Select location

Line 5116: FROM IC_LOTS_MST

5112: l_api_name CONSTANT VARCHAR2 (30) := 'validate_lot_number';
5113:
5114: CURSOR get_lot_no (opm_item_id IN NUMBER) IS
5115: SELECT lot_no
5116: FROM IC_LOTS_MST
5117: WHERE item_id = opm_item_id
5118: AND lot_no = p_lot_number ;
5119:
5120: BEGIN

Line 5508: FROM ic_lots_mst ic

5504: l_return NUMBER;
5505:
5506: CURSOR cur_lot_id_with_sublot IS
5507: SELECT ic.lot_id
5508: FROM ic_lots_mst ic
5509: WHERE ic.item_id = l_ic_item_mst_rec.item_id
5510: AND ic.lot_no = p_lot_number
5511: AND ic.sublot_no = p_sublot_number;
5512:

Line 5515: FROM ic_lots_mst ic

5511: AND ic.sublot_no = p_sublot_number;
5512:
5513: CURSOR cur_lot_id_with_lot IS
5514: SELECT ic.lot_id
5515: FROM ic_lots_mst ic
5516: WHERE ic.item_id = l_ic_item_mst_rec.item_id
5517: AND ic.lot_no = p_lot_number
5518: AND ic.sublot_no IS NULL;
5519: