APPS.ENG_CANCEL_ECO dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 168: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

164: /*
165: ** delete substitute components of all pending revised items on ECO
166: */
167: stmt_num := 20;
168: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
169: WHERE SC.COMPONENT_SEQUENCE_ID IN
170: (SELECT IC.COMPONENT_SEQUENCE_ID
171: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
172: WHERE RI.ORGANIZATION_ID = org_id

Line 848: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

844: /*
845: ** delete substitute components of all pending revised items on ECO
846: */
847: stmt_num := 20;
848: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
849: WHERE SC.COMPONENT_SEQUENCE_ID IN
850: (SELECT IC.COMPONENT_SEQUENCE_ID
851: FROM BOM_INVENTORY_COMPONENTS IC
852: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);

Line 1250: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

1246:
1247: /*
1248: ** Delete the Substitute Components and also the Reference Designators
1249: */
1250: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1251: WHERE SC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1252:
1253: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bsc');
1254:

Line 1273: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

1269: DELETE FROM bom_components_b
1270: WHERE COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1271: stmt_num := stmt_num+1;
1272: /* delete the Substitute Components and also the Reference Designators */
1273: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1274: WHERE SC.COMPONENT_SEQUENCE_ID = crc.COMPONENT_SEQUENCE_ID;
1275: /* Delete reference designators of all pending revised items on ECO */
1276: stmt_num := stmt_num+1;
1277: DELETE FROM BOM_REFERENCE_DESIGNATORS RD