Search Results get_category

Overview

GMF_CBOM_REP_PKG is a PL/SQL reporting support package in the Oracle EBS Process Manufacturing (OPM) module, owned by the APPS schema and classified as an OTHER API. It serves the Costed Bill of Material (CBOM) reporting requirements of process manufacturers by supplying the data retrieval and lookup logic used by the associated Oracle Reports report. The package encapsulates the SQL fragments, costing lookups, item and category resolution functions, and period derivation logic required to render costed BOM information for a given organization, cost type, and accounting period. Rather than exposing a transactional business API, GMF_CBOM_REP_PKG functions as a report helper: its procedures and functions are called from report triggers and format triggers to dynamically build query clauses and translate surrogate identifiers into user-facing values.

Key Procedures and Functions

The package exposes ten documented functions, each oriented to report execution:

• BeforeReportTrigger — Standard Oracle Reports before-report trigger function that initializes report-level state, including the package-level WHERE clause variable.
• Get_Quantity — Returns the quantity for an inventory item in the context of a product or ingredient, an organization, cost type, and period. It accepts a product/ingredient indicator distinguishing 'P', 'I', or 'B' (product, ingredient, or both).
• get_le_name — Resolves a legal entity identifier to its display name.
• get_currency — Returns the currency associated with a legal entity.
• get_cost_type — Returns the name of a cost type given its identifier.
• get_OrderBy — Converts a numeric sort selection into the corresponding ORDER BY clause text for the report query.
• get_Period_Id — Derives the period identifier from a legal entity, calendar code, period code, and cost type.
• get_item_name — Returns the item name for a given inventory item identifier.
• get_category_name — Returns the category name for a given category identifier, resolving surrogate keys into descriptive labels.
• get_Category — Builds a category-based query predicate from a from-category and to-category range, supporting category range filtering in the report.

Tables Accessed

The package reads from costing and inventory master tables through APPS synonyms:

• CM_CMPT_DTL — Cost component detail records used in quantity and cost rollup retrieval.
• CM_MTHD_MST — Cost method master, supplying cost method context.
• CM_SCST_LED — Standard cost ledger, the source of item cost amounts.
• GMF_PERIOD_STATUSES — OPM period statuses, used to determine valid periods for a cost type.
• MTL_CATEGORIES_KFV — Key flexfield view over categories, used by get_category_name.
• MTL_CATEGORY_SETS and MTL_DEFAULT_CATEGORY_SETS — Category set definitions and defaults, used to locate the correct category set for item category lookup.
• MTL_SYSTEM_ITEMS_B — Item master base table, used for item name and item validation.

Usage Notes

GMF_CBOM_REP_PKG is intended primarily for use by the Costed Bill of Material Oracle Reports report. It is invoked from report triggers (before-report initialization and format triggers) rather than from forms or concurrent program PL/SQL bodies directly. Because it is classified as OTHER rather than a public API and is referenced by no other packages, it should be treated as a report-internal helper. Customizations that require category resolution or category-range predicate building may call get_category or get_category_name, but reliance on undocumented behavior is not advisable. The package carries a 2007 header revision (120.2), indicating stability across EBS 12.1.1 and 12.2.2.