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:

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.