Results for “contact_number”
50+ 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.1.1
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
The list of party contacts
APPS.JTF_RS_PARTY_CONTACTS_VL·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·↳ HZ_PARTIES·Explore JTF module →
-
View: AMS_LT_ORG_CONTACT_V 12.1.1
Data Source view to get information about b2b contacts
APPS.AMS_LT_ORG_CONTACT_V·↳ HZ_ORG_CONTACTS·Explore AMS module →
-
Stores detail information for scheduling
-
APPS.WSH_CARRIER_SITE_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore WSH module →
-
APPS.WSH_CARRIER_SITE_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore WSH module →
-
View: CSF_SR_HIST_V 12.2.2
Service History Extension View
APPS.CSF_SR_HIST_V·↳ CSF_SR_TASKS_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·Explore CSF module →
-
The list of party contacts
APPS.JTF_RS_PARTY_CONTACTS_VL·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·↳ HZ_PARTIES·Explore JTF module →
-
View: XLE_LEGAL_CONTACTS_V 12.2.2
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
TCA import table for HZ_PARTIES, HZ_RELATIONSHIPS and HZ_ORG_CONTACTS
-
View: AMS_LT_ORG_CONTACT_V 12.2.2
Data Source view to get information about b2b contacts
APPS.AMS_LT_ORG_CONTACT_V·↳ HZ_ORG_CONTACTS·Explore AMS module →
-
View: HZ_CONTACT_FIND_V 12.1.1
APPS.HZ_CONTACT_FIND_V·↳ FND_TERRITORIES_TL·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·Explore AR module →
-
View: ASO_I_ORG_CONTACTS_V 12.1.1
It gives the information about Party Name,Party Type etc.
APPS.ASO_I_ORG_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore ASO module →
-
View: ASO_I_ORG_CONTACTS_V 12.2.2
It gives the information about Party Name,Party Type etc.
APPS.ASO_I_ORG_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore ASO module →
-
View: HZ_ORG_CONTACTS_CPUI_V 12.2.2
Organization Contacts
APPS.HZ_ORG_CONTACTS_CPUI_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore AR module →
-
View: HZ_ORG_CONTACTS_CPUI_V 12.1.1
Organization Contacts
APPS.HZ_ORG_CONTACTS_CPUI_V·↳ HZ_ORG_CONTACTS·↳ HZ_RELATIONSHIPS·Explore AR module →
-
View: CS_SR_SEARCH_V 12.1.1
This view is used in the SR find window on Bali spread table
APPS.CS_SR_SEARCH_V·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·↳ CS_INCIDENTS_B_SEC·Explore CS module →
-
View: AST_ORG_CONTACTS_V 12.1.1
APPS.AST_ORG_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AST module →
-
People as contacts for parties
-
View: CS_SR_UWQ_LABEL_V 12.1.1
This view is a dummy view and will be used for creating label nodes in UWQ.
-
View: CS_SR_UWQ_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →
-
APPS.AR_CUSTOMER_CONTACT_FIND_V·↳ AR_CUSTOMER_FIND_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore AR module →
-
Table: FA_MAINT_REP_ITF 12.2.2
Interface table for Report eXchange reports
-
View: OE_RA_CONTACTS_V 12.2.2
This view is used for validation of contact idnetification.
APPS.OE_RA_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore ONT module →
-
Stores detail information for scheduling
-
APPS.AR_CUSTOMER_CONTACT_FIND_V·↳ AR_CUSTOMER_FIND_V·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore AR module →
-
View: CS_SR_UWQ_LABEL_V 12.2.2
This view is a dummy view and will be used for creating label nodes in UWQ.
-
It stores party/site org contacts without role type and person profile related information
APPS.AS_PARTY_ORG_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AS module →
-
View: HZ_CONTACT_FIND_V 12.2.2
APPS.HZ_CONTACT_FIND_V·↳ FND_TERRITORIES_TL·↳ HZ_CONTACT_POINTS·↳ HZ_CUST_ACCOUNTS·Explore AR module →
-
Table: FA_MAINT_REP_ITF 12.1.1
Interface table for Report eXchange reports
-
View: CS_SR_UWQ_GROUP_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_GROUP_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: CS_SR_UWQ_GROUP_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_GROUP_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: AMS_LEAD_MAPPING_V 12.1.1
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_LEAD_MAPPING_V·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
View: CSF_SR_HIST_V 12.1.1
Service History Extension View
APPS.CSF_SR_HIST_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CSF module →
-
View: CS_SR_UWQ_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_B·Explore CS module →
-
This view lists the details of organization contacts
APPS.AMS_ORG_CONTACT_DETAILS_V·↳ AR_LOOKUPS·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·Explore AMS module →
-
This view lists the details of organization contacts
APPS.AMS_ORG_CONTACT_DETAILS_V·↳ AR_LOOKUPS·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·Explore AMS module →
-
View: JTF_PARTY_CONTACTS_V 12.2.2
JTF_PARTY_CONTACTS_V retrieves all contacts for a party.
APPS.JTF_PARTY_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore JTF module →
-
People as contacts for parties
-
View: CS_SR_UWQ_TEAM_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_TEAM_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: AST_REL_V 12.1.1
APPS.AST_REL_V·↳ AR_LOOKUPS·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·Explore AST module →
-
View: CS_SR_UWQ_EMPLOYEE_V 12.2.2
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_EMPLOYEE_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: IGS_OR_CONTACTS_V 12.1.1
Describes the institution Contact Details
APPS.IGS_OR_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore IGS module →
-
View: CS_SR_UWQ_EMPLOYEE_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_EMPLOYEE_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: CS_SR_UWQ_TEAM_V 12.1.1
This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation.
APPS.CS_SR_UWQ_TEAM_V·↳ CSI_ITEM_INSTANCES·↳ CS_HZ_SR_CONTACT_POINTS·↳ CS_INCIDENTS_ALL_TL·Explore CS module →
-
View: HZ_ORG_CONTACTS_V 12.1.1
APPS.HZ_ORG_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AR module →
-
View: HZ_ORG_CONTACTS_V 12.2.2
APPS.HZ_ORG_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AR module →
-
View: JTF_PARTY_CONTACTS_V 12.1.1
JTF_PARTY_CONTACTS_V retrieves all contacts for a party.
APPS.JTF_PARTY_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore JTF module →