DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_REF_DESGS_INTERFACE

Line 4638: UPDATE bom_ref_desgs_interface brdi

4634: -----------------------------------------------------------------------------------------
4635: Write_Debug('Updating Reference Designator Interface records for Create... ' );
4636: -- (a) Reference Designators: CREATE/DELETE/UPDATE
4637: -----------------------------------------------------------------------------------------
4638: UPDATE bom_ref_desgs_interface brdi
4639: SET
4640: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4641: 'UPDATE', G_BOM_CHANGE_ACD_TYPE
4642: ,G_BOM_ADD_ACD_TYPE),

Line 5043: UPDATE bom_ref_desgs_interface brdi

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