Search Results get_order_lines

Overview

CTO_WIP_WRAPPER is an Oracle Manufacturing utility package owned by APPS and classified as OTHER in the ETRM repository. Its documented purpose is to provide the utilities required to create work orders for ATO (Assemble-to-Order) configurations. The package header comment identifies insert_wip_interface as a core routine that inserts a record into WIP_JOB_SCHEDULE_INTERFACE so that WIP_MASS_LOAD can subsequently create the discrete work orders needed to build configured items. In Oracle EBS 12.1.1 and 12.2.2, this package therefore sits between the order management/configuration flow and the Work in Process job creation flow, automating the transition from a booked configuration to shop-floor execution.

The package has evolved considerably since its initial version (August 1999, Angela Makalintal). Documented history entries describe fixes for ATO items under PTO models (where item_type_code is 'OPTION' and top_model_line_id is not null), partial FAS support, and a change to prevent the batch program from picking up Buy config/ATO item orders — this check was added specifically to get_order_lines. Later revisions replaced fnd_file debug calls with oe_debug_pub and corrected quantity logic to compare against ordered_quantity rather than ordered_quantity minus cancelled_quantity, since a canceled line may leave OQ unchanged.

Key Procedures and Functions

• GET_ORDER_LINES — The procedure explicitly named in the user's search term "get_order_lines." It identifies and returns the sales order lines eligible for ATO work order creation. Its documented evolution includes the fix prohibiting procurement of Buy configurations and ATO item orders, and the adjustment to ordered/cancelled quantity logic (bug 2017099).
• RESERVE_WO_TO_SO — Creates reservations linking work order supply to the originating sales order demand, supporting the ATO supply-demand relationship and coordinating with MTL_RESERVATIONS.
• GET_RESERVED_QTY — Returns the quantity already reserved for a given work order or sales order context, used to avoid over-reserving or duplicate supply linkage.
• GET_NOTINV_QTY — Returns the not-invoiced quantity associated with an order line, supporting determination of remaining demand that still requires build and shipment.

Tables Accessed

The package reads order management data via OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_TRANSACTION_TYPES_TL, and work order execution data via WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_FLOW_SCHEDULES, WIP_JOB_SCHEDULE_INTERFACE, and WIP_JOB_SCHEDULE_INTERFACE_S. Item and routing information is drawn from MTL_SYSTEM_ITEMS and BOM_OPERATIONAL_ROUTINGS. Reservation logic references MTL_RESERVATIONS and MTL_SALES_ORDERS. FND_LANGUAGES supports translated lookups, and DUAL supports scalar expression evaluation. WIP_JOB_SCHEDULE_INTERFACE and its child table WIP_JOB_SCHEDULE_INTERFACE_S are the write targets consumed by WIP_MASS_LOAD.

Usage Notes

This package is an internal implementation layer invoked during the ATO order flow rather than a formally published public API; its classification as OTHER reflects that status. It is referenced by two other packages, indicating inter-package dependency within the ATO/WIP creation chain. Typical invocation occurs through the concurrent or batch process that generates work orders for ATO configurations, where the package stages records in WIP_JOB_SCHEDULE_INTERFACE for WIP_MASS_LOAD. Custom extensions should treat these procedures as non-public and verify signatures against the installed 12.1.1 or 12.2.2 code prior to use.