Search Results get_supersede_bilateral_items

Overview

CSP_SUPERSESSIONS_PVT is an internal (private) PL/SQL package in the APPS schema within Oracle E-Business Suite. It belongs to the CSP module, the component of Oracle's supply chain and order management integration layer that supports planning, supersession, and after-sales service data flow between EBS and external planning or service systems. The package encapsulates the business logic used to evaluate item supersession chains, detect superseded and replacement items, and validate the composition of parts within a supersession hierarchy.

Supersession refers to the practice of replacing one item with another — an engineering change, a discontinued component, or an updated service part — so that demand, planning, and service records resolve correctly to the currently valid item. CSP_SUPERSESSIONS_PVT provides the programmatic foundation for this resolution, determining whether a given item supersedes, is superseded by, or replaces another item in the relationship graph maintained in the EBS item master.

The package is classified as PVT, indicating it is an internal implementation package not intended as a public integration interface. Its procedures are consumed by other CSP packages rather than directly by external callers.

Key Procedures and Functions

• PROCESS_SUPERSESSIONS — The primary driver procedure. It orchestrates the evaluation of supersession relationships, iterating across the relevant item set and applying supersede logic to resolve the effective item representation.
• CHECK_FOR_SUPERSEDE_ITEM — Determines whether a given item participates in a supersede relationship, effectively validating the existence of supersession for the item under evaluation.
• GET_SUPERSEDE_BILATERAL_ITEMS — Retrieves items involved in bilateral (two-way) supersession relationships, where both directions of the replacement linkage are relevant.
• GET_TOP_SUPERSEDE_ITEM — Resolves and returns the topmost (terminal) item in a supersession chain, i.e., the currently valid replacement at the apex of the hierarchy.
• GET_REPLACED_ITEMS_LIST — Returns the list of items that have been replaced, supporting historical or downward traversal of the supersession graph.
• CHECK_FOR_DUPLICATE_PARTS — Validates whether duplicate parts exist within a supersession or parts composition, guarding against redundant or conflicting item definitions.

The package additionally exposes one further documented procedure, PROCESS_SUPERSESSIONS being the entry point, with the remainder serving as supporting resolution and validation routines.

Tables Accessed

The package reads and writes against a focused set of EBS item, inventory, and planning tables via APPS synonyms. CSP_SUPERSEDE_ITEMS is the core supersession repository and is central to the package's logic. MTL_SYSTEM_ITEMS_B and MTL_RELATED_ITEMS supply item master and item-relationship data. MTL_SECONDARY_INVENTORIES, MTL_ITEM_SUB_INVENTORIES, and MTL_PARAMETERS provide inventory organization and location context. MTL_SYSTEM_ITEMS_B is referenced for item attribute resolution. Planning context is drawn from CSP_PLANNING_PARAMETERS, CSP_PLAN_REORDERS, and CSP_SUPPLY_CHAIN, while CSP_SEC_INVENTORIES and PLITBLM support inventory and parts composition validation.

Usage Notes

CSP_SUPERSESSIONS_PVT is invoked indirectly rather than as a user-facing API. It is referenced by CSP_PROD_TASK_PARTS_HISTORY, CSP_SCH_INT_PVT, and by itself, indicating its role as a shared internal utility within the CSP scheduling and parts-history processing flow. Because it is a PVT package, direct invocation from forms or concurrent programs is not typical; instead, callers reach it through the public packages that depend on it. Any custom development should prefer the documented public CSP interfaces and treat this package as subject to change between 12.1.1 and 12.2.2 releases.