Search Results service_duration

Overview

OKX_QUOTE_LINE_DETAIL_V is a reporting and integration view owned by the APPS schema within the OKX – Contracts Integration product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes information specific to certain types of quote lines, specifically the detail-level attributes that accompany a quote line in Oracle Advanced Pricing and Quoting configurations. The view presents a denormalized, read-only projection of quote line detail records, adding constant and computed columns (such as a literal status of 'A', a system date for START_DATE_ACTIVE, and null placeholders for NAME and DESCRIPTION) that conform the underlying transactional data to a broader interface or reporting structure.

Because the OKX module bridges Oracle Contracts with quoting and configuration data, this view serves as the technical bridge that lets contract or service-related inquiries retrieve service-oriented quote detail attributes—such as service duration, service period, and service pricing percentages—without querying the base configuration tables directly.

Underlying Base Objects

The view is defined over a single documented base object: ASO_QUOTE_LINE_DETAILS, referenced through a synonym. The view text performs a direct SELECT from this table (aliased LDT) with no joins, filters, or aggregations presented in the documented definition. This means the view is a thin wrapper: every row in ASO_QUOTE_LINE_DETAILS produces exactly one row in the view, and row-level cardinality and integrity constraints of the base table are preserved. The columns are mapped nearly one-to-one, with the exception of the augmented columns described above and the QUOTE_LINE_DETAIL_ID exposed under the alias ID1.

Key Columns

• ID1 – Alias for QUOTE_LINE_DETAIL_ID, the primary identifier of the quote line detail record.
• QUOTE_LINE_ID – Foreign key to the parent quote line.
• COMPONENT_CODE – Identifies the configuration component associated with the detail.
• SERVICE_DURATION – The duration of the service being quoted; directly relevant to service_duration searches.
• SERVICE_PERIOD – The unit or period basis for the service duration.
• SERVICE_COTERMINATE_FLAG – Indicates whether the service coterminates with an existing service period.
• SERVICE_UNIT_SELLING_PERCENT / SERVICE_UNIT_LIST_PERCENT – Percentages of selling and list price applied to the service unit.
• SERVICE_NUMBER – Identifier for the service line.
• UNIT_PERCENT_BASE_PRICE – Percentage applied against the base price for the unit.
• CONFIG_HEADER_ID, CONFIG_REVISION_NUM, CONFIG_ITEM_ID – Configuration identifiers linking the detail to a specific configured item and revision.
• COMPLETE_CONFIGURATION_FLAG / VALID_CONFIGURATION_FLAG – Status flags indicating whether the configuration is complete and valid.
• SERVICE_REF_* columns – Reference type code, system ID, line ID, line number, and order number that trace the service back to an originating order or system.
• STATUS, START_DATE_ACTIVE, END_DATE_ACTIVE, NAME, DESCRIPTION – Derived or constant columns added by the view for interface compatibility.

Common Use Cases and Queries

The view is most commonly used to report on service-oriented quote line details and to feed integration programs that require a normalized set of quote detail attributes. Typical scenarios include retrieving service durations and periods for pricing analysis, tracing service references back to originating orders, and validating configuration completeness for configured items.

A representative query retrieving service duration details is:

• SELECT ID1, QUOTE_LINE_ID, COMPONENT_CODE, SERVICE_DURATION, SERVICE_PERIOD, SERVICE_NUMBER FROM OKX_QUOTE_LINE_DETAIL_V WHERE SERVICE_DURATION IS NOT NULL ORDER BY QUOTE_LINE_ID;
• SELECT q.QUOTE_LINE_ID, q.SERVICE_DURATION, q.SERVICE_UNIT_LIST_PERCENT, q.CONFIG_HEADER_ID FROM OKX_QUOTE_LINE_DETAIL_V q WHERE q.VALID_CONFIGURATION_FLAG = 'Y' AND q.COMPLETE_CONFIGURATION_FLAG = 'Y';
• SELECT SERVICE_REF_ORDER_NUMBER, SERVICE_REF_LINE_NUMBER, SERVICE_DURATION FROM OKX_QUOTE_LINE_DETAIL_V WHERE SERVICE_REF_TYPE_CODE IS NOT NULL;

Because the view exposes no filter predicates of its own, consumers should always constrain queries by QUOTE_LINE_ID or related identifiers to avoid full-table scans against the base synonym during reporting.