DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1741: select count(*) into l_mat_req_exists from wip_requirement_operations

1737: and inventory_item_id = p_eam_wo_rec.asset_activity_id
1738: and eam_item_type = 2;
1739:
1740: -- asset activity should not allowed to be updated if the wo has any ops or mat reqs.
1741: select count(*) into l_mat_req_exists from wip_requirement_operations
1742: where wip_entity_id = p_eam_wo_rec.wip_entity_id
1743: and organization_id = p_eam_wo_rec.organization_id;
1744:
1745: if nvl(p_eam_wo_rec.asset_activity_id,-99999) <> nvl(p_old_eam_wo_rec.asset_activity_id,-99999)