Search Results authority_name

Overview

APPS.XLE_LEGALAUTH_V is a reporting and integration view in Oracle E-Business Suite that exposes registered legal authorities as they are modeled within the Oracle Trading Community Architecture (TCA) and consumed by the E-Business Tax (EBTax) / E-Tax Reporting Model (ETRM) modules. In EBS 12.1.1 and 12.2.2, legal authorities represent government bodies or regulatory organizations that are relevant to tax and legal reporting, particularly where the Legal Entity Configurator (XLE) captures jurisdiction-level legislative information.

The view denormalizes several TCA tables into a single flattened row per legal authority party site, presenting the authority's name, address components, and the associated legislative category classification. This makes it suitable for direct SQL reporting, BI Publisher data sources, and inbound/outbound integration where a simple legal authority lookup is required. The view follows the common ETRM pattern of combining party, party site, location, and code assignment data with outer-joins to optional classification codes.

The prompt "Enter Me Legal Name" is not represented as a column in this view. The columns that effectively provide a legal authority name are AUTHORITY_NAME (the organization name) and, when present, the related PARTY_ID identification. Users searching for a "legal name" typically need to map to AUTHORITY_NAME or to HZ_ORGANIZATION_PROFILES.ORGANIZATION_NAME for the underlying party.

Underlying Base Objects

The view is defined over five TCA base objects, all referenced through public synonyms owned by APPS: HZ_CODE_ASSIGNMENTS, HZ_LOCATIONS, HZ_ORGANIZATION_PROFILES, HZ_PARTIES, and HZ_PARTY_SITES. Its driving logic consists of an inner join between HZ_PARTIES and HZ_CODE_ASSIGNMENTS on the BUSINESS_FUNCTION / LEGAL_AUTHORITY classification, ensuring only organizations tagged as legal authorities appear. HZ_ORGANIZATION_PROFILES supplies the authority name, HZ_PARTY_SITES and HZ_LOCATIONS supply the address, and HZ_CODE_ASSIGNMENTS is joined a second time via an outer join on LEGISLATIVE_CATEGORY to optionally attach a legislative category code.

Key Columns

• LEGALAUTH_ID — Party ID of the legal authority, sourced from HZ_ORGANIZATION_PROFILES.PARTY_ID.
• AUTHORITY_NAME — The organization name of the legal authority (HZ_ORGANIZATION_PROFILES.ORGANIZATION_NAME).
• ADDRESS_STYLE, ADDRESS1–ADDRESS4, CITY, STATE, POSTAL_CODE, COUNTRY — Address elements from HZ_LOCATIONS for the active party site.
• PARTY_ID — Identifier of the underlying TCA party.
• PARTY_SITE_ID — Identifier of the active party site supplying the address.
• LEGISLATIVE_CATEGORY_CODE — Class code from the optional LEGISLATIVE_CATEGORY assignment.

Common Use Cases and Queries

Typical uses include populating legal authority list of values, validating authority assignments on tax registrations, and extracting authority addresses for statutory reports.

SELECT legalauth_id, authority_name, city, state, postal_code, country
FROM   apps.xle_legalauth_v
ORDER  BY authority_name;

To resolve an authority by name for a "legal name" search:

SELECT legalauth_id, authority_name, party_site_id
FROM   apps.xle_legalauth_v
WHERE  UPPER(authority_name) LIKE UPPER('%'||:p_name||'%');

To filter by legislative category:

SELECT authority_name, legislative_category_code
FROM   apps.xle_legalauth_v
WHERE  legislative_category_code = :p_category;