DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 5046: FROM bom_reference_designators brd,

5042: -----------------------------------------------------------------------------------------
5043: UPDATE bom_ref_desgs_interface brdi
5044: SET
5045: acd_type = (SELECT brd.acd_type
5046: FROM bom_reference_designators brd,
5047: bom_inventory_components bic
5048: WHERE brd.component_sequence_id = bic.component_sequence_id
5049: AND brd.component_reference_designator = brdi.component_reference_designator
5050: AND bic.revised_item_sequence_id = p_revised_item_sequence_id

Line 5065: FROM bom_reference_designators brd,

5061: AND brdi.batch_id = p_batch_id
5062: AND brdi.process_flag = G_CM_TO_BE_PROCESSED
5063: AND brdi.transaction_type in ('DELETE', 'UPDATE')
5064: AND exists (SELECT 1
5065: FROM bom_reference_designators brd,
5066: bom_inventory_components bic
5067: WHERE brd.component_sequence_id = bic.component_sequence_id
5068: AND brd.component_reference_designator = brdi.component_reference_designator
5069: AND bic.revised_item_sequence_id = p_revised_item_sequence_id