DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 5152: FROM bom_reference_designators brd,

5148: -----------------------------------------------------------------------------------------
5149: UPDATE bom_ref_desgs_interface brdi
5150: SET
5151: acd_type = (SELECT brd.acd_type
5152: FROM bom_reference_designators brd,
5153: bom_inventory_components bic
5154: WHERE brd.component_sequence_id = bic.component_sequence_id
5155: AND brd.component_reference_designator = brdi.component_reference_designator
5156: AND bic.revised_item_sequence_id = p_revised_item_sequence_id

Line 5171: FROM bom_reference_designators brd,

5167: AND brdi.batch_id = p_batch_id
5168: AND brdi.process_flag = G_CM_TO_BE_PROCESSED
5169: AND brdi.transaction_type in ('DELETE', 'UPDATE')
5170: AND exists (SELECT 1
5171: FROM bom_reference_designators brd,
5172: bom_inventory_components bic
5173: WHERE brd.component_sequence_id = bic.component_sequence_id
5174: AND brd.component_reference_designator = brdi.component_reference_designator
5175: AND bic.revised_item_sequence_id = p_revised_item_sequence_id