APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 401: from mtl_item_locations_kfv

397: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
398:
399: if p_eam_mat_req_rec.supply_locator_id is not null then
400: select 1 into g_dummy
401: from mtl_item_locations_kfv
402: where (disable_date > sysdate or disable_date is null)
403: and organization_id = p_eam_mat_req_rec.organization_id
404: and subinventory_code = p_eam_mat_req_rec.supply_subinventory
405: and inventory_location_id = p_eam_mat_req_rec.supply_locator_id;