[Home] [Help]
2558: l_stmt_num := 4 ;
2559: BEGIN
2560: select nvl(master_organization_id,-99) --bugfix 2646849: master_organization_id can be 0
2561: into l_validation_org
2562: from oe_order_lines_all oel,
2563: oe_system_parameters_all ospa
2564: where oel.line_id = p_shipset.identifier(1)
2565: and nvl(oel.org_id,-1) = nvl(ospa.org_id,-1) --bug 1531691
2566: and oel.inventory_item_id = p_shipset.inventory_item_id(1) ;
2636: , p_orig_shipset_tracker(j).build_in_wip_flag
2637: , p_orig_shipset_tracker(j).atp_flag
2638: , p_orig_shipset_tracker(j).atp_components_flag
2639: , p_orig_shipset_tracker(j).mlmo_flag -- 2723674 : Initializing MLMO flag
2640: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2641: where line_id = p_shipset.identifier(j)
2642: and OEOL.component_sequence_id = BIC.component_sequence_id(+)
2643: and MSYI.inventory_item_id = p_shipset.inventory_item_id(j)
2644: and MSYI.organization_id = l_validation_org
5462:
5463: -- The structure of BOM_CTO_ORDER_TABLE
5464: -- Table Name : Bom_Cto_order_lines_all
5465: -- Bcod_line_id ====> Unique sequence no (Primary Key)
5466: -- Oe_line_id ====> line_id from OE_order_lines_all table
5467: -- Ato_line_id ====> Top ato model line_id (Mainly used to flush the
5468: -- data with respect to a model)
5469: -- Inventory_item_id ====> Inventory_item_id of the model/option class/
5470: -- option item
5492: PROCEDURE Create_demand_line(
5493: p_session_id IN Number,
5494: p_line_id IN Number,
5495: p_ato_line_id IN Number,
5496: p_inventory_item_id IN oe_order_lines_all.inventory_item_id%type,
5497: p_org_id IN Number,
5498: p_forecast_flag IN Varchar2,
5499: p_demand_flag IN Varchar2,
5500: p_config_line IN varchar2
5575: l_required_qty number;
5576: l_order_qty number;
5577: l_order_quantity_uom varchar2(3);
5578: l_record_count number;
5579: l_header_id oe_order_lines_all.header_id%type;
5580: x_lead_time number;
5581: l_fixed_lead_time number;
5582: l_variable_lead_time number;
5583: l_stmt_num number;
5936: msi.bom_item_type
5937: into l_par_line_id,
5938: l_par_inventory_item_id,
5939: l_par_bom_item_type
5940: from oe_order_lines_all oel,
5941: mtl_system_items msi
5942: where oel.line_id = g_final_cto_shipset(i).link_to_line_id
5943: and oel.inventory_item_id = msi.inventory_item_id
5944: and oel.ship_from_org_id = msi.organization_id;
5959: END IF;
5960:
5961: select order_quantity_uom,ordered_quantity
5962: into l_order_quantity_uom,l_order_qty
5963: from oe_order_lines_all
5964: where line_id = g_final_cto_shipset(i).line_id;
5965:
5966: IF PG_DEBUG <> 0 THEN
5967: oe_debug_pub.add('CREATE_CTO_MODEL_DEMAND: ' || ' order_quantity_uom ' || l_order_quantity_uom , 1);
5991: l_order_quantity_uom,
5992: l_header_id,
5993: l_record_count
5994: from MRP_ATP_DETAILS_TEMP ATP,
5995: OE_ORDER_LINES_ALL OEL
5996: where ATP.session_id = p_session_id
5997: and ATP.component_identifier = g_final_cto_shipset(i).link_to_line_id
5998: and ATP.inventory_item_id = l_par_inventory_item_id
5999: and ATP.organization_id = g_final_cto_shipset(i).sourcing_org
6279: END IF;
6280:
6281: SELECT 'Y'
6282: INTO x_config_exists
6283: FROM OE_ORDER_LINES_ALL
6284: WHERE ato_line_id = p_ato_line_id
6285: AND ITEM_TYPE_CODE = 'CONFIG';
6286:
6287: return x_config_exists;
6301: PROCEDURE create_demand_line(
6302: p_session_id IN Number,
6303: p_line_id IN Number,
6304: p_ato_line_id IN Number,
6305: p_inventory_item_id IN oe_order_lines_all.inventory_item_id%type,
6306: p_org_id IN Number,
6307: p_forecast_flag IN Varchar2,
6308: p_demand_flag IN Varchar2,
6309: p_config_line IN varchar2) is
6312: l_required_date date;
6313: l_required_qty number;
6314: l_order_quantity_uom varchar2(3);
6315: l_record_count number;
6316: l_header_id oe_order_lines_all.header_id%type;
6317: l_line_id oe_order_lines_all.line_id%type;
6318: l_org_id mtl_system_items.organization_id%type;
6319: l_inv_item_id mtl_system_items.inventory_item_id%type;
6320: ATP_NO_RECORD_ERROR EXCEPTION;
6313: l_required_qty number;
6314: l_order_quantity_uom varchar2(3);
6315: l_record_count number;
6316: l_header_id oe_order_lines_all.header_id%type;
6317: l_line_id oe_order_lines_all.line_id%type;
6318: l_org_id mtl_system_items.organization_id%type;
6319: l_inv_item_id mtl_system_items.inventory_item_id%type;
6320: ATP_NO_RECORD_ERROR EXCEPTION;
6321: l_stmt_no number;
6332: oe_debug_pub.add('create_demand_line: ' || 'Entering create_demand_line procedure...',1);
6333: END IF;
6334: l_stmt_no := 10;
6335: IF p_config_line = 'Y' THEN
6336: -- Select the config line info from oe_order_lines_all
6337: l_stmt_no := 20;
6338: SELECT line_id,
6339: inventory_item_id,
6340: ship_from_org_id
6341: INTO
6342: l_line_id,
6343: l_inv_item_id,
6344: l_org_id
6345: FROM OE_ORDER_LINES_ALL
6346: WHERE
6347: ato_line_id = p_ato_line_id
6348: AND item_type_code = 'CONFIG';
6349: ELSE
6382: l_header_id,
6383: l_record_count
6384: FROM
6385: MRP_ATP_DETAILS_TEMP ATP,
6386: OE_ORDER_LINES_ALL OEL
6387: WHERE
6388: ATP.session_id = p_session_id
6389: AND ATP.component_identifier = p_line_id
6390: AND ATP.inventory_item_id = p_inventory_item_id
6551: oeol.ship_from_org_id,
6552: oeol.ordered_quantity,
6553: oeol.schedule_ship_date,
6554: oeol.order_quantity_uom
6555: FROM oe_order_lines_all oeol
6556: WHERE
6557: oeol.open_flag = 'Y' /* SRS added for performance to retrieve only open orde
6558: rs */
6559: AND oeol.ship_from_org_id is not null