Search Results std_ar_input

Overview

APPS.GL_TAX_CODES_V is a reporting and integration view in Oracle E-Business Suite that exposes tax rate and tax account information in a flattened, user-friendly format. Its primary purpose is to present the tax codes available to General Ledger and subledger processes together with the accounting flexfield combinations to which those taxes post. The view joins tax rates, tax accounts, and lookup metadata so that consumers receive both the technical identifiers and the descriptive meanings required for reporting, validation lists, and interface programs. A distinguishing characteristic of the view is that it deliberately excludes standard input taxes whose tax status code is 'STD_AR_INPUT', filtering out that category of receivables-oriented input tax from the result set. The view is owned by APPS and is intended for read-only consumption; it does not carry its own storage and inherits the security and access characteristics of its underlying objects.

Underlying Base Objects

The view is defined over four documented base objects:

• ZX_RATES_VL (VIEW) — supplies the tax rate detail, including percentage rate, tax rate name, effective dates, active flag, tax class, tax regime, tax status, and tax rate code.
• ZX_ACCOUNTS (SYNONYM) — supplies the internal organization, ledger, and the tax account code combination identifier used to derive the accounting flexfield.
• ZX_TAXES_B (SYNONYM) — supplies the tax regime and tax identifiers and provides the source tax and offset tax flags used for filtering.
• GL_LOOKUPS (VIEW) — supplies the lookup meaning for the derived tax type code, restricted to the lookup type 'TAX_TYPE'.

The joins link rates to accounts through the tax rate identifier as the tax account entity, with the entity code constrained to 'RATES'. Rates are tied to taxes by matching tax regime code and tax. The lookup is joined on a decode of the tax class, mapping a null class to 'T', 'OUTPUT' to 'O', and 'INPUT' to 'I'. Filtering further restricts results to percentage rate types, source taxes, and taxes that are not offset taxes.

Key Columns

• ORG_ID — internal organization identifier from the tax accounts.
• LEDGER_ID — ledger associated with the tax account.
• TAX_TYPE_CODE / TAX_TYPE — derived code ('T', 'O', 'I') and its decoded lookup meaning.
• TAX_CODE_ID — coalesced source identifier, falling back to the tax rate identifier.
• TAX_RATE — the percentage rate value.
• TAX_CODE_COMBINATION_ID — accounting flexfield combination for the tax account.
• DESCRIPTION — the tax rate name.
• START_DATE / END_DATE — effective from and effective to dates.
• VALID_FLAG / ENABLED_FLAG — active status, defaulting to 'Y'.
• TAX_CLASS, TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_CODE — supporting tax classification and identity attributes.

Common Use Cases and Queries

Typical usage includes populating tax code list of values, validating tax rates against accounting combinations, and extracting tax configuration for reporting or data migration. Because the view already decodes the tax type and filters out 'STD_AR_INPUT' status records, it simplifies queries that would otherwise require multiple joins and decode logic.

Example: retrieving all currently valid input taxes for a ledger.

• SELECT tax_code, description, tax_rate, tax_code_combination_id FROM apps.gl_tax_codes_v WHERE tax_type_code = 'I' AND valid_flag = 'Y';

Example: listing enabled output taxes within an effective period.

• SELECT tax_regime_code, tax_code, tax_rate, start_date, end_date FROM apps.gl_tax_codes_v WHERE tax_type_code = 'O' AND enabled_flag = 'Y';

Both patterns rely on the view's derived columns and filtering to return a concise, consistent set of tax codes suitable for integration and reporting.