Results for “okx_opplines”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OKC_REL_OBJ_OPP_LINES_V is a reporting and integration view in Oracle E-Business Suite that joins opportunity line data to the relationship objects that reference them. In the context of Oracle EBS 12.1.1 and 12.2.2, the view is owned by the APPS schema and is part of the ETRM (Enterprise Technology Reference Model) inventory of documented objects. It exists to expose opportunity line information — quantities, amounts, item identity, and descriptions — alongside the relationship-object linkage that ties each opportunity line to a contract or relationship record through the CHR_ID identifier.
The view is typically queried by the search term okx_opplines, reflecting its dependency on OKX_OPP_LINES_V and the join predicate on the JTOT_OBJECT1_CODE value 'OKX_OPPLINES'. Its role is primarily analytical: it consolidates opportunity pipeline data with the item master attributes required for reporting, quote-to-order analysis, and downstream integration extracts.
Underlying Base Objects
The view is defined over three documented base view objects:
- OKX_OPP_LINES_V — the primary opportunity line source, supplying LINE_NUMBER (via ID1), OPP_HEADER_ID, QUANTITY, TOTAL_AMOUNT, INVENTORY_ITEM_ID, and ORGANIZATION_ID.
- OKC_K_REL_OBJS_V — the relationship-object view that provides the join key OBJECT1_ID1 (matched to OL.ID1) and CHR_ID, restricted by JTOT_OBJECT1_CODE = 'OKX_OPPLINES'.
- OKX_SYSTEM_ITEMS_V — the item master source, joined on INVENTORY_ITEM_ID = ID1 and ORGANIZATION_ID = ID2, supplying NAME and DESCRIPTION.
The join is an inner join across all three objects, so only opportunity lines that resolve to a valid relationship object and a valid inventory item in the organization are returned. Lines lacking a matching item or relationship record are excluded.
Key Columns
- LINE_NUMBER — sourced from OL.ID1; identifies the opportunity line.
- OPP_HEADER_ID — the opportunity header identifier, used to group lines under a single opportunity.
- DESCRIPTION — item description from OKX_SYSTEM_ITEMS_V.
- QUANTITY — the opportunity line quantity.
- AMOUNT — maps to OL.TOTAL_AMOUNT, the extended line value.
- OBJECT1_ID1 — the relationship object's reference back to the opportunity line ID.
- CHR_ID — the relationship/contract header identifier linking the line to its parent record.
- ITEM_NAME — the inventory item name from the item master.
Common Use Cases and Queries
Typical uses include pipeline reporting by item, reconciliation of opportunity lines to relationship records, and extraction feeds for quoting or order capture. A representative query groups amounts by opportunity header:
SELECT OPP_HEADER_ID, SUM(AMOUNT) FROM APPS.OKC_REL_OBJ_OPP_LINES_V GROUP BY OPP_HEADER_ID;SELECT ITEM_NAME, QUANTITY, AMOUNT FROM APPS.OKC_REL_OBJ_OPP_LINES_V WHERE OPP_HEADER_ID = :header_id;SELECT LINE_NUMBER, CHR_ID FROM APPS.OKC_REL_OBJ_OPP_LINES_V ORDER BY LINE_NUMBER;
Because the view is read-only and defined entirely over views, it is safe for reporting use and requires no direct base-table access.