Results for “ahl_pc_headers_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
In Oracle EBS 12.1.1 and 12.2.2, AHL_PC_HEADERS_V is an APPS-owned, VALID database view belonging to product AHL (Complex Maintenance Repair and Overhaul). It is documented in ETRM as a view "based on AHL_PC_HEADERS_VL and FND_LOOKUPS." It presents PC (planning/costing) header records — the top-level parent records in AHL's planning and configuration hierarchy — enriched with human-readable, translated lookup meanings in place of the underlying code values. The view is read-only; it is intended for reporting, concurrent programs, OAF page queries, and integration extracts rather than for direct transactional DML. Because it joins the translated view AHL_PC_HEADERS_VL, the view returns only the base-language or current-language rows appropriate to the session's language, and it exposes descriptive columns (such as STATUS_DESC) that would otherwise require a separate lookup join by the calling application.
Underlying Base Objects
ETRM documents exactly two referenced base objects: AHL_PC_HEADERS_VL (VIEW) and FND_LOOKUP_VALUES_VL (VIEW). The view text confirms this. AHL_PC_HEADERS_VL supplies the core PC header columns (ROW_ID, PC_HEADER_ID, NAME, STATUS, PRODUCT_TYPE_CODE, PRIMARY_FLAG, ASSOCIATION_TYPE_FLAG, DRAFT_FLAG, LINK_TO_PC_ID, DESCRIPTION, SECURITY_GROUP_ID, and the ATTRIBUTE1–15 flex columns). FND_LOOKUP_VALUES_VL is joined four times, each time with an outer-join marker (+) and a distinct lookup type, to translate code columns into descriptions:
- ST — LOOKUP_TYPE = 'AHL_PC_STATUS', joined on LOOKUP_CODE = AHPC.STATUS, yielding STATUS_DESC.
- PT — LOOKUP_TYPE = 'ITEM_TYPE', yielding PRODUCT_TYPE_DESC; additionally constrained to ENABLED_FLAG = 'Y', VIEW_APPLICATION_ID = 3, and an effective SYSDATE date window.
- AT — LOOKUP_TYPE = 'AHL_PC_ASSOS_TYPE', yielding ASSOCIATION_TYPE_DESC.
- PFT — LOOKUP_TYPE = 'AHL_YES_NO_TYPE', yielding PRIMARY_FLAG_DESC.
Because these are outer joins, the base header rows are preserved even when a matching lookup is absent, in which case the corresponding _DESC column returns NULL.
Key Columns
- PC_HEADER_ID — Primary key of the PC header; the join key to child entities.
- ROW_ID — Global unique identifier for the row.
- NAME — User-defined name of the PC header.
- STATUS / STATUS_DESC — The stored status code and its translated meaning from 'AHL_PC_STATUS'. This pair is the object of the "status_desc" search.
- PRODUCT_TYPE_CODE / PRODUCT_TYPE_DESC — Item type code and its decoded meaning.
- PRIMARY_FLAG / PRIMARY_FLAG_DESC — Yes/No indicator (decoded via 'AHL_YES_NO_TYPE') marking the primary header.
- ASSOCIATION_TYPE_FLAG / ASSOCIATION_TYPE_DESC — Association type code and description.
- DRAFT_FLAG — Indicates a draft header.
- LINK_TO_PC_ID — Identifier of a linked PC header.
- SECURITY_GROUP_ID — Multi-org/security grouping reference.
- DESCRIPTION and ATTRIBUTE1–15 — Free-form descriptive and flex attribute columns.
- Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.
Common Use Cases and Queries
Typical uses include: listing PC headers with readable status for OAF pages, populating concurrent program reports, and feeding integration extracts that must not expose raw lookup codes. A representative query listing headers with translated status is:
SELECT pc_header_id, name, status, status_desc FROM ahl_pc_headers_v WHERE status = 'ACTIVE';SELECT pc_header_id, name, status_desc, product_type_desc, primary_flag_desc FROM ahl_pc_headers_v ORDER BY name;SELECT pc_header_id, name, status_desc FROM ahl_pc_headers_v WHERE status_desc IS NULL; -- reveals unmapped or disabled lookup codes
Note the ITEM_TYPE join is restricted to enabled lookups, so PRODUCT_TYPE_DESC is NULL for codes not currently active; STATUS, ASSOCIATION_TYPE, and PRIMARY_FLAG translations are not so restricted.
-
View: AHL_PC_HEADERS_V 12.2.2
View based on AHL_PC_HEADERS_VL and FND_LOOKUPS
APPS.AHL_PC_HEADERS_V·↳ AHL_PC_HEADERS_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View: AHL_PC_HEADERS_V 12.1.1
View based on AHL_PC_HEADERS_VL and FND_LOOKUPS
APPS.AHL_PC_HEADERS_V·↳ AHL_PC_HEADERS_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
VIEW: APPS.AHL_PC_HEADERS_V 12.2.2
-
VIEW: APPS.AHL_PC_HEADERS_V 12.1.1
-
View Based on PC Header, PC Nodes ,FMP and MR views.
APPS.AHL_PC_HEADER_DETAILS_V·↳ AHL_DOCUMENTS_B·↳ AHL_DOC_REVISIONS_B·↳ AHL_DOC_TITLE_ASSOS_B·Explore AHL module →
-
View Based on PC Header, PC Nodes ,FMP and MR views.
APPS.AHL_PC_HEADER_DETAILS_V·↳ AHL_DOCUMENTS_B·↳ AHL_DOC_REVISIONS_B·↳ AHL_DOC_TITLE_ASSOS_B·Explore AHL module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.AHL_PC_HEADERS_VL 12.1.1
-
VIEW: APPS.AHL_PC_HEADERS_VL 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
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
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 - FND Tables and Views 12.1.1
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used