DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 3196: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';

3192: IF PG_DEBUG <> 0 THEN
3193: oe_debug_pub.add('create_bom_data_ml: ' || 'Before second insert into bom_inventory_components. ', 2);
3194: END IF;
3195: lStmtNum := 315;
3196: xTableName := 'BOM_SUBSTITUTE_COMPONENTS';
3197:
3198:
3199:
3200:

Line 3201: insert into bom_substitute_components (

3197:
3198:
3199:
3200:
3201: insert into bom_substitute_components (
3202: substitute_component_id
3203: ,substitute_item_quantity
3204: ,component_sequence_id
3205: ,acd_type

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

3276: ,created_by
3277: ,last_update_login
3278: */
3279:
3280: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
3281: where b.bill_sequence_id = pConfigBillId
3282: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
3283: and bic.optional = 2 /* only mandatory components */
3284: and bic.component_sequence_id = s.component_sequence_id ;