[Home] [Help]
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))
519: AND bos.implementation_date IS NULL; /*Added for bug 8583280 (FP of 6908447)*/
520:
521:
522: -- Delete routing revisions created by revised items on ECO
523: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
524: WHERE EXISTS (SELECT NULL
525: FROM ENG_REVISED_ITEMS ri
526: WHERE 1=1 /*rev.implementation_date IS NULL Commented for bug 8583280*/
527: AND rev.revised_item_sequence_id = ri.revised_item_sequence_id
559: END LOOP;
560:
561: IF (l_del_rtg_header = 1)
562: THEN
563: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
564: WHERE EXISTS (SELECT 1
565: FROM BOM_OPERATIONAL_ROUTINGS bor
566: WHERE bor.routing_sequence_id = l_routing_sequence_id
567: AND bor.alternate_routing_designator IS NULL