DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 3120: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';

3116: IF PG_DEBUG <> 0 THEN
3117: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3118: END IF;
3119: lStmtNum := 315;
3120: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
3121:
3122:
3123:
3124:

Line 3125: insert into bom_substitute_components (

3121:
3122:
3123:
3124:
3125: insert into bom_substitute_components (
3126: substitute_component_id
3127: ,substitute_item_quantity
3128: ,component_sequence_id
3129: ,acd_type

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

3200: ,created_by
3201: ,last_update_login
3202: */
3203:
3204: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
3205: where b.bill_sequence_id = pConfigBillId
3206: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
3207: and bic.optional = 2 /* only mandatory components */
3208: and bic.component_sequence_id = s.component_sequence_id ;