Search Results orders_tree




Overview
Explore in AI Chat

Overview

MSC_OWB_TREE is an Oracle Advanced Supply Chain Planning (ASCP) PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER. Its purpose is to assemble and expose the hierarchical tree structures that the planning user interface and Oracle Web Builder (OWB) reporting layer use to navigate planning data. The package defines the three principal tree families used by the planning workbench — the exceptions tree (EXCP_TREE, node 1), the items tree (ITEMS_TREE, node 2), and the orders tree (ORDERS_TREE, node 3) — and it centralizes the MFG_LOOKUPS lookup codes that classify each node type, such as ORGANIZATIONS (2), CATEGORIES (12), EXCEPTIONS (18), SALES_ORDERS (30), SHIP_SETS (31), ARRIVAL_SETS (32), SHORTAGE (33), ITEMS (4), SOURCES (51), and ERRORS (54). The constants NODES_IN_EXCP_TREE (8), NODES_IN_ORDERS_TREE (5), and NODES_IN_ITEMS_TREE (7) fix the expected depth of each tree, while DELIMITER and LABEL_DELIM ('$') define how composite path labels are concatenated. The package header also declares a set of icon identifiers used to render nodes, including ICON_DEMAND ('afplan'), ICON_MAKE_AT ('mscmake1'), ICON_TRANSFER ('msctxfer'), ICON_BUY ('mscsupps'), and ICON_SUP_CAP ('mscsuppg'). The package is referenced by two other packages within the ASCP schema, indicating that it acts as a foundational utility rather than an entry-point program.

Key Procedures and Functions

  • GETSTRUCTURE — Returns the hierarchical layout of a requested tree (exceptions, items, or orders), providing the parent/child topology consumed by the planning UI.
  • GET_EXCP_COUNT — Supplies the count of exceptions associated with a node or scope, used to drive exception badges and summary displays.
  • GET_CUST_HIER_STRING — Builds the customer hierarchy string representation used when presenting customer or demand-side nodal paths.
  • GET_DEMAND_CLASS — Derives the demand classification for a given record. This is the procedure surfaced by the search term "get_demand_class" and is typically used to categorize demand entries so the correct tree branch and icon are applied.
  • GET_SOURCING_NODES — Returns sourcing-related nodes, mapping supply sources to their position within the planning tree.
  • GET_LOOKUPS — Retrieves lookup values from MFG_LOOKUPS, supporting the node-type codes enumerated in the package constants.

Tables Accessed

The package references two tables through APPS synonyms. MRP_ATP_DETAILS_TEMP is the temporary ATP/planning detail table from which demand records, quantities, and dates are sourced; it underpins GET_DEMAND_CLASS and the exception-tree assembly. PLITBLM is a generic planning index/lookup table used to resolve codes and labels during node construction. Because the package is compiled AUTHID CURRENT_USER, access to these objects is resolved against the invoking schema's privileges at runtime, which is significant when the package is called from custom code or cross-schema planning programs.

Usage Notes

MSC_OWB_TREE is not an end-user entry point; it is invoked internally by other ASCP packages (two documented referrers) and by the planning workbench forms and OWB reports that render the exceptions, items, and orders trees. In EBS 12.1.1 and 12.2.2 it runs in the context of the planning manager and the Web-based ASCP UI. Custom integrations should call it only to retrieve tree metadata or demand classification, and must ensure the calling schema owns or has been granted EXECUTE on the APPS package plus SELECT on the referenced planning tables, since AUTHID CURRENT_USER defers privilege resolution to the caller.