Search Results header_bto_address




Overview
Explore in AI Chat

Overview

OKS_CONTRACT_DTLS_V is a reporting view owned by the APPS schema within the OKS – Service Contracts module of Oracle E-Business Suite (documented against release 12.2.2, and applicable to 12.1.1). Its documented purpose is to present service contracts invoice details, consolidating contract header, service line, covered product, and billing/invoice attributes into a single denormalized row set. The view serves as a read-only reporting and integration surface: it allows inquiry screens, custom reports, extract programs, and downstream interfaces to retrieve contract-to-invoice relationships without joining the four underlying service contract views directly.

The user search term header_bto_address corresponds to a column exposed by this view. It represents the header-level "Bill-To" address for the contract party, sourced from OKS_HEADER_DETAILS_V. It is complemented by the line-level columns LINE_BTO_ADDRESS and LINE_STO_ADDRESS, which permit bill-to and ship-to comparison at the service line level.

Underlying Base Objects

The view is defined as an outer-joined join across four service contract views, keyed on contract, line, and covered-line identifiers:

The documented dependency metadata additionally lists the packages ARP_ADDR_LABEL_PKG, CSICUMPI_PUB, and OKC_UTIL, which supply address formatting, service contract utility logic, and API support used within the underlying views.

Key Columns

The view exposes columns in four logical groups:

Common Use Cases and Queries

Typical usage includes contract billing reconciliation, invoice-to-covered-product traceability, and reporting on bill-to versus ship-to addresses across service lines. Because the billing join is outer, records for unbilled covered products still return, with invoice columns null.

A representative query retrieving header and line bill-to/ship-to information:

  • SELECT contract_number, party_name, header_bto_address, line_reference, service_name, line_bto_address, line_sto_address, invoice_number, invoice_line_amount FROM oks_contract_dtls_v WHERE contract_number = :p_contract;

To isolate covered products not yet invoiced, filter on INVOICE_NUMBER IS NULL. For address-focused analysis, project HEADER_BTO_ADDRESS alongside LINE_BTO_ADDRESS and LINE_STO_ADDRESS to compare header-level and line-level defaults. All queries should be executed with the appropriate ORG_ID operating unit context to respect multi-org security.