APPS.ENG_CANCEL_ECO dependencies on MTL_ITEM_REVISIONS_B

Line 642: from MTL_ITEM_REVISIONS_B I

638: stmt_num := 60;
639:
640: delete from MTL_ITEM_REVISIONS_TL
641: where revision_id IN (select revision_id
642: from MTL_ITEM_REVISIONS_B I
643: WHERE CHANGE_NOTICE = change_order
644: AND ORGANIZATION_ID = org_id
645: AND IMPLEMENTATION_DATE IS NULL
646: AND INVENTORY_ITEM_ID IN

Line 654: DELETE FROM MTL_ITEM_REVISIONS_B I

650: AND R.ORGANIZATION_ID = org_id
651: AND R.REVISED_ITEM_SEQUENCE_ID = I.REVISED_ITEM_SEQUENCE_ID
652: AND R.CANCELLATION_DATE IS NOT NULL));
653:
654: DELETE FROM MTL_ITEM_REVISIONS_B I
655: WHERE CHANGE_NOTICE = change_order
656: AND ORGANIZATION_ID = org_id
657: AND IMPLEMENTATION_DATE IS NULL
658: AND INVENTORY_ITEM_ID IN (SELECT REVISED_ITEM_ID

Line 1009: from MTL_ITEM_REVISIONS_B I

1005: from eng_revised_items I
1006: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1007:
1008: /*where revision_id IN (select revision_id
1009: from MTL_ITEM_REVISIONS_B I
1010: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1011: -- Modified where clause for performance bug 4251776
1012: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1013: WHERE revision_id IN (select new_item_revision_id

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

1008: /*where revision_id IN (select revision_id
1009: from MTL_ITEM_REVISIONS_B I
1010: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
1011: -- Modified where clause for performance bug 4251776
1012: DELETE FROM MTL_ITEM_REVISIONS_B I --Fix for bug 3215586
1013: WHERE revision_id IN (select new_item_revision_id
1014: from eng_revised_items I
1015: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
1016: