Search Results get_high_rev_date




Overview
Explore in AI Chat

Overview

BOM_REVISIONS is an Oracle EBS PL/SQL package owned by APPS that provides the revision resolution engine for Engineering and Bills of Material data. It centralizes the logic required to determine which item or routing revision is effective for a given organization, item, and point in time, applying filters for ECO status and revision implementation state. Because revision control is fundamental to manufacturing, sourcing, and planning, this package is a shared utility that allows callers to obtain a revision identifier, label, or date without directly querying the underlying engineering tables. The package header carries the source version identifier BOMREVSS.pls 120.1, indicating long-standing stability, and ETRM classifies the API as OTHER. It is referenced by 34 other packages, confirming its role as a low-level, dependency-heavy component of the BOM and Engineering family.

Key Procedures and Functions

  • GET_REVISION — Returns the current item or routing revision for a supplied date. It accepts selectivity arguments covering revision type (item versus routing), ECO status handling, and whether implemented, pending, or all revisions should be examined. It is the primary workhorse for date-effective revision retrieval.
  • GET_ITEM_REVISION_FN — A function variant of the same retrieval concept that returns NULL rather than erroring when no revision is defined for the requested date.
  • GET_ITEM_REVISION_ID_FN — Performs the equivalent lookup but returns the internal revision identifier rather than the revision label.
  • COMPARE_REVISION — Compares revisions, supporting determination of relative revision ordering or equality. This is the procedure associated with the user search term compare_revision.
  • GET_REV_DATE — Returns the effective date associated with a revision.
  • GET_HIGH_DATE and GET_HIGH_REV_DATE — Return high (end) dates for revision validity, supporting date-range boundaries used in effective-dating logic.
  • GET_ITEM_REVISION_LABEL_FN — Retrieves the display label of an item revision.
  • GET_REVISION_DETAILS — Returns the full set of attributes describing a revision.
  • GET_ITEM_REV_HIGHDATE — Returns the high date for a specific item revision.

Tables Accessed

The package reads engineering revision data through APPS synonyms. ENG_REVISED_ITEMS supplies ECO-linked revision and implementation records, including status information used by the ECO status filters. MTL_ITEM_REVISIONS_B holds the base item revision definitions, providing revision labels and identifiers. MTL_RTG_ITEM_REVISIONS provides routing revision associations, supporting retrieval when the type argument requests routing rather than item revisions. Together these tables allow the package to resolve both item and routing revisions across effective date ranges.

Usage Notes

BOM_REVISIONS is invoked from Oracle Engineering and Bills of Material forms, from concurrent programs that require date-effective revision determination, and from custom PL/SQL that must resolve revisions consistently with standard EBS behavior. The GET_REVISION parameter vocabulary — PART/PROCESS for type, ALL/EXCLUDE_HOLD/EXCLUDE_OPEN_HOLD for ECO status, and ALL/IMPL_ONLY/PEND_ONLY for examine type — should be used exactly as documented to avoid inconsistent results. The 34 dependent packages indicate that direct calls are common but that the package sits beneath higher-level APIs; customizations should prefer calling this package rather than querying the revision tables directly.