Results for “component_code”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PRP_COMPONENTS_VL is a seeded, VALID database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the PRP product family, the Proposals module within the Oracle Advanced Procurement / Oracle Procurement suite. The view presents proposal component definitions — the configurable building blocks that make up a proposal — combining the transactional, non-translatable attributes stored in the base table with the language-specific descriptive text stored in the translation table. The "_VL" suffix denotes a "view with language," a standard EBS naming convention signifying that the view joins a "_B" (base) table to a "_TL" (translation) table and filters the translation rows to the session language.
Its primary role is to provide a single, language-consistent read interface for reporting, concurrent programs, Oracle Forms, OA Framework pages, and external integrations. Rather than querying the base and translation tables separately, developers and analysts reference PRP_COMPONENTS_VL, which automatically restricts the translation join using USERENV('LANG'). This ensures that descriptive columns (COMPONENT_NAME, COMPONENT_DESC) are returned in the language of the current session, while identifier and audit columns come directly from the base table.
Underlying Base Objects
Per the documented ETRM 12.2.2 metadata, the view is defined over two synonyms pointing to the PRP schema objects:
- PRP_COMPONENTS_B — the base (non-translatable) table holding the component identifier, code, audit fields, object version number, and the DFF attribute columns (ATTRIBUTE_CATEGORY through ATTRIBUTE15).
- PRP_COMPONENTS_TL — the translatable table holding COMPONENT_NAME and COMPONENT_DESC for each supported language, keyed by COMPONENT_ID and LANGUAGE.
The define joins the two on B.COMPONENT_ID = T.COMPONENT_ID, with the translation side constrained by T.LANGUAGE = USERENV('LANG'), so exactly one translated row per component is returned for the active session language.
Key Columns
- ROW_ID — the ROWID of the base table row, exposed for row-level addressing.
- COMPONENT_ID — the primary unique identifier of the component and the join key between the base and translation tables.
- OBJECT_VERSION_NUMBER — the locking / optimistic concurrency token used by the EBS framework.
- COMPONENT_CODE — the user-visible, non-translatable code that identifies the component independent of language.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO (Who Columns) audit attributes.
- ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield (DFF) context and segment columns carried from the base table.
- COMPONENT_NAME, COMPONENT_DESC — the language-specific name and description sourced from PRP_COMPONENTS_TL.
Common Use Cases and Queries
Typical uses include listing available proposal components in a validation form or report, populating an LOV, or extracting component definitions for integration into an external proposal or estimating system. Because the view resolves the language internally, callers do not need to know the underlying translation table.
Sample query to list all components in the current session language:
SELECT component_id, component_code, component_name, component_desc FROM apps.prp_components_vl ORDER BY component_name;
Sample query to locate a component by code:
SELECT component_id, component_name FROM apps.prp_components_vl WHERE component_code = :p_code;
When querying from a schema other than APPS, prefix the view with APPS and rely on the seeded synonyms and grants. Note that the view is read-oriented; insert, update, and delete operations against proposal components are performed through the base and translation tables or the supporting PRP forms and APIs.
-
View: PRP_COMPONENTS_VL 12.1.1
APPS.PRP_COMPONENTS_VL·↳ PRP_COMPONENTS_B·↳ PRP_COMPONENTS_TL·Explore PRP module →
-
This table contains the information about the components.
-
This table contains the information about the components.
-
View: PRP_COMPONENTS_VL 12.2.2
APPS.PRP_COMPONENTS_VL·↳ PRP_COMPONENTS_B·↳ PRP_COMPONENTS_TL·Explore PRP module →