DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 4697: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';

4693: IF PG_DEBUG <> 0 THEN
4694: WriteToLog('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
4695: END IF;
4696: lStmtNum := 315;
4697: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
4698:
4699:
4700:
4701:

Line 4702: insert into bom_substitute_components (

4698:
4699:
4700:
4701:
4702: insert into bom_substitute_components (
4703: substitute_component_id
4704: ,substitute_item_quantity
4705: ,component_sequence_id
4706: ,acd_type

Line 4780: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s

4776: ,creation_date
4777: ,created_by
4778: ,last_update_login
4779: */
4780: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
4781: where b.bill_sequence_id = lConfigBillId
4782: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
4783: and bic.optional = 2 /* only mandatory components */
4784: and bic.component_sequence_id = s.component_sequence_id ;