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)