Search Results legislative_category_code




Overview
Explore in AI Chat

Overview

APPS.XLE_LE_FROM_REGISTRATIONS_V is a reporting view in Oracle E-Business Suite that presents legal-entity registration data sourced from two distinct registration models: the transaction tax registrations held in the ZX (E-Business Tax) schema, and the legal-entity registrations held in the XLE (Legal Entity) schema. Its purpose is to expose a unified list of registrations associated with a legal entity, including the registration number, the country of registration, the effective date range, and the legislative category classification. The view name reflects this consolidation: it derives the set of registrations that belong to a legal entity ("LE FROM REGISTRATIONS").

In the context of Oracle EBS 12.1.1 and 12.2.2, this view supports tax and legal-entity configuration reporting. It is commonly referenced by diagnostic queries and configuration reports that attempt to reconcile tax registrations (ZX_REGISTRATIONS) with legal-entity registrations (XLE_REGISTRATIONS), particularly for identifying discrepancies in tax registration setup across legal entities and operating units.

Underlying Base Objects

The view is defined as a UNION of two SELECT statements. The first branch joins ZX_REGISTRATIONS with ZX_PARTY_TAX_PROFILE, XLE_ETB_PROFILES, ZX_REGIMES_B, and AR_LOOKUPS, restricted to party tax profiles where PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'. This branch therefore returns transaction tax registrations linked to a legal entity through its party tax profile. The second branch joins XLE_REGISTRATIONS with XLE_ENTITY_PROFILES, XLE_JURISDICTIONS_B, HZ_GEOGRAPHIES, and AR_LOOKUPS, restricted to registrations where SOURCE_TABLE = 'XLE_ENTITY_PROFILES'. This branch returns registrations maintained directly against the legal entity.

The documented referenced objects are AR_LOOKUPS, HZ_GEOGRAPHIES (synonym), XLE_ENTITY_PROFILES (synonym), XLE_ETB_PROFILES (synonym), XLE_JURISDICTIONS_B (synonym), XLE_REGISTRATIONS (synonym), ZX_PARTY_TAX_PROFILE (synonym), ZX_REGIMES_B (synonym), and ZX_REGISTRATIONS (synonym). HZ_GEOGRAPHIES is exposed as a synonym in the APPS schema, while the ZX and XLE objects are likewise accessed through APPS synonyms over their base tables.

Key Columns

Common Use Cases and Queries

The view is typically queried to list all registrations for a legal entity, confirming which tax regimes and jurisdictions are configured. For example:

SELECT legal_entity_id, legal_entity_name, registration_number, country_of_registration, legislative_category_code FROM apps.xle_le_from_registrations_v WHERE legal_entity_id = :p_legal_entity_id ORDER BY effective_from;

It is also used to detect registrations that exist in one model but not the other, and to validate that every transaction tax registration is matched by a legal-entity registration. Diagnostic queries commonly filter on TRANSACTION_TAX_REGN_CONTEXT IS NOT NULL to isolate the ZX branch, or IS NULL to isolate the XLE branch. Because the view is a UNION, care should be taken when aggregating counts: the same registration number may appear in both branches if it is maintained in both models.