APPS.ENG_CANCEL_ECO dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 173: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

169: /*
170: ** delete substitute components of all pending revised items on ECO
171: */
172: stmt_num := 20;
173: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
174: WHERE SC.COMPONENT_SEQUENCE_ID IN
175: (SELECT IC.COMPONENT_SEQUENCE_ID
176: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
177: WHERE RI.ORGANIZATION_ID = org_id

Line 873: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

869: /*
870: ** delete substitute components of all pending revised items on ECO
871: */
872: stmt_num := 20;
873: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
874: WHERE SC.COMPONENT_SEQUENCE_ID IN
875: (SELECT IC.COMPONENT_SEQUENCE_ID
876: FROM BOM_INVENTORY_COMPONENTS IC
877: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);

Line 1282: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

1278:
1279: /*
1280: ** Delete the Substitute Components and also the Reference Designators
1281: */
1282: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1283: WHERE SC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1284:
1285: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bsc');
1286:

Line 1305: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

1301: DELETE FROM bom_components_b
1302: WHERE COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1303: stmt_num := stmt_num+1;
1304: /* delete the Substitute Components and also the Reference Designators */
1305: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1306: WHERE SC.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1307: /* Delete reference designators of all pending revised items on ECO */
1308: stmt_num := stmt_num+1;
1309: DELETE FROM BOM_REFERENCE_DESIGNATORS RD