Results for “entity_party_id”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The XLE_LEGAL_CONTACTS_V view, owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, exposes the roster of legal contacts associated with legal entities and establishments defined through the Legal Entity Configurator (XLE). It consolidates person-level contact relationships stored in the Oracle Trading Community Architecture (TCA) registry into a single, security-friendly projection keyed by legal entity or establishment. The view is critical for reporting and integration scenarios that require the identification of a legal representative — the individual whose fiscal code (tax identifier) or name is printed on statutory documents, invoices, and regulatory filings.
Because the view is defined with a UNION of two nearly identical branches, it returns contacts for both legal entities (from XLE_ENTITY_PROFILES) and establishments (from XLE_ETB_PROFILES), distinguished by the ENTITY_TYPE column. This dual-scope design means a single query can retrieve all legal contacts across the enterprise hierarchy without joining to each profile table individually.
Underlying Base Objects
The view is built over the following documented base objects:
- HZ_RELATIONSHIPS — supplies the
CONTACT_OFrelationship linking a person party (subject) to an entity party (object). Filters enforceRELATIONSHIP_TYPE = 'CONTACT',DIRECTIONAL_FLAG = 'F', and an active end-date condition (TRUNC(NVL(REL.END_DATE, SYSDATE)) > TRUNC(SYSDATE)), so only currently effective contacts are returned. - HZ_PARTIES — provides the contact person's name (
PARTY_NAME), fiscal/tax identifier (JGZZ_FISCAL_CODE), and party number. - HZ_PERSON_PROFILES — contributes the person's pre-name adjunct/title via
PERSON_PRE_NAME_ADJUNCT. - HZ_ORG_CONTACTS — joined on
PARTY_RELATIONSHIP_IDto confirm the contact is registered against the organization. - XLE_ENTITY_PROFILES — the legal entity registration profile, supplying
LEGAL_ENTITY_ID. - XLE_ETB_PROFILES — the establishment registration profile, supplying
ESTABLISHMENT_ID. - XLE_CONTACT_GRP — a PL/SQL package whose
CONCAT_CONTACT_ROLESfunction derives the concatenated job-title string exposed asJOB_TITLE.
Key Columns
- ENTITY_ID — the legal entity ID or establishment ID, depending on
ENTITY_TYPE. - ENTITY_TYPE — literal
'LEGAL_ENTITY'or'ESTABLISHMENT', identifying the branch that produced the row. - ENTITY_PARTY_ID — the TCA party ID of the entity or establishment.
- CONTACT_PARTY_ID — the TCA party ID of the contact person.
- CONTACT_NAME — the contact person's full party name.
- CONTACT_LEGAL_ID — the person's fiscal code (
JGZZ_FISCAL_CODE); this is the column most commonly matched when users search for contact_legal_id, since it carries the government-issued legal identifier of the contact. - ROLE — literal
'LEGAL CONTACT'. - TITLE — the person's pre-name adjunct or honorific.
- CONTACT_NUMBER — the TCA party number of the contact.
- JOB_TITLE — concatenated contact roles derived by
XLE_CONTACT_GRP.CONCAT_CONTACT_ROLES.
Common Use Cases and Queries
Typical usage includes statutory reporting, integration extracts into tax engines, and data-quality audits of parties missing a legal identifier. To retrieve all legal contacts for a specific legal entity:
SELECT contact_name, contact_legal_id, job_title, title FROM xle_legal_contacts_v WHERE entity_type = 'LEGAL_ENTITY' AND entity_id = :p_legal_entity_id;- To find an entity by the contact's fiscal code:
SELECT entity_id, entity_type, contact_name FROM xle_legal_contacts_v WHERE contact_legal_id = :p_tax_id; - To audit contacts lacking a fiscal code:
SELECT entity_id, contact_name FROM xle_legal_contacts_v WHERE contact_legal_id IS NULL;
Because the view resolves active relationships only, historical or end-dated contacts are excluded; consumers requiring temporal history must query HZ_RELATIONSHIPS directly.
-
View: XLE_LEGAL_CONTACTS_V 12.2.2
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
View: XLE_LEGAL_CONTACTS_V 12.1.1
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
eTRM - XLE Tables and Views 12.2.2
XLE_UNQ_PROFILES stores information about an Unqualified Legal Construct
-
eTRM - XLE Tables and Views 12.1.1
XLE_UNQ_PROFILES stores information about an Unqualified Legal Construct