Results for “csp_pack_list_nav”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CSP_PACK_LIST_NAV view is a navigation-support construct within the Oracle E-Business Suite Spares Management (CSP) module. Its documented purpose is to drive the Packlist status to Packlist flow, meaning that it supplies the navigational metadata required to represent packlist headers as nodes inside a hierarchical status/flow UI (typically a tree or dashboard). The view is owned by the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2.

Because CSP is the module used to manage field service spares, depots, and replenishment, operators frequently need to move from a high-level status roll-up down into individual packlists. This view bridges that requirement: it joins the navigational node-type registry to the actual packlist header data, producing a row-per-packlist result set carrying label, node type, key, icon, and parent information. In reporting and integration terms, it is primarily consumed by CSP self-service/HTML navigation pages rather than by end-user ad-hoc reporting, though it can be queried directly by custom extensions.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over three referenced objects:

• CSP_NAV_NODE_TYPES (VIEW) — a navigational node-type registry that supplies the NODE_TYPE, ICON_NAME, and root key values.
• CSP_PACKLIST_HEADERS (SYNONYM) — the packlist header entity supplying the packlist number, header ID, organization, and status.
• CSP_PICK_UTILS (PACKAGE) — a utility package whose function CSP_GLOBAL_ORG_ID returns the current global organization identifier used to filter the header rows.

The view text confirms an inner join between CSP_NAV_NODE_TYPES and CSP_PACKLIST_HEADERS, restricted where NT.ROOT_KEY = 'CSP_PACKLIST' and NT.NODE_TYPE = 'PACK_LIST', and where the header's ORGANIZATION_ID equals the global organization returned by the package. Results are ordered by the first column (packlist number).

Key Columns

The documented column list, mapped to the view text, is as follows:

• LABEL — sourced from PH.PACKLIST_NUMBER; the human-readable text displayed for the node.
• NODE_TYPE — sourced from NT.NODE_TYPE; the constant value 'PACK_LIST', identifying the node category.
• NODE_KEY — sourced from PH.PACKLIST_HEADER_ID; the unique key used to link the node to the underlying packlist record.
• ICON_NAME — sourced from NT.ICON_NAME; the image/icon token associated with the node type.
• LEAF_FLAG — a literal 'N', indicating the node is not necessarily a terminal leaf.
• PARENT_NODE_TYPE — a literal 'PLIST_STATUS', identifying the parent node category.
• PARENT_NODE_KEY — sourced from PH.PACKLIST_STATUS; the status value that groups the packlist under its parent status node.

Common Use Cases and Queries

This view is queried when building or troubleshooting the CSP packlist navigation hierarchy, when reconciling which packlists appear under a given status, and when validating organization-level filtering. A representative query is:

• SELECT LABEL, NODE_KEY, PARENT_NODE_KEY FROM APPS.CSP_PACK_LIST_NAV ORDER BY LABEL; — lists all navigable packlists with their parent status.
• SELECT * FROM APPS.CSP_PACK_LIST_NAV WHERE PARENT_NODE_KEY = 'IN_TRANSIT'; — retrieves packlists grouped under a specific status.
• SELECT COUNT(*) FROM APPS.CSP_PACK_LIST_NAV; — verifies that the current global organization returns expected packlist rows.

Because organization scope is derived from CSP_PICK_UTILS.CSP_GLOBAL_ORG_ID, result sets depend on session context; queries executed outside the intended CSP runtime may return no rows. The view is read-only and should never be used as a DML target.