Results for “printed_tax_rate_name”

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

Overview

APPS.ARFV_AR_TAX_CODES is a reporting and integration view in Oracle E-Business Suite that presents tax rate definitions from the E-Business Tax (EBTax) schema in a flattened, user-facing structure. It is defined in the APPS schema and exposed through the Receivables (AR) reporting layer, which is why its name carries the ARFV prefix. The view consolidates data from ZX_RATES_B, ZX_RATES_TL, ZX_TAXES_B, and associated reporting and account-relationship tables into a single virtual entity equivalent to a "tax code," supplying identifiers, effective dates, percentage rates, descriptive text, and accounting information.

The view is particularly significant for backward compatibility. Legacy Oracle Receivables tax code functionality predates the E-Business Tax (ZX) model, and ARFV_AR_TAX_CODES bridges the two by mapping the modern ZX_RATES structure onto the traditional AR tax code attribute set (TAX_CODE, TAX_NAME, TAX_RATE, START_EFFECTIVE_DATE, END_EFFECTIVE_DATE, taxable account, and so on). One of the reporting types driving the view is PRINTED_TAX_RATE_NAME, referenced in the view text as REPTYPES.REPORTING_TYPE_CODE = 'PRINTED_TAX_RATE_NAME', which is the source of the human-readable tax rate description shown on printed tax documents.

Underlying Base Objects

The view is defined over eleven documented base objects, all referenced through APPS synonyms:

• ZX_RATES_B / ZX_RATES_TL — the base and translated tax rate definitions; ZX_RATES_B supplies TAX_RATE_ID, code, percentage, effective dates, and flags; ZX_RATES_TL supplies the translated TAX_RATE_NAME.
• ZX_TAXES_B — provides tax regime, tax, and tax type context linked by TAX_REGIME_CODE, TAX, and CONTENT_OWNER_ID.
• ZX_ACCOUNTS — supplies the tax account CCID via TAX_ACCOUNT_ENTITY_ID and TAX_ACCOUNT_ENTITY_CODE = 'RATES'.
• ZX_PARTY_TAX_PROFILE — the party tax profile that acts as the content owner.
• ZX_REPORTING_TYPES_B, ZX_REPORTING_CODES_B, ZX_REPORTING_CODES_TL — the reporting-code hierarchy; the type code PRINTED_TAX_RATE_NAME resolves to a translated reporting code name used for the TAX_NAME column.
• ZX_REPORT_CODES_ASSOC — associates the reporting code to the ZX_RATES entity via ENTITY_CODE = 'ZX_RATES'.
• GL_CODE_COMBINATIONS — joined through the resolved key flexfield reference for the tax account.
• HR_ALL_ORGANIZATION_UNITS — resolves the operating unit name.

Key Columns

• TAX_CODE_ID — mapped from RATES.TAX_RATE_ID; the unique rate identifier exposed as a legacy tax code ID.
• TAX_CODE — the tax rate code from ZX_RATES_B.
• TAX_NAME — the translated reporting code name (REPCODEST.REPORTING_CODE_NAME) driven by the PRINTED_TAX_RATE_NAME reporting type.
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — the rate's effective date range.
• TAX_RATE — the percentage rate from ZX_RATES_B.
• TAX_CODE_DESCRIPTION — the translated tax rate name from ZX_RATES_TL.
• _LA:TAX_TYPE, _LA:ALLOW_EXEMPTION_FLAG, _LA:TAX_INCLUSIVE_FLAG — descriptive flexfield-style lookup references resolved against FND_LOOKUPS and AR_LOOKUPS.
• TAX_ACCOUNT_ID — the tax account CCID from ZX_ACCOUNTS.
• ORG_ID, CONTENT_OWNER_ID — the party ID and party tax profile ID, establishing multi-org security context.
• OPERATING_UNIT — the organization name from HR_ALL_ORGANIZATION_UNITS.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY for audit tracking.

Common Use Cases and Queries

The view is used primarily in AR tax reporting, tax rate listings, and integration extracts where legacy tax code structures are still expected. A typical query retrieving active tax codes with printed rate names is:

SELECT TAX_CODE_ID, TAX_CODE, TAX_NAME, TAX_RATE, START_EFFECTIVE_DATE, END_EFFECTIVE_DATE FROM APPS.ARFV_AR_TAX_CODES WHERE SYSDATE BETWEEN START_EFFECTIVE_DATE AND NVL(END_EFFECTIVE_DATE, SYSDATE + 1) ORDER BY TAX_CODE;

To list tax codes for a specific operating unit:

SELECT TAX_CODE, TAX_NAME, TAX_RATE, OPERATING_UNIT FROM APPS.ARFV_AR_TAX_CODES WHERE ORG_ID = :p_org_id;

Because the view joins translated tables using USERENV('LANG'), values such as TAX_NAME and TAX_CODE_DESCRIPTION are returned in the session language. It is frequently embedded in custom reports, interface tables, and data-conversion scripts that must supply AR-compatible tax code references while the underlying rates reside in E-Business Tax.