APPS.ENG_CANCEL_ECO dependencies on MTL_ITEM_REVISIONS_B

Line 658: from MTL_ITEM_REVISIONS_B I

654: stmt_num := 60;
655:
656: delete from MTL_ITEM_REVISIONS_TL
657: where revision_id IN (select revision_id
658: from MTL_ITEM_REVISIONS_B I
659: WHERE CHANGE_NOTICE = change_order
660: AND ORGANIZATION_ID = org_id
661: AND IMPLEMENTATION_DATE IS NULL
662: AND INVENTORY_ITEM_ID IN

Line 670: DELETE FROM MTL_ITEM_REVISIONS_B I

666: AND R.ORGANIZATION_ID = org_id
667: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
668: AND R.CANCELLATION_DATE IS NOT NULL));
669:
670: DELETE FROM MTL_ITEM_REVISIONS_B I
671: WHERE CHANGE_NOTICE = change_order
672: AND ORGANIZATION_ID = org_id
673: AND IMPLEMENTATION_DATE IS NULL
674: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID

Line 1034: from MTL_ITEM_REVISIONS_B I

1030: from eng_revised_items I
1031: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1032:
1033: /*where revision_id IN (select revision_id
1034: from MTL_ITEM_REVISIONS_B I
1035: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1036: -- Modified where clause for performance bug 4251776
1037: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1038: WHERE revision_id IN (select new_item_revision_id

Line 1037: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586

1033: /*where revision_id IN (select revision_id
1034: from MTL_ITEM_REVISIONS_B I
1035: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1036: -- Modified where clause for performance bug 4251776
1037: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1038: WHERE revision_id IN (select new_item_revision_id
1039: from eng_revised_items I
1040: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1041: