DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

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

1817: and inventory_item_id = p_eam_wo_rec.asset_activity_id
1818: and eam_item_type = 2;
1819:
1820: -- asset activity should not allowed to be updated if the wo has any ops or mat reqs.
1821: select count(*) into l_mat_req_exists from wip_requirement_operations
1822: where wip_entity_id = p_eam_wo_rec.wip_entity_id
1823: and organization_id = p_eam_wo_rec.organization_id;
1824:
1825: if nvl(p_eam_wo_rec.asset_activity_id,-99999) <> nvl(p_old_eam_wo_rec.asset_activity_id,-99999)