DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 5079: FROM bom_substitute_components bsc,

5075: -----------------------------------------------------------------------------------------
5076: UPDATE bom_sub_comps_interface bsci
5077: SET
5078: acd_type = (SELECT bsc.acd_type
5079: FROM bom_substitute_components bsc,
5080: bom_inventory_components bic
5081: WHERE bsc.component_sequence_id = bic.component_sequence_id
5082: AND bsc.substitute_component_id = bsci.substitute_component_id
5083: AND bic.revised_item_sequence_id = p_revised_item_sequence_id

Line 5098: FROM bom_substitute_components bsc,

5094: AND bsci.batch_id = p_batch_id
5095: AND bsci.process_flag = G_CM_TO_BE_PROCESSED
5096: AND bsci.transaction_type in ('DELETE', 'UPDATE')
5097: AND exists (SELECT 1
5098: FROM bom_substitute_components bsc,
5099: bom_inventory_components bic
5100: WHERE bsc.component_sequence_id = bic.component_sequence_id
5101: AND bsc.substitute_component_id = bsci.substitute_component_id
5102: AND bic.revised_item_sequence_id = p_revised_item_sequence_id