[Home] [Help]
479: -- The above table in descending order of detail, and with any non-matching records filtered out.
480: l_reservation_count NUMBER; -- The number of reservations for the line
481: l_all_reservation_count NUMBER; -- The number of reservations for the line
482: l_reservation_count_by_id NUMBER; -- The number of reservations returned when querying by reservation ID (should be 1)
483: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS header ID, which should be derived from the OE header ID
484: -- and used for reservation queries.
485: l_org_wide_res_id NUMBER := -1; -- If an org-wide reservation exists for the move order line, this variable will
486: -- contain its reservation ID.
487: l_res_tbl_index NUMBER; -- An index to the elements of the reservations table.
1969: -- All of the demand source and delivery information for the line which is being processed
1970: -- A local copy of the move order line record
1971: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
1972: -- The above table in descending order of detail, and with any non-matching records filtered out.
1973: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS header ID, which should be derived from the OE header ID
1974: l_res_ordered_index NUMBER; -- An index to the elements of the ordered and filtered reservations table.
1975: l_quantity_to_detail NUMBER; -- The quantity for the move order line which should be detailed.
1976: l_primary_uom VARCHAR2(3); -- The primary UOM for the item
1977: l_secondary_uom VARCHAR2(3); -- The primary UOM for the item
2202: IF (is_debug) THEN
2203: gmi_reservation_util.println('Process_Line after trans type ');
2204: END IF;
2205:
2206: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2207: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2208:
2209: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2210: IF NOT l_return_value THEN