Results for “tax_status_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_VAT_TAX_VL is a multilingual (VL) view owned by the APPS schema in Oracle E-Business Suite Receivables. It presents tax rate configuration data maintained for VAT and related tax regimes, joining the tax definition base table to its translation table so that descriptive text is returned in the session's active language. The view is one of the standard _VL constructs used throughout EBS, in which the "_B" suffix denotes the base (untranslated) table and the "_TL" suffix denotes the translation table; the "_VL" view merges the two and applies multilingual and operating-unit security filters at runtime.

Functionally, AR_VAT_TAX_VL supplies the tax code setup information consumed by Receivables transaction entry, tax calculation, and reporting. It exposes tax codes, rates, tax types and classes, accounting flexfield references for tax and adjustment accounts, effective dates, and a range of descriptive and control flags. Because the view applies organization-level access checking, it is the preferred read interface for tax code lookups for any session-bound operating unit, rather than querying AR_VAT_TAX_ALL_B directly.

Underlying Base Objects

The view is defined over three documented base objects:

• AR_VAT_TAX_ALL_B (synonym) — the base tax definition table, holding all non-translated tax attributes such as tax rate, tax type, accounting code combinations, flags, and effective dates.
• AR_VAT_TAX_ALL_TL (synonym) — the translation table, supplying PRINTED_TAX_NAME and other language-specific descriptive columns keyed by VAT_TAX_ID, ORG_ID, and LANGUAGE.
• MO_GLOBAL (package) — the Multi-Org access control package; its CHECK_ACCESS function is invoked in the WHERE clause to restrict rows to operating units accessible to the current user.

The join condition matches B.VAT_TAX_ID to T.VAT_TAX_ID and NVL(B.ORG_ID,-99) to NVL(T.ORG_ID,-99), filters on MO_GLOBAL.CHECK_ACCESS(B.ORG_ID) = 'Y', and restricts T.LANGUAGE to USERENV('LANG') so that only the current session language row is returned. ROW_ID is projected from the base table ROWID.

Key Columns

Columns fall into several logical groups. Identity and classification columns include VAT_TAX_ID, SET_OF_BOOKS_ID, ORG_ID, TAX_CODE, TAX, TAX_REGIME_CODE, TAX_STATUS_CODE, TAX_TYPE, TAX_CLASS, and VAT_TRANSACTION_TYPE. Rate and rule columns include TAX_RATE, TAXABLE_BASIS, TAX_CALCULATION_PLSQL_BLOCK, and the control flags VALIDATE_FLAG, ENABLED_FLAG, DISPLAYED_FLAG, AMOUNT_INCLUDES_TAX_FLAG, AMOUNT_INCLUDES_TAX_OVERRIDE, and UNAPPROVED_EXEMPTION_FLAG. Date columns START_DATE and END_DATE govern effective dating.

Accounting columns include TAX_ACCOUNT_ID, INTERIM_TAX_CCID, ADJ_CCID, EDISC_CCID, UNEDISC_CCID, FINCHRG_CCID, and the non-recoverable variants ADJ_NON_REC_TAX_CCID, EDISC_NON_REC_TAX_CCID, UNEDISC_NON_REC_TAX_CCID, and FINCHRG_NON_REC_TAX_CCID. Descriptive columns include TAX_CODE, DESCRIPTION, PRINTED_TAX_NAME (from the translation table), ATTRIBUTE_CATEGORY with ATTRIBUTE1–15, GLOBAL_ATTRIBUTE_CATEGORY with GLOBAL_ATTRIBUTE1–20, and audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. The searched column, LEASING_FLAG, is a base-table flag indicating whether the tax code is designated for leasing treatment.

Common Use Cases and Queries

Typical uses include validating tax code setup, deriving tax rates for reporting, and extracting account derivation rules for reconciliation. The view is frequently joined to AR tax line tables for transaction-level tax analysis.

• Retrieve effective tax codes for the current operating unit and language.
• List tax rates by regime and status to support rate-change audits.
• Extract tax and adjustment accounts for GL reconciliation.
• Identify tax codes flagged for leasing treatment via LEASING_FLAG.

Sample queries:

• SELECT tax_code, printed_tax_name, tax_rate, tax_type, enabled_flag FROM ar_vat_tax_vl WHERE org_id = :p_org_id AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);
• SELECT tax_code, tax_regime_code, tax_status_code, leasing_flag FROM ar_vat_tax_vl WHERE leasing_flag = 'Y' ORDER BY tax_code;
• SELECT tax_code, tax_account_id, interim_tax_ccid, adj_ccid FROM ar_vat_tax_vl WHERE set_of_books_id = :p_sob_id;

Because the view enforces MO_GLOBAL access and language filtering, results automatically reflect the caller's operating unit and session language without additional predicates, though supplying ORG_ID remains good practice in multi-org reporting.