Results for “oks_k_headers_hv”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKS_K_HEADERS_HV is a view owned by the APPS schema within the OKS (Service Contracts) product of Oracle E-Business Suite. Its documented purpose is to expose Service Contracts Header Attributes History. In practice the "_HV" suffix denotes a history view, meaning the object provides a versioned or historical perspective on contract header attribute records rather than a single current-state row. Each record corresponds to a major version of a service contract header, allowing consumers to trace how contractual terms such as payment instruments, tax parameters, renewal behavior, and revenue estimation changed across successive versions of a contract.
Because the view is registered in Oracle EBS as VALID and is queryable through the APPS schema, it can be used directly in custom reports, concurrent program SQL, Oracle BI Publisher data templates, and inbound or outbound integration extracts. It is not an interface or API object; it is a read-only reporting surface, and no DML should be attempted against it. The column named COMMITMENT_ID, which corresponds to the user's search term, is one of the attributes carried on the header history record.
Underlying Base Objects
Per the ETRM metadata for 12.2.2, OKS_K_HEADERS_HV is defined over a single referenced base object: the synonym OKS_K_HEADERS_BH. The "_BH" suffix conventionally identifies a base history table, i.e., the physical store of header attribute history rows that the view projects. The view text selects from this base table, aliased KHH, mapping columns one-for-one and appending the ROWID as ROW_ID for uniqueness and identification purposes.
Because the relationship is a straightforward projection, there is no join, aggregation, or filter evident in the documented view text. Any row-level filtering (for example by contract, version, or date) is expected to be applied by the calling query. The view therefore inherits the row population and retention characteristics of OKS_K_HEADERS_BH, and any change in the base table's data or definition flows directly into the view.
Key Columns
- ROW_ID — the ROWID of the underlying base history row, useful as a surrogate identifier.
- ID — the contract header identifier linking the history row to the logical contract.
- MAJOR_VERSION — the version of the header attributes, distinguishing successive historical states of the same contract.
- CHR_ID — reference to the contract header record associated with the version.
- COMMITMENT_ID — the commitment (purchase order or budgetary commitment) associated with the contract header, central to procurement-to-contract reconciliation.
- ACCT_RULE_ID, PAYMENT_TYPE, CC_NO, CC_EXPIRY_DATE, CC_BANK_ACCT_ID, CC_AUTH_CODE — accounting rule and payment/credit card attributes.
- TAX_AMOUNT, TAX_STATUS, TAX_CODE, TAX_EXEMPTION_ID — tax treatment attributes as captured on the header version.
- BILLING_PROFILE_ID, EST_REV_PERCENT, EST_REV_DATE — billing and revenue estimation parameters.
- RENEWAL_* columns — a broad set of renewal attributes including RENEWAL_STATUS, ELECTRONIC_RENEWAL_FLAG, RENEWAL_PO_NUMBER, RENEWAL_PRICING_TYPE, RENEWAL_MARKUP_PERCENT, and corresponding "_USED" flags indicating which values were actually applied.
- QUOTE_TO_* columns — contact, site, email, phone, and fax targets for quotation or renewal communication.
Common Use Cases and Queries
Typical scenarios include auditing how a contract's commitment reference changed over time, reconciling renewal terms that were proposed versus those actually used, and feeding historical contract attributes into data warehouse or compliance extracts.
To locate history rows for a specific commitment:
SELECT id, major_version, commitment_id, renewal_status FROM oks_k_headers_hv WHERE commitment_id = :p_commitment_id ORDER BY id, major_version;
To inspect the evolution of renewal and tax attributes for a contract:
SELECT id, major_version, tax_code, tax_amount, renewal_pricing_type, renewal_markup_percent, renewal_markup_percent_used FROM oks_k_headers_hv WHERE id = :p_contract_id ORDER BY major_version;
Joining back to OKS_K_HEADERS_BH using ROW_ID allows correlation to the physical base history row when additional base-table columns outside the view projection are required.
-
View: OKS_K_HEADERS_HV 12.2.2
Service Contracts Header Attributes History
APPS.OKS_K_HEADERS_HV·↳ OKS_K_HEADERS_BH·Explore OKS module →
-
View: OKS_K_HEADERS_HV 12.1.1
Service Contracts Header Attributes History
APPS.OKS_K_HEADERS_HV·↳ OKS_K_HEADERS_BH·Explore OKS module →
-
VIEW: APPS.OKS_K_HEADERS_HV 12.2.2
-
VIEW: APPS.OKS_K_HEADERS_HV 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKS Tables and Views 12.2.2
-
eTRM - OKS Tables and Views 12.1.1
Stores the template set information.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - OKS Tables and Views 12.1.1
Stores the template set information.
-
eTRM - OKS Tables and Views 12.2.2