Results for “ahl_pc_headers_tl”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AHL_PC_HEADERS_TL is the translation (language) table for AHL_PC_HEADERS_B within the AHL – Complex Maintenance Repair and Overhaul product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The "_B" suffix denotes the base table that holds language-independent attributes and surrogate keys, while the "_TL" counterpart stores the translatable, user-facing text — specifically the DESCRIPTION column — keyed by language. This split-model design is standard across EBS and reflects the Multi-Language Support (MLS) architecture, allowing the same physical maintenance header record to carry descriptions in multiple installed languages without duplicating transactional data.
The object resides in the AHL schema and is reported as VALID. Its DMetadata footprint confirms 10 documented columns. From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone, though its structural role is best modeled as a satellite attached to the AHL_PC_HEADERS_B hub, since it carries descriptive, language-dependent attributes qualified by PC_HEADER_ID and LANGUAGE.
Key Information Stored
The table's grain is one row per (PC_HEADER_ID, LANGUAGE) combination. The most significant columns are:
- PC_HEADER_ID — the surrogate foreign key to AHL_PC_HEADERS_B; together with LANGUAGE it forms the effective composite key for retrieving a translated row.
- LANGUAGE — the NLS language code identifying the translated text variant (for example, "US" for American English).
- SOURCE_LANG — indicates the language in which the row was originally authored, supporting the MLS seed/translation workflow.
- DESCRIPTION — the translatable business text describing the maintenance header.
- SECURITY_GROUP_ID — the multi-org security grouping; it is the only documented foreign key, referencing FND_SECURITY_GROUPS.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO (audit) columns tracking creation and modification.
No unique index is documented in the provided metadata; the presumed business-key candidate is the PC_HEADER_ID plus LANGUAGE pair.
Common Use Cases and Queries
The principal use is joining base and translated records to return a description in the session or requested language. A typical pattern:
- Retrieve the localized description for a header:
SELECT t.description FROM ahl_pc_headers_b b, ahl_pc_headers_tl t WHERE b.pc_header_id = t.pc_header_id AND t.language = USERENV('LANG'); - Audit which languages have translations:
SELECT pc_header_id, language FROM ahl_pc_headers_tl WHERE pc_header_id = :id; - Reporting and data-extraction extracts that must resolve DESCRIPTION for multilingual deployments.
- Security-scoped queries joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS for org-level filtering.
Related Objects
- AHL_PC_HEADERS_B — the base table; joined on PC_HEADER_ID. This is the primary relationship.
- FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, the documented foreign key.
- FND_LANGUAGES — provides the valid values and installed-language context for the LANGUAGE and SOURCE_LANG columns.
- FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — relevant for confirming AHL module installation and MLS configuration.
-
Translation table for AHL_PC_HEADERS_B.
-
Translation table for AHL_PC_HEADERS_B.
-
TABLE: AHL.AHL_PC_HEADERS_TL 12.2.2
-
TABLE: AHL.AHL_PC_HEADERS_TL 12.1.1
-
VIEW: AHL.AHL_PC_HEADERS_TL# 12.2.2
-
View: AHL_PC_HEADERS_VL 12.1.1
View based on the table AHL_PC_HEADERS_B and the translated columns from the table AHL_PC_HEADERS_TL
APPS.AHL_PC_HEADERS_VL·↳ AHL_PC_HEADERS_B·↳ AHL_PC_HEADERS_TL·Explore AHL module →
-
View: AHL_PC_HEADERS_VL 12.2.2
View based on the table AHL_PC_HEADERS_B and the translated columns from the table AHL_PC_HEADERS_TL
APPS.AHL_PC_HEADERS_VL·↳ AHL_PC_HEADERS_B·↳ AHL_PC_HEADERS_TL·Explore AHL module →
-
VIEW: AHL.AHL_PC_HEADERS_TL# 12.2.2
-
VIEW: APPS.AHL_PC_HEADERS_VL 12.1.1
-
VIEW: APPS.AHL_PC_HEADERS_VL 12.2.2
-
VIEW: APPS.AHL_PC_HEADERS_VL 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.AHL_PC_HEADERS_VL 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - AHL Tables and Views 12.1.1
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.2.2
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.1.1
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.2.2
Ahl Production Workorder Operations Information stored in this table
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1