APPS.GMD_SAMPLES_GRP dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2648: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731

2644:
2645: OPEN get_curr_lot_status_cv FOR
2646: SELECT lot_number,
2647: a.status_id
2648: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731
2649: WHERE a.inventory_item_id = l_inventory_item_id
2650: AND a.organization_id = l_organization_id
2651: AND ((a.parent_lot_number = l_parent_lot_number )
2652: OR ( a.lot_number = l_parent_lot_number

Line 3028: FROM mtl_item_locations_kfv

3024:
3025: -- Bug 4165704: changed for inventory convergence
3026: CURSOR c_locator IS
3027: SELECT 1
3028: FROM mtl_item_locations_kfv
3029: WHERE organization_id = p_sample.organization_id
3030: AND subinventory_code = p_sample.subinventory
3031: AND inventory_location_id = p_sample.locator_id;
3032:

Line 4668: FROM mtl_item_locations_kfv

4664: WHERE organization_id = orgn_id;
4665:
4666: CURSOR Cur_locator(loc_id NUMBER) IS
4667: SELECT concatenated_segments
4668: FROM mtl_item_locations_kfv
4669: WHERE inventory_location_id = loc_id;
4670:
4671: --RLNAGARA B5130051 modified parameter from sample_id to p_sample_id
4672: CURSOR Cur_disposition(p_sample_id NUMBER) IS

Line 4977: FROM mtl_item_locations_kfv

4973:
4974:
4975: CURSOR Cur_source_locator IS
4976: SELECT concatenated_segments
4977: FROM mtl_item_locations_kfv
4978: WHERE inventory_location_id = p_sample_display.source_locator_id;
4979:
4980: BEGIN
4981: IF (p_sample_display.inventory_item_id IS NOT NULL

Line 5032: FROM mtl_item_locations_kfv

5028:
5029: IS
5030: CURSOR Cur_locator IS
5031: SELECT concatenated_segments
5032: FROM mtl_item_locations_kfv
5033: WHERE inventory_location_id = p_locator_id;
5034:
5035: CURSOR Cur_subinventory IS
5036: SELECT Locator_type, -- locator control