1509:
1510:
1511:
1512:
1513: /* For standard costing orgs, we will copy model's user-defined
1514: cost in Frozen to the config in CTO cost type. */
1515:
1516: lStmtNumber := 50;
1517:
1856:
1857: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);
1858:
1859:
1860: /* For standard costing orgs, we will copy model's user-defined
1861: cost in Frozen to the config in CTO cost type. */
1862:
1863: lStmtNumber := 80;
1864: insert into cst_item_cost_details
3397: m.planning_time_fence_days,
3398: m.demand_time_fence_days,
3399: m.end_assembly_pegging_flag,
3400: m.planning_exception_set,
3401: 4, -- BOM_ITEM_TYPE:standard
3402: 'N',
3403: 'Y',
3404: m.inventory_item_id, -- Base Model ID
3405: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),
4141: decode( get_attribute_control( 'planning_time_fence_days' ) , 1, config.planning_time_fence_days, m.planning_time_fence_days) ,
4142: decode( get_attribute_control( 'demand_time_fence_days') , 1, config.demand_time_fence_days, m.demand_time_fence_days) ,
4143: decode( get_attribute_control( 'end_assembly_pegging_flag') ,1 , config.end_assembly_pegging_flag , m.end_assembly_pegging_flag) ,
4144: decode( get_attribute_control( 'planning_exception_set' ) , 1 , config.planning_exception_set, m.planning_exception_set) ,
4145: 4, -- BOM_ITEM_TYPE : standard
4146: 'N',
4147: 'Y',
4148: bcolu.inventory_item_id, -- Base Model ID
4149: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag)),