Results for “osp_order_line_id”

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

Overview

AHL_WARRANTY_ENTITLEMENTS is a transactional table in the AHL (Complex Maintenance Repair and Overhaul) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It records warranty entitlement instances — the linkage between a warranty contract and a specific maintenance or service execution element, such as a work order, a visit task, an outbound service procurement (OSP) order line, a service request incident, or a purchasing header. Each row represents an assertion that a given maintenance activity is covered, or has been claimed, under a warranty agreement.

The object is owned by the AHL schema and contains 36 documented columns. Its primary key is defined by the constraint AHL_WARRANTY_ENTITLEMENTS_PK1 on WARRANTY_ENTITLEMENT_ID. Following heuristic Data Vault classification mined from its foreign-key structure, this table is best modeled as a link table: it resolves relationships among warranty contracts, work orders, visit tasks, OSP order lines, purchasing documents, and claims. It also carries descriptive and status attributes, so it functions as a link with satellite-like characteristics in a dimensional or Data Vault representation.

Key Information Stored

The most significant columns are:

• WARRANTY_ENTITLEMENT_ID — surrogate primary key, system-generated.
• WARRANTY_CONTRACT_ID — the warranty contract under which entitlement is asserted; self-referencing foreign key.
• OLD_WARRANTY_CONTRACT_ID — prior contract reference, supporting contract supersession or renewal tracking.
• WARRANTY_CLAIM_ID — the claim against which the entitlement is consumed; self-referencing foreign key.
• ENTITLEMENT_STATUS_CODE — lifecycle status of the entitlement (for example, active, expired, or claimed).
• WORKORDER_ID — foreign key to AHL_WORKORDERS; the maintenance work order receiving warranty coverage.
• VISIT_TASK_ID — foreign key to AHL_VISIT_TASKS_B; the specific visit task within a work order.
• OSP_ORDER_LINE_ID — foreign key to AHL_OSP_ORDER_LINES; the outsourced service line entitled.
• PO_HEADER_ID — purchasing document associated with the entitlement.
• SR_INCIDENT_ID — the service request incident that originated the entitlement.
• WARRANTY_LABOUR_CAPTURE, WARRANTY_MTL_CAPTURE — flags controlling whether labor and material costs are captured against warranty.
• ORDER_CLAIM_AMOUNT — monetary value claimed or entitled.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org data security.
• Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, OBJECT_VERSION_NUMBER) plus 15 descriptive ATTRIBUTE flex columns.

Common Use Cases and Queries

Typical reporting scenarios include identifying active warranty coverage for open work orders, reconciling claims against contracts, and auditing cost capture. A representative query:

SELECT we.WARRANTY_ENTITLEMENT_ID, w.WORK_ORDER_NUMBER, we.ENTITLEMENT_STATUS_CODE
FROM AHL_WARRANTY_ENTITLEMENTS we, AHL_WORKORDERS w
WHERE we.WORKORDER_ID = w.WORKORDER_ID
AND we.ENTITLEMENT_STATUS_CODE = 'ACTIVE';

Analysts frequently join to AHL_OSP_ORDER_LINES for supplier recovery analysis and to FND_SECURITY_GROUPS for organization-scoped reporting. The PO_HEADER_ID and SR_INCIDENT_ID enable cross-module tracing into Purchasing and Service.

Related Objects

• AHL_WORKORDERS — referenced via WORKORDER_ID.
• AHL_VISIT_TASKS_B — referenced via VISIT_TASK_ID.
• AHL_OSP_ORDER_LINES — referenced via OSP_ORDER_LINE_ID.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
• AHL_WARRANTY_ENTITLEMENTS (self-referencing) for WARRANTY_CONTRACT_ID, OLD_WARRANTY_CONTRACT_ID, and WARRANTY_CLAIM_ID.