DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 4514: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';

4510: IF PG_DEBUG <> 0 THEN
4511: WriteToLog('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
4512: END IF;
4513: lStmtNum := 315;
4514: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
4515:
4516:
4517:
4518:

Line 4519: insert into bom_substitute_components (

4515:
4516:
4517:
4518:
4519: insert into bom_substitute_components (
4520: substitute_component_id
4521: ,substitute_item_quantity
4522: ,component_sequence_id
4523: ,acd_type

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

4593: ,creation_date
4594: ,created_by
4595: ,last_update_login
4596: */
4597: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
4598: where b.bill_sequence_id = lConfigBillId
4599: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
4600: and bic.optional = 2 /* only mandatory components */
4601: and bic.component_sequence_id = s.component_sequence_id ;