DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_SUB_COMPS_INTERFACE

Line 4661: UPDATE bom_sub_comps_interface

4657:
4658: Write_Debug('Updating Substitute Components Interface records for Create... ' );
4659: -- (b) Substitute Components: CREATE/DELETE/UPDATE
4660: -----------------------------------------------------------------------------------------
4661: UPDATE bom_sub_comps_interface
4662: SET
4663: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4664: 'UPDATE', G_BOM_CHANGE_ACD_TYPE
4665: ,G_BOM_ADD_ACD_TYPE),

Line 5076: UPDATE bom_sub_comps_interface bsci

5072:
5073: Write_Debug('Deleting/Updating Substitute Components records for Create(Present in ECO)... ' );
5074: -- (f) Substitute Components:: DELETE/UPDATE: already present in ECO
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