DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_REF_DESGS_INTERFACE

Line 4744: UPDATE bom_ref_desgs_interface brdi

4740: -----------------------------------------------------------------------------------------
4741: Write_Debug('Updating Reference Designator Interface records for Create... ' );
4742: -- (a) Reference Designators: CREATE/DELETE/UPDATE
4743: -----------------------------------------------------------------------------------------
4744: UPDATE bom_ref_desgs_interface brdi
4745: SET
4746: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4747: 'UPDATE', G_BOM_CHANGE_ACD_TYPE
4748: ,G_BOM_ADD_ACD_TYPE),

Line 5149: UPDATE bom_ref_desgs_interface brdi

5145: -----------------------------------------------------------------------------------------
5146: Write_Debug('Deleting/Updating Reference Designator records for Create(Present in ECO)... ' );
5147: -- (d) Reference Designators:: DELETE/UPDATE: already present in ECO
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