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:

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.