Search Results billing_method

Overview

OKS_ENT_HEADERS_V is a PL/SQL-based view owned by the APPS schema within the Oracle E-Business Suite Service Contracts (OKS) module. It presents a consolidated, denormalized list of service contract headers drawn from the underlying contract tables shared with the Contracts Core (OKC) module. The view exposes contracts with valid start and end dates, excludes templates, and restricts rows to those carrying a party of type OKX_PARTY, thereby producing a reporting-friendly projection of active, customer-facing service agreements. Because several columns are populated through calls to the OKS_ENT_UTIL_PVT package, the view also encapsulates derived values such as contract amount, duration, and agreement identifier that would otherwise require bespoke logic.

In reporting and integration contexts, OKS_ENT_HEADERS_V functions as a stable interface for extracting contract metadata without directly joining the multiple base tables (headers, translations, party roles, and service-specific header extensions). This makes it suitable for concurrent-program extracts, business intelligence queries, and inbound/outbound interface consumption. The user search term "tax_exemption" maps directly to the TAX_EXEMPTION column exposed by the view, which surfaces the tax exemption identifier stored on the service contract header (OKS_K_HEADERS_B.TAX_EXEMPTION_ID) alongside the related TAX_STATUS column.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKC_K_HEADERS_B (accessed via synonym) — supplies the core contract header identifier, contract number, authoring organization, status, contract type, template flags, start and end dates, bill-to and ship-to site use identifiers, price list, currency, PO number, invoicing and payment terms, auto-renew days, and conversion type.
• OKC_K_HEADERS_TL — provides the language-dependent short description, joined on the header ID and restricted by USERENV('LANG') so each session returns text in the current language.
• OKS_K_HEADERS_B — the service-contract extension table supplying accounting rule, billing profile, tax exemption, and tax status attributes.
• OKC_K_PARTY_ROLES_B — resolves the customer party, filtered to roles whose object code equals OKX_PARTY.
• OKS_ENT_UTIL_PVT — a package used inline to compute contract amount, duration period, and agreement ID.

Key Columns

• ORG_ID, CONTRACT_ID, CONTRACT_NUMBER — organizational and primary contract identifiers.
• CONTRACT_STATUS_CODE, CONTRACT_TYPE_CODE — status and classification of the contract.
• CONTRACT_AMOUNT, DURATION, PERIOD_CODE — derived metrics returned by the utility package.
• PARTY_ID — the customer party derived from the role table.
• START_DATE_ACTIVE, END_DATE_ACTIVE — effective contract dates.
• TAX_EXEMPTION, TAX_STATUS — the tax exemption identifier and tax status sourced from OKS_K_HEADERS_B; these are the columns relevant to the "tax_exemption" search.
• TAX_EXEMPTION columns surface the exemption reference (typically a foreign key into tax exemption master data) used to determine whether a given contract qualifies for a tax exemption.

Common Use Cases and Queries

Typical usage includes identifying contracts with or without tax exemptions, reporting contract value by customer, and feeding downstream tax determination logic.

SELECT CONTRACT_NUMBER, PARTY_ID, TAX_EXEMPTION, TAX_STATUS
FROM   APPS.OKS_ENT_HEADERS_V
WHERE  TAX_EXEMPTION IS NOT NULL;

SELECT CONTRACT_STATUS_CODE, COUNT(*)
FROM   APPS.OKS_ENT_HEADERS_V
GROUP  BY CONTRACT_STATUS_CODE;

Because derived columns invoke PL/SQL functions, large extracts should be filtered and paginated to limit per-row package overhead.