[Home] [Help]
21: | 2. If it is, it determines if the order line is already |
22: | linked to a configuration item. If it is, it uses that |
23: | config item in the available quantity inquiry. If it |
24: | does not, it attempts to match the configuration from |
25: | oe_order_lines_all against bom_ato_configurations. |
26: | 3. If a configuration item exists, it calls Inventory's |
27: | API to query available quantity (on-hand and available |
28: | to reserve). If it has any quantity available to reserve |
29: | it returns true. |
196: RESERVATION_ERROR EXCEPTION;
197:
198:
199:
200: l_source_type_code oe_order_lines_all.source_type_code%type ;
201: l_booked_flag oe_order_lines_all.booked_flag%type ;
202:
203:
204:
197:
198:
199:
200: l_source_type_code oe_order_lines_all.source_type_code%type ;
201: l_booked_flag oe_order_lines_all.booked_flag%type ;
202:
203:
204:
205: cursor c_model_lines is
292:
293: l_stmt_num := 101;
294: select top_model_line_id, inventory_item_id
295: into l_top_model_line_id, l_top_model_item_id
296: from oe_order_lines_all
297: where line_id = p_model_line_id;
298:
299: IF PG_DEBUG <> 0 THEN
300: oe_debug_pub.add('Top Model Line Id: ' || to_char(l_top_model_line_id));
392: */
393:
394:
395: -- This is the part that will change. We need to do the following:
396: -- 1. Select and mark the lines in oe_order_lines_all
397: -- 2. Add lines in bom_cto_order_lines
398: -- 3. Match up the tree (stop as soon as an assly does not match)
399: -- 4. If the final assembly matches,
400: -- a. add sourcing info in bom_cto_src_orgs
446:
447: /* BUGFIX# 3484511 */
448: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) ,-99)
449: into lValidationOrg
450: from oe_order_lines_all oel
451: where oel.line_id = p_model_line_id ;
452:
453:
454:
753:
754: /* BUGFIX#2342412 */
755: select line_id, header_id , source_type_code , booked_flag
756: into l_config_line_id, l_header_id , l_source_type_code , l_booked_flag
757: from oe_order_lines_all
758: where ato_line_id = p_model_line_id
759: and item_type_code = 'CONFIG';
760:
761:
1126:
1127:
1128: end if; -- end l_x_config_id is not null
1129:
1130: -- clean up oe_order_lines_all batch_id column
1131:
1132: return TRUE;
1133:
1134: EXCEPTION
1221:
1222:
1223: /*****************************************************************************
1224: Function: create_config_reservation
1225: Parameters: p_model_line_id - line id of the top model in oe_order_lines_all
1226: p_config_item_id - config id of the matching configuration
1227: from bom_ato_configurations
1228: p_quantity_to_reserve - quantity to reserve in ordered_quantity_uom
1229: x_error_message - error message if match function fails
1336: from bom_calendar_dates cal,
1337: mtl_parameters mp,
1338: -- 4162494 wip_parameters wp,
1339: mtl_system_items msi,
1340: oe_order_lines_all oel
1341: where oel.line_id = l_config_line_id
1342: and mp.organization_id = oel.ship_from_org_id
1343: -- 4162494 and wp.organization_id = mp.organization_id
1344: and msi.organization_id = oel.ship_from_org_id
1391: )),
1392: --Bugfix 12374440
1393: p_subinventory_code
1394: into l_rec_reserve
1395: from oe_order_lines_all oel,
1396: oe_order_headers_all oeh,
1397: --oe_order_types_v oet,
1398: oe_transaction_types_tl oet,
1399: mtl_sales_orders mso,
1501: line allows a Match and Reserve to be performed.
1502: ***************************************************************/
1503: select oel.line_id, oel.inventory_item_id
1504: into x_config_line_id, x_config_item_id
1505: from oe_order_lines_all oel,
1506: mtl_system_items msi
1507: where oel.link_to_line_id = p_model_line_id
1508: and oel.item_type_code = 'CONFIG'
1509: and oel.inventory_item_id = msi.inventory_item_id