APPS.ENG_CANCEL_ECO dependencies on MTL_RTG_ITEM_REVISIONS

Line 67: from MTL_RTG_ITEM_REVISIONS mriv

63: where bor2.organization_id = bor.organization_id
64: and bor2.assembly_item_id = bor.assembly_item_id
65: and bor2.alternate_routing_designator is not null)
66: and not exists (select null
67: from MTL_RTG_ITEM_REVISIONS mriv
68: where mriv.organization_id = bor.organization_id
69: and mriv.inventory_item_id = bor.assembly_item_id
70: and mriv.implementation_date is not null
71: and mriv.change_notice is null))

Line 508: DELETE FROM MTL_RTG_ITEM_REVISIONS rev

504: AND ri.change_notice = change_order
505: ) ;
506:
507: -- Delete routing revisions created by revised items on ECO
508: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
509: WHERE EXISTS (SELECT NULL
510: FROM ENG_REVISED_ITEMS ri
511: WHERE rev.implementation_date IS NULL
512: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id

Line 547: DELETE FROM MTL_RTG_ITEM_REVISIONS rev

543: END LOOP;
544:
545: IF (l_del_rtg_header = 1)
546: THEN
547: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
548: WHERE EXISTS (SELECT 1
549: FROM BOM_OPERATIONAL_ROUTINGS bor
550: WHERE bor.routing_sequence_id = l_routing_sequence_id
551: AND bor.alternate_routing_designator IS NULL