DBA Data[Home] [Help]

APPS.ENG_CANCEL_ECO dependencies on BOM_COMPONENTS_B

Line 1117: FROM bom_components_b

1113: -- R12 changes for common bom
1114: -- Cursor to fetch all the related components for the specified component being cancelled
1115: CURSOR c_related_components IS
1116: SELECT component_sequence_id
1117: FROM bom_components_b
1118: WHERE common_component_sequence_id = comp_seq_id;
1119: Begin
1120: /*
1121: ** insert the cancelled rev components into eng_revised_components

Line 1269: DELETE FROM bom_components_b

1265: FOR crc IN c_related_components
1266: LOOP
1267: stmt_num := stmt_num+1;
1268: /* delete from bom_inventory_comps */
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