Results for “ap_tax_codes_tn_v”

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

Overview

AP_TAX_CODES_TN_V is a Payables module view documented in Oracle E-Business Suite as a "Release 10SC Only" object. The suffix "TN" indicates a Tax Name lookup view, and its purpose is to present a de-duplicated, filtered list of enabled tax names and their descriptions for use by Oracle Forms-based tax code selection lists (LOVs) and related reporting. Because the object is a view rather than a base table, it exposes no independent storage; all data is derived at runtime from the underlying AP_TAX_CODES table.

The ETRM documentation explicitly records the view as "Not implemented in this database," meaning it is a legacy artifact retained for historical completeness. Customers on EBS 12.1.1 or 12.2.2 will typically find that the underlying AP_TAX_CODES table and other tax-related views supersede it. Nevertheless, its definition remains useful for understanding how tax code pick lists were historically constrained, and for interpreting older customizations or reports that reference the name.

Underlying Base Objects

The view is defined over a single base table, AP_TAX_CODES. The ETRM metadata does not document additional referenced objects, and the view text confirms a direct dependency on AP_TAX_CODES only. The WHERE clause applies three business filters: the record must be enabled (ENABLED_FLAG null or 'Y'), and the TAX_TYPE must exclude 'USE', 'OFFSET', and 'AWT'. A GROUP BY over NAME and DESCRIPTION removes duplicate combinations, producing a distinct list of tax names suitable for selection.

Because there is no join to AP_TAX_CODES_B, AP_TAX_CODES_TL, or any operating-unit assignment table, the view is not organization-specific. The results are therefore global across the tax code definitions visible in the AP_TAX_CODES structure as defined at that release.

Key Columns

• TAX_NAME — The tax code name sourced from the NAME column of AP_TAX_CODES. This is the human-readable identifier presented in tax selection lists and on tax-related reports.
• DESCRIPTION — The descriptive text from AP_TAX_CODES.DESCRIPTION, providing additional context for each tax name.

No identifiers, tax rates, effective dates, or jurisdiction attributes are exposed. The view intentionally projects only the two descriptive columns required for name lookup behavior.

Common Use Cases and Queries

The view historically supported Oracle Forms LOVs on tax code fields, ensuring users could select only enabled, non-withholding, non-offset, and non-usage tax codes. In modern EBS environments, it is primarily encountered in legacy custom reports, migrations, and interface scripts that were written against Release 10SC. Typical usage includes populating a parameter list for a concurrent program, validating imported tax codes against a controlled set, or generating a distinct reference list of tax names for reconciliation.

A representative query is:

• SELECT tax_name, description FROM ap_tax_codes_tn_v ORDER BY tax_name;
• SELECT COUNT(*) FROM ap_tax_codes_tn_v;

For current 12.1.1 and 12.2.2 implementations, equivalent functionality is more reliably obtained by querying AP_TAX_CODES directly with the same filters, or by using the modern tax configuration views available under the E-Business Tax (EBTax) model. DBAs should confirm the object's existence before deploying dependent code, since the ETRM explicitly flags it as unimplemented in the documented database.