DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 359: from mtl_secondary_inventories msinv

355: if (p_eam_mat_req_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
356:
357: if p_eam_mat_req_rec.supply_subinventory is not null then
358: select 1 into g_dummy
359: from mtl_secondary_inventories msinv
360: where nvl(msinv.disable_date, sysdate+2) > sysdate
361: and msinv.organization_id = p_eam_mat_req_rec.organization_id
362: and msinv.secondary_inventory_name = p_eam_mat_req_rec.supply_subinventory;
363: end if;