DBA Data[Home] [Help]

APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 94: FROM mtl_item_locations

90: IF l_rsv_rec.locator_id IS NOT NULL AND l_rsv_rec.organization_id IS NOT NULL THEN
91: BEGIN
92: SELECT NVL(reservable_type, 1)
93: INTO l_loc_reservable_type
94: FROM mtl_item_locations
95: WHERE organization_id = l_rsv_rec.organization_id
96: AND inventory_location_id = l_rsv_rec.locator_id;
97: EXCEPTION
98: WHEN OTHERS THEN