Search Results amount_includes_tax_flag

Overview

OKX_TAX_CODES_V is an APPS-owned, VALID database view delivered within the OKX – Contracts Integration product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to expose tax codes for consumption by contracts integration flows, including Service Contracts, and for ad hoc reporting. The view presents a denormalized read-only image of tax code definitions maintained in Oracle Receivables, combining the base (non-translated) attributes with the language-specific printed tax name in a single result set.

Rather than storing data, the view projects and reshapes columns from the underlying Receivables tax configuration tables. It applies a language filter tied to the session environment, so each user sees the description and printed name appropriate to their login language. The view also derives a normalized status value, mapping the underlying enabled flag to the ETRM 'A'/'I' convention.

Underlying Base Objects

Both referenced base objects are documented as synonyms in the ETRM 12.2.2 metadata:

• AR_VAT_TAX_ALL_B — the base tax code table holding tax rate, tax type, effective dates, organization, set of books, validation flag, enabled flag, and the amount-includes-tax columns.
• AR_VAT_TAX_ALL_TL — the translation table holding the language-specific printed tax name and description.

The join is defined on VAT_TAX_ID = VAT_TAX_ID, with the additional predicate T.LANGUAGE = USERENV('LANG'). Because the join is to the translated table and filters on the session language, the view returns one row per tax code per qualifying language. The alias B denotes the base table and T the translation table in the view text. The two amount-includes-tax columns are sourced exclusively from AR_VAT_TAX_ALL_B.

Key Columns

The view exposes the following columns: NAME, TAX_RATE, TAX_TYPE, START_DATE_ACTIVE, END_DATE_ACTIVE, DESCRIPTION, ORG_ID, SET_OF_BOOKS_ID, PRINTED_TAX_NAME, VALIDATE_FLAG, B_STATUS, STATUS, AMOUNT_INCLUDES_TAX_FLAG, and AMOUNT_INCLUDES_TAX_OVERRIDE. The internal identifiers ID1 (VAT_TAX_ID) and ID2 ('#') are also carried in the select list for integration keying but are not listed among the documented columns.

The user search term amount_includes_tax_flag maps directly to the AMOUNT_INCLUDES_TAX_FLAG column. Per the view definition it is taken from B.AMOUNT_INCLUDES_TAX_FLAG, indicating whether the tax code's amount includes tax by default. Its companion column, AMOUNT_INCLUDES_TAX_OVERRIDE, is also sourced from the base table and indicates whether that default may be overridden at the transaction level. Together they govern tax-inclusive versus tax-exclusive calculation on contracts and Receivables transactions.

Other notable columns include STATUS, a decoded value ('A' for enabled, 'I' for disabled) derived from ENABLED_FLAG via DECODE(B.ENABLED_FLAG,'Y','A','I'); B_STATUS, the raw enabled flag; and ORG_ID and SET_OF_BOOKS_ID for multi-org and ledger context.

Common Use Cases and Queries

The view is typically queried to validate tax code setup, to report tax-inclusive behavior, and to supply integration interfaces with tax code identifiers and rates.

• Tax-inclusive configuration review: select NAME and both amount-includes-tax columns to confirm which codes are tax-inclusive.
• Integration lookups: join ID1 back to transaction lines to resolve the tax code applied.
• Effective-date validation against START_DATE_ACTIVE and END_DATE_ACTIVE.

Sample query:

SELECT name, tax_rate, tax_type, amount_includes_tax_flag, amount_includes_tax_override, status FROM apps.okx_tax_codes_v WHERE org_id = :p_org_id AND amount_includes_tax_flag = 'Y' ORDER BY name;

Because the view is read-only and restricted by session language, it is unsuitable for updates; use the Receivables Tax Codes form or API for maintenance.