DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 355: from mtl_secondary_inventories msinv

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