APPS.ENG_CANCEL_ECO dependencies on BOM_COMPONENTS_B

Line 1149: FROM bom_components_b

1145: -- R12 changes for common bom
1146: -- Cursor to fetch all the related components for the specified component being cancelled
1147: CURSOR c_related_components IS
1148: SELECT component_sequence_id
1149: FROM bom_components_b
1150: WHERE common_component_sequence_id = comp_seq_id;
1151: Begin
1152: /*
1153: ** insert the cancelled rev components into eng_revised_components

Line 1301: DELETE FROM bom_components_b

1297: FOR crc IN c_related_components
1298: LOOP
1299: stmt_num := stmt_num+1;
1300: /* delete from bom_inventory_comps */
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