Results for “ce_misc_tax_code_v”

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

Overview

CE_MISC_TAX_CODE_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, classified under the Cash Management (CE) product family. The object carries a status of VALID and is documented in ETRM with the notation "Retrofitted," indicating that the view was adapted during an upgrade or patch cycle to align with the Oracle E-Business Tax (EBTax / ZX) data model introduced in Release 12. In practice, the view presents a flattened, reporting-friendly projection of miscellaneous tax rate codes and their associated accounting attributes, joining rate definitions from the ZX_SCO_RATES table with account assignments from ZX_ACCOUNTS.

The name "MISC_TAX_CODE" reflects its purpose: exposing tax codes that are not tied to a specific tax jurisdiction (the underlying query excludes rows where TAX_JURISDICTION_CODE is not null) and that are not location-based (rows with TAX equal to 'LOCATION' are filtered out). The view therefore surfaces non-jurisdictional, rate-class tax codes — typically used for miscellaneous charges, fees, or internal tax-like computations — together with the ledger and organization context in which each rate is effective.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed to APPS as synonyms:

• ZX_SCO_RATES — the EBTax rate definition table (SCO denotes "Setup: Charge/rate" structures). It supplies the tax rate code, tax name, rate type, quantity or percentage rate, effective dates, tax class, and tax rate identifier.
• ZX_ACCOUNTS — the EBTax accounts table, which maps tax entities to ledgers and internal organizations. It is joined on TAX_ACCOUNT_ENTITY_ID = TAX_RATE_ID with TAX_ACCOUNT_ENTITY_CODE = 'RATES', ensuring that only rate-level account assignments contribute rows.

The join is effectively an inner join, so a rate appears in the view only when an active account mapping exists. Rows are filtered by ACTIVE_FLAG = 'Y' on the rate side and ordered by TAX_RATE_CODE.

Key Columns

• TAX_CODE — sourced from SCO.TAX_RATE_CODE; the user-facing identifier for the miscellaneous tax rate.
• TAX, MEANING, VAT_TAX_ID — descriptive attributes of the tax code, including the tax name and the VAT tax reference where applicable.
• TAX_RATE — the numeric rate, computed as ABS of either QUANTITY_RATE or PERCENTAGE_RATE depending on RATE_TYPE_CODE, so quantity-based and percentage-based rates are normalized into one column.
• TAX_RATE_ID / START_DATE / END_DATE — the surrogate key (from SCO.TAX_RATE_ID) and the EFFECTIVE_FROM / EFFECTIVE_TO date range for which the rate is valid.
• SET_OF_BOOKS_ID (LEDGER_ID) — the ledger from ZX_ACCOUNTS in which the rate is accounted.
• TAX_CLASS — the first character of SCO.TAX_CLASS, a single-character classification of the rate.
• ORG_ID — the INTERNAL_ORGANIZATION_ID from ZX_ACCOUNTS, enabling multi-org (MOAC) filtering.

Common Use Cases and Queries

The view is typically used in Cash Management reporting and in custom reconciliation or integration logic that needs a simple list of miscellaneous tax codes with their rates and ledger/organization context. A representative query is:

• SELECT tax_code, tax_rate, tax_class, ledger_id, org_id FROM apps.ce_misc_tax_code_v WHERE org_id = :p_org_id AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, TRUNC(SYSDATE));
• Filtering by TAX_CLASS to isolate a category of miscellaneous rates for a given ledger.
• Joining to CE bank or cash transaction tables on TAX_CODE to derive the applicable rate at posting time.

Because the view normalizes rate types and carries ORG_ID, it is well suited to MOAC-aware reports. Note that, being a retrofitted view, it should be treated as a reporting convenience rather than a maintained API; direct DML is not supported, and any change to ZX_SCO_RATES or ZX_ACCOUNTS is immediately reflected in the view's results.