Results for “amount_includes_tax_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
View: OKX_TAX_CODES_V 12.2.2
Tax codes
APPS.OKX_TAX_CODES_V·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore OKX module →
-
View: OKX_TAX_CODES_V 12.1.1
Tax codes
APPS.OKX_TAX_CODES_V·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore OKX module →
-
Setup tax options for natural account values
-
Table: AP_WEB_DISC_LINES_GT 12.2.2
-
APPS.APBV_EXPENSE_REPORT_PARAMS·↳ AP_EXPENSE_REPORT_PARAMS_ALL·Explore AP module →
-
Expense type information for expense report templates
-
Expense type information for expense report templates
-
Table: AP_WEB_DISC_LINES_GT 12.1.1
-
Business view
APPS.APBV_AP_INVOICE_DISTRIBUTIONS·↳ AP_INVOICE_DISTRIBUTIONS·↳ GL_CODE_COMBINATIONS·Explore AP module →
-
Accounting information for credit card transactions
-
Setup tax options for natural account values
-
Business view
APPS.APFV_AP_INVOICE_DISTRIBUTIONS·↳ AP_INVOICE_DISTRIBUTIONS·↳ GL_CODE_COMBINATIONS·Explore AP module →
-
APPS.APBV_EXPENSE_REPORT_PARAMS·↳ AP_EXPENSE_REPORT_PARAMS_ALL·Explore AP module →
-
Tax codes defined in the Tax Codes and Rates window
-
Business view
APPS.APFV_AP_INVOICE_DISTRIBUTIONS·↳ AP_INVOICE_DISTRIBUTIONS·↳ GL_CODE_COMBINATIONS·Explore AP module →
-
Business view
APPS.APBV_AP_INVOICE_DISTRIBUTIONS·↳ AP_INVOICE_DISTRIBUTIONS·↳ GL_CODE_COMBINATIONS·Explore AP module →
-
View: GL_JE_LINES_V 12.1.1
APPS.GL_JE_LINES_V·↳ GL_CODE_COMBINATIONS·↳ GL_JE_LINES·↳ GL_JE_LINES_RECON·Explore GL module →
-
Accounting information for credit card transactions
-
Tax codes defined in the Tax Codes and Rates window
-
View: POBV_SUPPLIERS 12.1.1
- Retrofitted
-
View: GL_JE_LINES_V 12.2.2
APPS.GL_JE_LINES_V·↳ GL_CODE_COMBINATIONS·↳ GL_JE_LINES·↳ GL_JE_LINES_RECON·Explore GL module →
-
View: POBV_SUPPLIERS 12.2.2
- Retrofitted
-
View: PO_VENDOR_SITES 12.1.1
10SC ONLY - Retrofitted
APPS.PO_VENDOR_SITES·↳ AP_SUPPLIER_SITES·Explore PO module →
-
View: AR_VAT_TAX_ALL_VL 12.1.1
APPS.AR_VAT_TAX_ALL_VL·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore AR module →
-
View: AR_VAT_TAX_VL 12.1.1
APPS.AR_VAT_TAX_VL·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·↳ MO_GLOBAL·Explore AR module →
-
APPS.PO_VENDOR_SITES_ALL·↳ AP_SUPPLIER_SITES_ALL·Explore AP module →
-
View: AR_VAT_TAX_VL 12.2.2
APPS.AR_VAT_TAX_VL·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·↳ MO_GLOBAL·Explore AR module →
-
APPS.APBV_EXPENSE_REPORT_LINES·↳ AP_EXPENSE_REPORT_LINES_ALL·Explore AP module →
-
View: POFV_SUPPLIERS 12.2.2
- Retrofitted
APPS.POFV_SUPPLIERS·↳ AP_TERMS·↳ FND_CURRENCIES_VL·↳ HR_GENERAL·Explore PO module →
-
APPS.RA_CUST_TRX_LN_ALL_MRC_V·↳ RA_CUSTOMER_TRX_LINES_ALL·↳ RA_MC_CUSTOMER_TRX_LINES·Explore AR module →
-
APPS.RA_CUSTOMER_TRX_LINES_RA_V·↳ AR_REVENUE_ADJUSTMENT_PVT·↳ MTL_CATEGORIES·↳ MTL_ITEM_CATEGORIES·Explore AR module →
-
APPS.RA_CUSTOMER_TRX_LINES_RA_V·↳ AR_REVENUE_ADJUSTMENT_PVT·↳ MTL_CATEGORIES·↳ MTL_ITEM_CATEGORIES·Explore AR module →
-
View: RA_CUST_TRX_LN_MRC_V 12.1.1
APPS.RA_CUST_TRX_LN_MRC_V·↳ RA_CUSTOMER_TRX_LINES_ALL·↳ RA_MC_CUSTOMER_TRX_LINES·Explore AR module →
-
View: RA_CUST_TRX_LN_MRC_V 12.2.2
APPS.RA_CUST_TRX_LN_MRC_V·↳ RA_CUSTOMER_TRX_LINES_ALL·↳ RA_MC_CUSTOMER_TRX_LINES·Explore AR module →
-
Journal entry lines
-
View: PO_VENDOR_SITES 12.1.1
APPS.PO_VENDOR_SITES·↳ AP_SUPPLIER_SITES·Explore AP module →
-
APPS.APBV_EXPENSE_REPORT_LINES·↳ AP_EXPENSE_REPORT_LINES_ALL·Explore AP module →
-
APPS.RA_CUST_TRX_LN_ALL_MRC_V·↳ RA_CUSTOMER_TRX_LINES_ALL·↳ RA_MC_CUSTOMER_TRX_LINES·Explore AR module →
-
View: AR_VAT_TAX_ALL_VL 12.2.2
APPS.AR_VAT_TAX_ALL_VL·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore AR module →
-
View Transaction History in Self-Service Expenses is based on this view
APPS.AP_EXPENSE_FEED_DISTS_V·↳ AP_CARDS·↳ AP_CARD_PROFILES·↳ AP_CARD_PROGRAMS·Explore AP module →
-
Journal entry lines
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
(Release 115)
APPS.RA_CUSTOMER_TRX_LINES_V·↳ ARH_ADDR_PKG·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_BAL_UTIL·Explore AR module →
-
APPS.PO_VENDOR_SITES_ALL·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIER_SITES_ALL·↳ FND_GLOBAL·Explore AP module →