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, aliasedAHPCin the view text.FND_LOOKUP_VALUES_VL(VIEW) — supplies display meanings and descriptions for the coded columns, referenced four times with the aliasesPT,ST,AT, andPFT.
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
ROW_ID,PC_HEADER_ID,OBJECT_VERSION_NUMBER— primary identification and row-versioning columns.NAME,DESCRIPTION— descriptive header attributes.STATUS/STATUS_DESC— the coded status fromAHL_PC_HEADERS_VLand its decoded meaning. The status lookup type isAHL_PC_STATUS, which is the object referenced by the user search term ahl_pc_status.PRODUCT_TYPE_CODE/PRODUCT_TYPE_DESC— resolved from theITEM_TYPElookup type for application id 3 (Oracle Inventory), with start/end date filtering applied.PRIMARY_FLAG/PRIMARY_FLAG_DESC— decoded from theAHL_YES_NO_TYPElookup type.ASSOCIATION_TYPE_FLAG/ASSOCIATION_TYPE_DESC— decoded from theAHL_PC_ASSOS_TYPElookup type.DRAFT_FLAG,LINK_TO_PC_ID— draft-state indicator and linkage to a related catalog header.SECURITY_GROUP_ID,ATTRIBUTE_CATEGORY, andATTRIBUTE1throughATTRIBUTE15— standard EBS DFF and multi-org security columns.LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN— standard WHO audit 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_DESCto report catalog headers at a specific lifecycle stage. - Selecting
PRODUCT_TYPE_DESCandPRIMARY_FLAG_DESCfor catalogue classification reporting. - Joining
PC_HEADER_IDback 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_descFROM apps.ahl_pc_headers_vWHERE 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.
-
Lookup Type: AHL_PC_STATUS 12.1.1
Product Classification Status
-
Lookup Type: AHL_PC_STATUS 12.2.2
Product Classification Status
-
VIEW: APPS.AHL_PC_HEADERS_V 12.2.2
-
VIEW: APPS.AHL_PC_HEADERS_V 12.1.1
-
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 →
-
12.1.1 FND Design Data 12.1.1
-
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 →
-
12.2.2 FND Design Data 12.2.2