[Home] [Help]
515: -- The above table in descending order of detail, and with any non-matching records filtered out.
516: l_reservation_count NUMBER; -- The number of reservations for the line
517: l_all_reservation_count NUMBER; -- The number of reservations for the line
518: l_reservation_count_by_id NUMBER; -- The number of reservations returned when querying by reservation ID (should be 1)
519: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS header ID, which should be derived from the OE header ID
520: -- and used for reservation queries.
521: l_org_wide_res_id NUMBER := -1; -- If an org-wide reservation exists for the move order line, this variable will
522: -- contain its reservation ID.
523: l_res_tbl_index NUMBER; -- An index to the elements of the reservations table.
2266: -- All of the demand source and delivery information for the line which is being processed
2267: -- A local copy of the move order line record
2268: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
2269: -- The above table in descending order of detail, and with any non-matching records filtered out.
2270: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS header ID, which should be derived from the OE header ID
2271: l_res_ordered_index NUMBER; -- An index to the elements of the ordered and filtered reservations table.
2272: l_quantity_to_detail NUMBER; -- The quantity for the move order line which should be detailed.
2273: l_primary_uom VARCHAR2(3); -- The primary UOM for the item
2274: l_secondary_uom VARCHAR2(3); -- The primary UOM for the item
2520: IF (is_debug) THEN
2521: gmi_reservation_util.println('Process_Line after trans type ');
2522: END IF;
2523:
2524: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2525: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2526:
2527: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2528: IF NOT l_return_value THEN