DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 5185: FROM bom_substitute_components bsc,

5181: -----------------------------------------------------------------------------------------
5182: UPDATE bom_sub_comps_interface bsci
5183: SET
5184: acd_type = (SELECT bsc.acd_type
5185: FROM bom_substitute_components bsc,
5186: bom_inventory_components bic
5187: WHERE bsc.component_sequence_id = bic.component_sequence_id
5188: AND bsc.substitute_component_id = bsci.substitute_component_id
5189: AND bic.revised_item_sequence_id = p_revised_item_sequence_id

Line 5204: FROM bom_substitute_components bsc,

5200: AND bsci.batch_id = p_batch_id
5201: AND bsci.process_flag = G_CM_TO_BE_PROCESSED
5202: AND bsci.transaction_type in ('DELETE', 'UPDATE')
5203: AND exists (SELECT 1
5204: FROM bom_substitute_components bsc,
5205: bom_inventory_components bic
5206: WHERE bsc.component_sequence_id = bic.component_sequence_id
5207: AND bsc.substitute_component_id = bsci.substitute_component_id
5208: AND bic.revised_item_sequence_id = p_revised_item_sequence_id