Results for “ahl_pc_status”

10 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AHL_PC_HEADERS_V is an Oracle E-Business Suite view in the Application Object Library schema. It presents the runtime translation and lookup-decoded representation of Product Catalog header records maintained within the Oracle Product Information Management / Advanced Product Catalog (AHL) module. The view exposes one row per product catalog header, combining the translatable columns held in the underlying AHL_PC_HEADERS_VL view with descriptive meanings resolved from Oracle Applications lookup values.

In Oracle EBS 12.1.1 and 12.2.2 this view serves as a reporting and integration surface. It is used by concurrent programs, OBIEE/BI Publisher extracts, and custom SQL where a user-readable catalogue header listing is required. Because the view resolves coded values into their display meanings, it removes the need for downstream consumers to join lookup tables themselves.

Underlying Base Objects

The documented base objects referenced by this view are:

  • AHL_PC_HEADERS_VL (VIEW) — supplies the translatable product catalog header data, aliased AHPC in the view text.
  • FND_LOOKUP_VALUES_VL (VIEW) — supplies display meanings and descriptions for the coded columns, referenced four times with the aliases PT, ST, AT, and PFT.

Four outer joins to FND_LOOKUP_VALUES_VL enrich the base record with descriptive text. Each join is keyed by a lookup type and a lookup code drawn from a column on AHL_PC_HEADERS_VL. The joins are outer (+) joins, so a catalog header is still returned if a lookup entry is missing or inactive.

Key Columns

Common Use Cases and Queries

The view is commonly queried to report catalog headers by status, to enumerate headers of a given product type, or to drive downstream integration extracts. A typical listing follows:

  • Filtering by STATUS_DESC to report catalog headers at a specific lifecycle stage.
  • Selecting PRODUCT_TYPE_DESC and PRIMARY_FLAG_DESC for catalogue classification reporting.
  • Joining PC_HEADER_ID back to child tables (for example, catalog entries or lines) to produce a full header-to-line report.

A representative query is:

  • SELECT pc_header_id, name, status, status_desc, product_type_code, product_type_desc
  •   FROM apps.ahl_pc_headers_v
  •  WHERE status = 'ACTIVE';

Because the view resolves AHL_PC_STATUS and the other lookup types at query time, filters on the descriptive columns (STATUS_DESC, PRODUCT_TYPE_DESC, and so on) reflect the current enabled lookup values rather than static codes, which makes the view suitable for user-facing reporting. When underlying source data changes or lookups are end-dated, the results change accordingly, so performance-sensitive batch integrations should consider filtering on the coded columns to exploit the base table indexes.