APPS.GMD_SAMPLES_GRP dependencies on MTL_ITEM_LOCATIONS_KFV

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

2926:
2927: OPEN get_curr_lot_status_cv FOR
2928: SELECT lot_number,
2929: a.status_id
2930: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731
2931: WHERE a.inventory_item_id = l_inventory_item_id
2932: AND a.organization_id = l_organization_id
2933: AND ((a.parent_lot_number = l_parent_lot_number )
2934: OR ( a.lot_number = l_parent_lot_number

Line 3623: FROM mtl_item_locations_kfv

3619:
3620: -- Bug 4165704: changed for inventory convergence
3621: CURSOR c_locator IS
3622: SELECT 1
3623: FROM mtl_item_locations_kfv
3624: WHERE organization_id = p_sample.organization_id
3625: AND subinventory_code = p_sample.subinventory
3626: AND inventory_location_id = p_sample.locator_id;
3627:

Line 5313: FROM mtl_item_locations_kfv

5309: WHERE organization_id = orgn_id;
5310:
5311: CURSOR Cur_locator(loc_id NUMBER) IS
5312: SELECT concatenated_segments
5313: FROM mtl_item_locations_kfv
5314: WHERE inventory_location_id = loc_id;
5315:
5316: --RLNAGARA B5130051 modified parameter from sample_id to p_sample_id
5317: CURSOR Cur_disposition(p_sample_id NUMBER) IS

Line 5645: FROM mtl_item_locations_kfv

5641:
5642:
5643: CURSOR Cur_source_locator IS
5644: SELECT concatenated_segments
5645: FROM mtl_item_locations_kfv
5646: WHERE inventory_location_id = p_sample_display.source_locator_id;
5647:
5648: BEGIN
5649: IF (p_sample_display.inventory_item_id IS NOT NULL

Line 5700: FROM mtl_item_locations_kfv

5696:
5697: IS
5698: CURSOR Cur_locator IS
5699: SELECT concatenated_segments
5700: FROM mtl_item_locations_kfv
5701: WHERE inventory_location_id = p_locator_id;
5702:
5703: CURSOR Cur_subinventory IS
5704: SELECT Locator_type, -- locator control