Search Results je_deferred_tax_type

Overview

APPS.JE_ES_TAX_TYPE_V is a reporting and integration view in Oracle E-Business Suite that exposes tax type and VAT reporting code information drawn from the Oracle E-Business Tax (EBTax) and Receivables lookup infrastructure. The view is defined as a UNION of two distinct data sets. The first set returns VAT reporting codes associated with the EMEA VAT reporting type, joined to VAT reporting entities and tax regime information. The second set returns lookup values from the AR_LOOKUPS table for the lookup type JE_DEFERRED_TAX_TYPE. This unioned construction makes the view a consolidated reference point for both standard VAT reporting code values and deferred tax type lookup values, which is the specific context in which the object is most frequently sought.

The view is owned by the APPS schema and is exposed to reporting tools, concurrent programs, and integration interfaces that require a compact list of tax type codes and their associated reporting names. Because it combines code values from EBTax configuration with a Receivables lookup set, it serves as a lightweight lookup source rather than a transactional fact view.

Underlying Base Objects

The documented base objects referenced by the view are AR_LOOKUPS (a view), JG_ZZ_VAT_REP_ENTITIES (synonym), ZX_REPORTING_CODES_B (synonym), ZX_REPORTING_CODES_TL (synonym), and ZX_REPORTING_TYPES_B (synonym). The synonyms resolve to the underlying EBTax and tax reporting entity tables.

The first branch of the UNION drives its selection from ZX_REPORTING_TYPES_B, filtered to REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'. It joins to ZX_REPORTING_CODES_B through REPORTING_TYPE_ID, then to the translation table ZX_REPORTING_CODES_TL through REPORTING_CODE_ID, applying a language filter using USERENV('LANG') and a date-effective window between EFFECTIVE_FROM and EFFECTIVE_TO. It further joins JG_ZZ_VAT_REP_ENTITIES (aliased RPS and RPS1) on the mapping/vat reporting entity identifiers, and links ZX_REPORTING_TYPES_B to the tax regime code. The second branch is a simple projection of LOOKUP_CODE and MEANING from AR_LOOKUPS where LOOKUP_TYPE = 'JE_DEFERRED_TAX_TYPE', with NULL placeholders for the columns that only exist in the first branch.

Key Columns

• Reporting_Code_Char_Value — the character code value of the VAT reporting code; primary identifier from the EMEBA VAT branch.
• Reporting_Code_Name — the translated, user-facing name of the reporting code.
• Vat_Reporting_Entity_Id — identifier of the VAT reporting entity associated with the reporting code.
• Mapping_Vat_Rep_Entity_Id — the mapped VAT reporting entity identifier; when present, the entity join resolves through NVL(Mapping_Vat_Rep_Entity_Id, Vat_Reporting_Entity_Id).
• Tax_Regime_Code — the tax regime associated with the reporting code.
• Tax — the tax identifier or tax code column returned by the EBTax branch.
• For the deferred tax branch, Reporting_Code_Char_Value carries the LOOKUP_CODE and Reporting_Code_Name carries the MEANING; the remaining columns are NULL.

Common Use Cases and Queries

The view is typically queried to enumerate deferred tax type lookup values or to resolve VAT reporting codes for a given reporting entity. A representative query for the deferred tax subset is:

SELECT Reporting_Code_Char_Value, Reporting_Code_Name
FROM   APPS.JE_ES_TAX_TYPE_V
WHERE  Tax_Regime_Code IS NULL;

Reporting code lookups by entity take the following form:

SELECT Reporting_Code_Char_Value, Reporting_Code_Name, Tax_Regime_Code
FROM   APPS.JE_ES_TAX_TYPE_V
WHERE  Vat_Reporting_Entity_Id = :entity_id;

Because the view is language-sensitive and date-effectivity filtered, queries executed in the appropriate session language and current date automatically return only active reporting codes. It is commonly referenced as a lookup source for value sets, custom EBTax reconciliation reports, and EMEA VAT reporting extracts, and as a convenient substitute for joining the EBTax reporting code tables directly.