DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 397: from mtl_item_locations_kfv

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