DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1085: DELETE from bom_substitute_components

1081: DELETE from bom_reference_designators
1082: WHERE component_sequence_id = p_rev_comp_unexp_rec.component_sequence_id ;
1083: -- p_component_sequence_id ;
1084:
1085: DELETE from bom_substitute_components
1086: WHERE component_Sequence_id = p_rev_comp_unexp_rec.component_sequence_id ;
1087: -- p_component_sequence_id ;
1088:
1089: --Bug 9356298 start

Line 1327: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

1323:
1324: /*
1325: ** Delete the Substitute Components and also the Reference Designators
1326: */
1327: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
1328: WHERE SC.COMPONENT_SEQUENCE_ID = comp_seq_id;
1329:
1330: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from bsc');
1331: