Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - XLE Tables and Views

TABLE - XLE.XLE_ASSOCIATIONS
TABLE - XLE.XLE_ASSOCIATION_TYPES
TABLE - XLE.XLE_ASSOC_OBJECT_TYPES
TABLE - XLE.XLE_CONFIG_HISTORY
TABLE - XLE.XLE_CONTACT_LEGAL_ROLES
TABLE - XLE.XLE_ENTITY_PROFILES
TABLE - XLE.XLE_ETB_PROFILES
TABLE - XLE.XLE_HISTORIES
TABLE - XLE.XLE_HISTORY_COLUMNS
TABLE - XLE.XLE_HISTORY_COLUMNS_B
TABLE - XLE.XLE_HISTORY_COLUMNS_TL
TABLE - XLE.XLE_JURISDICTIONS_B
TABLE - XLE.XLE_JURISDICTIONS_TL
TABLE - XLE.XLE_JUR_FUNCTIONS
TABLE - XLE.XLE_LE_BSV_INTERFACE
TABLE - XLE.XLE_LE_INTERFACE
TABLE - XLE.XLE_LE_OU_INTERFACE
TABLE - XLE.XLE_LE_SOB_INTERFACE
TABLE - XLE.XLE_REGISTRATIONS
TABLE - XLE.XLE_REG_FUNCTIONS
TABLE - XLE.XLE_SOB_INTERFACE
TABLE - XLE.XLE_UNQ_PROFILES
VIEW - APPS.XLE_ASSOCIATIONS_V
VIEW - APPS.XLE_BSV_ASSOCIATIONS
VIEW - APPS.XLE_ESTABLISHMENT_V
VIEW - APPS.XLE_FIRSTPARTY_INFORMATION_V
VIEW - APPS.XLE_FP_ESTABLISHMENT_V
VIEW - APPS.XLE_FP_LEDGER_V
VIEW - APPS.XLE_FP_OU_LEDGER_V
VIEW - APPS.XLE_FP_REGISTRATIONS_V
VIEW - APPS.XLE_HISTORY_COLUMNS_VL
VIEW - APPS.XLE_JURISDICTIONS_VL
VIEW - APPS.XLE_LEGALAUTH_V
VIEW - APPS.XLE_LEGAL_CONTACTS_V
VIEW - APPS.XLE_LE_FROM_REGISTRATIONS
VIEW - APPS.XLE_LE_FROM_REGISTRATIONS_V
VIEW - APPS.XLE_LE_OU_LEDGER_V
VIEW - APPS.XLE_LOOKUPS
VIEW - APPS.XLE_REGISTRATIONS_V
VIEW - APPS.XLE_TAX_ASSOCIATIONS

Table: XLE_ASSOCIATIONS

Description: XLE_ASSOCIATIONS stores the Legal Associations
Comments
XLE_ASSOCIATIONS stores the Legal Associations
Indexes
Index Type Tablespace Column
XLE_ASSOCIATIONS_U1 UNIQUE APPS_TS_TX_IDX ASSOCIATION_ID
XLE_ASSOCIATIONS_U2 UNIQUE APPS_TS_TX_IDX ASSOCIATION_TYPE_ID
SUBJECT_ID
OBJECT_ID
EFFECTIVE_FROM
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER (15) Y Legal Association Identifier
ASSOCIATION_TYPE_ID NUMBER (15) Y Association Type Identifier.Foreign Key to XLE_ASSOCIATION_TYPES table
SUBJECT_ID NUMBER (15) Y Identifier of the Subject of the Legal Association
SUBJECT_PARENT_ID NUMBER (15)
Parent ID of the Subject ID. Will currently store the Legal Entity ID if the Subject Type is an Establishment
OBJECT_ID NUMBER (15) Y Identifier of the Object of the Legal Association.Foreign Key to the base table where instances of the subjects are stored.
EFFECTIVE_FROM DATE
Y Date from which the association is effective
EFFECTIVE_TO DATE

Date after which the association is ended
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ASSOC_INFORMATION_CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure definition
ASSOC_INFORMATION1 VARCHAR2 (150)
Developer Flexfield Segment 1
ASSOC_INFORMATION2 VARCHAR2 (150)
Developer Flexfield Segment 2
ASSOC_INFORMATION3 VARCHAR2 (150)
Developer Flexfield Segment 3
ASSOC_INFORMATION4 VARCHAR2 (150)
Developer Flexfield Segment 4
ASSOC_INFORMATION5 VARCHAR2 (150)
Developer Flexfield Segment 5
ASSOC_INFORMATION6 VARCHAR2 (150)
Developer Flexfield Segment 6
ASSOC_INFORMATION7 VARCHAR2 (150)
Developer Flexfield Segment 7
ASSOC_INFORMATION8 VARCHAR2 (150)
Developer Flexfield Segment 8
ASSOC_INFORMATION9 VARCHAR2 (150)
Developer Flexfield Segment 9
ASSOC_INFORMATION10 VARCHAR2 (150)
Developer Flexfield Segment 10
ASSOC_INFORMATION11 VARCHAR2 (150)
Developer Flexfield Segment 11
ASSOC_INFORMATION12 VARCHAR2 (150)
Developer Flexfield Segment 12
ASSOC_INFORMATION13 VARCHAR2 (150)
Developer Flexfield Segment 13
ASSOC_INFORMATION14 VARCHAR2 (150)
Developer Flexfield Segment 14
ASSOC_INFORMATION15 VARCHAR2 (150)
Developer Flexfield Segment 15
ASSOC_INFORMATION16 VARCHAR2 (150)
Developer Flexfield Segment 16
ASSOC_INFORMATION17 VARCHAR2 (150)
Developer Flexfield Segment 17
ASSOC_INFORMATION18 VARCHAR2 (150)
Developer Flexfield Segment 18
ASSOC_INFORMATION19 VARCHAR2 (150)
Developer Flexfield Segment 19
ASSOC_INFORMATION20 VARCHAR2 (150)
Developer Flexfield Segment 20

[top of page]

XLE.XLE_ASSOCIATIONS does not reference any database object

XLE.XLE_ASSOCIATIONS is referenced by following:

XLE
VIEW - XLE_ASSOCIATIONS#

[top of page]

Table: XLE_ASSOCIATION_TYPES

Description: XLE_ASSOCIATION_TYPES stores the different Association Types that will be used in Legal Associations
Comments
XLE_ASSOCIATION_TYPES stores the different Association Types that will be used in Legal Associations
Indexes
Index Type Tablespace Column
XLE_ASSOCIATION_TYPES_U1 UNIQUE APPS_TS_TX_IDX ASSOCIATION_TYPE_ID
ZD_EDITION_NAME
XLE_ASSOCIATION_TYPES_U2 UNIQUE APPS_TS_TX_IDX CONTEXT
SUBJECT_TYPE_ID
OBJECT_TYPE_ID
EFFECTIVE_FROM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_TYPE_ID NUMBER (15) Y Association Type Identifier
CONTEXT VARCHAR2 (80) Y Context in which the Association Type is used
SUBJECT_TYPE_ID NUMBER (15) Y Subject Type Identifier,Foreign Key to XLE_ASSOC_OBJECT_TYPES table
OBJECT_TYPE_ID NUMBER (15) Y Object Type Identifier,Foreign Key to the XLE_ASSOC_OBJECT_TYPES table
CARDINALITY VARCHAR2 (2)
Defines the Cardinality of the Association. The direction of the cardinality is Subject to Object.
EFFECTIVE_FROM DATE
Y Date from which the association type is effective
EFFECTIVE_TO DATE

Date after which the association type is ended
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_ASSOCIATION_TYPES does not reference any database object

XLE.XLE_ASSOCIATION_TYPES is referenced by following:

XLE
VIEW - XLE_ASSOCIATION_TYPES#

[top of page]

Table: XLE_ASSOC_OBJECT_TYPES

Description: XLE_ASSOC_OBJECT_TYPES stores the different Object Types that will be used in Legal Associations
Comments
XLE_ASSOC_OBJECT_TYPES stores the different Object Types that will be used in Legal Associations
Indexes
Index Type Tablespace Column
XLE_ASSOC_OBJECT_TYPES_U1 UNIQUE APPS_TS_TX_IDX OBJECT_TYPE_ID
ZD_EDITION_NAME
XLE_ASSOC_OBJECT_TYPES_U2 UNIQUE APPS_TS_TX_IDX NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE_ID NUMBER (15) Y Object Type Identifier
NAME VARCHAR2 (80) Y Object Type Name
SOURCE_TABLE VARCHAR2 (40) Y Name of the table where instances of the Object Type are stored
WHERE_CLAUSE VARCHAR2 (500)
Additional clause to identify records of a given Object Type
SOURCE_COLUMN1 VARCHAR2 (30) Y Column that uniquely identifies a record in the Source Table
SOURCE_COLUMN2 VARCHAR2 (30)
Additional Column to uniquely identifies a record in the Source Table
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_ASSOC_OBJECT_TYPES does not reference any database object

XLE.XLE_ASSOC_OBJECT_TYPES is referenced by following:

XLE
VIEW - XLE_ASSOC_OBJECT_TYPES#

[top of page]

Table: XLE_CONFIG_HISTORY

Description:
Comments
Indexes
Index Type Tablespace Column
XLE_CONFIG_HISTORY_U1 UNIQUE APPS_TS_TX_IDX CONFIG_HISTORY_ID
XLE_CONFIG_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX SOURCE_TABLE
SOURCE_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
CONFIG_HISTORY_ID NUMBER (15) Y Configuration History Identifier
EFFECTIVE_DATE DATE
Y Effective Date
SOURCE_TABLE VARCHAR2 (30) Y Name of the table containing the tracked column
SOURCE_ID NUMBER (15) Y Source Identifier
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Name of the tracked column
OLD_VALUE VARCHAR2 (150)
Old Value of the tracked column
NEW_VALUE VARCHAR2 (150) Y New Value of the tracked column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

XLE.XLE_CONFIG_HISTORY does not reference any database object

XLE.XLE_CONFIG_HISTORY is referenced by following:

XLE
VIEW - XLE_CONFIG_HISTORY#

[top of page]

Table: XLE_CONTACT_LEGAL_ROLES

Description: XLE_CONTACT_LEGAL_ROLES table stores the legal roles that a contact can have
Comments
XLE_CONTACT_LEGAL_ROLES table stores the legal roles that a contact can have
Indexes
Index Type Tablespace Column
XLE_CONTACT_LEGAL_ROLES_U1 UNIQUE APPS_TS_TX_IDX CONTACT_ROLE_ID
XLE_CONTACT_LEGAL_ROLES_N1 NONUNIQUE APPS_TS_TX_IDX LE_ETB_PARTY_ID
XLE_CONTACT_LEGAL_ROLES_N2 NONUNIQUE APPS_TS_TX_IDX SOURCE_TABLE
SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
CONTACT_ROLE_ID NUMBER
Y Contact Role Identifier.Primary key generated from sequence
CONTACT_PARTY_ID NUMBER
Y Contact Party Identifier,Foreign key from HZ_PARTIES for the contact person
LE_ETB_PARTY_ID NUMBER
Y Legal Entity or Establishment Party Identifier,Foreign key from HZ_PARTIES for the Legal Entity or Establishment
SOURCE_TABLE VARCHAR2 (30)
Source Table Name for the information (XLE_ENTITY_PROFILES XLE_ETB_PROFILES)
SOURCE_ID NUMBER

Source Identifier,Identifier for the Registered Legal Entity or Establishment
LOOKUP_TYPE VARCHAR2 (30)
The lookup type for the data being stored in this table. For eg. XLE_CONTACT_ROLE
LOOKUP_CODE VARCHAR2 (30)
Lookup Code
EFFECTIVE_FROM DATE

Effective Date From
EFFECTIVE_TO DATE

Effective Date To
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

XLE.XLE_CONTACT_LEGAL_ROLES does not reference any database object

XLE.XLE_CONTACT_LEGAL_ROLES is referenced by following:

XLE
VIEW - XLE_CONTACT_LEGAL_ROLES#

[top of page]

Table: XLE_ENTITY_PROFILES

Description: XLE_ENTITY_PROFILES stores the general information, which identifies a Party with the classification of Legal Entity
Comments
XLE_ENTITY_PROFILES stores the general information, which identifies a Party with the classification of Legal Entity
Indexes
Index Type Tablespace Column
XLE_ENTITY_PROFILES_U1 UNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
XLE_ENTITY_PROFILES_N1 NONUNIQUE APPS_TS_TX_IDX NAME
XLE_ENTITY_PROFILES_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y Legal Entity Identifier
PARTY_ID NUMBER (15) Y Party Identifier
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
Legal Entity Identifier
NAME VARCHAR2 (240) Y Name
GEOGRAPHY_ID NUMBER (15) Y Geography Identifier
TRANSACTING_ENTITY_FLAG VARCHAR2 (1)
Transacting Entity Flag
EFFECTIVE_FROM DATE

Effective From
EFFECTIVE_TO DATE

Effective To
LE_INFORMATION_CONTEXT VARCHAR2 (30)
Developer Flexfield Segment Context
LE_INFORMATION1 VARCHAR2 (150)
Developer Flexfield Segment 1
LE_INFORMATION2 VARCHAR2 (150)
Developer Flexfield Segment 2
LE_INFORMATION3 VARCHAR2 (150)
Developer Flexfield Segment 3
LE_INFORMATION4 VARCHAR2 (150)
Developer Flexfield Segment 4
LE_INFORMATION5 VARCHAR2 (150)
Developer Flexfield Segment 5
LE_INFORMATION6 VARCHAR2 (150)
Developer Flexfield Segment 6
LE_INFORMATION7 VARCHAR2 (150)
Developer Flexfield Segment 7
LE_INFORMATION8 VARCHAR2 (150)
Developer Flexfield Segment 8
LE_INFORMATION9 VARCHAR2 (150)
Developer Flexfield Segment 9
LE_INFORMATION10 VARCHAR2 (150)
Developer Flexfield Segment 10
LE_INFORMATION11 VARCHAR2 (150)
Developer Flexfield Segment 11
LE_INFORMATION12 VARCHAR2 (150)
Developer Flexfield Segment 12
LE_INFORMATION13 VARCHAR2 (150)
Developer Flexfield Segment 13
LE_INFORMATION14 VARCHAR2 (150)
Developer Flexfield Segment 14
LE_INFORMATION15 VARCHAR2 (150)
Developer Flexfield Segment 15
LE_INFORMATION16 VARCHAR2 (150)
Developer Flexfield Segment 16
LE_INFORMATION17 VARCHAR2 (150)
Developer Flexfield Segment 17
LE_INFORMATION18 VARCHAR2 (150)
Developer Flexfield Segment 18
LE_INFORMATION19 VARCHAR2 (150)
Developer Flexfield Segment 19
LE_INFORMATION20 VARCHAR2 (150)
Developer Flexfield Segment 20
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20
ACTIVITY_CODE VARCHAR2 (150)
Activity Code
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub-Activity Code
TYPE_OF_COMPANY VARCHAR2 (50)
Type Of Company

[top of page]

XLE.XLE_ENTITY_PROFILES does not reference any database object

XLE.XLE_ENTITY_PROFILES is referenced by following:

XLE
VIEW - XLE_ENTITY_PROFILES#

[top of page]

Table: XLE_ETB_PROFILES

Description: XLE_ETB_PROFILES stores the general information, which identifies a Party (HZ_PARTIES) with the classification of Establishment
Comments
XLE_ETB_PROFILES stores the general information, which identifies a Party (HZ_PARTIES) with the classification of Establishment
Indexes
Index Type Tablespace Column
XLE_ETB_PROFILES_U1 UNIQUE APPS_TS_TX_IDX ESTABLISHMENT_ID
XLE_ETB_PROFILES_N1 NONUNIQUE APPS_TS_TX_IDX NAME
XLE_ETB_PROFILES_N2 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
XLE_ETB_PROFILES_N3 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
ESTABLISHMENT_ID NUMBER (15) Y Establishment Identifier
PARTY_ID NUMBER (15) Y Party Identifier
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
GEOGRAPHY_ID NUMBER (15) Y Geography Identifier
NAME VARCHAR2 (240) Y Name
MAIN_ESTABLISHMENT_FLAG VARCHAR2 (1)
Main Establishment Flag
MAIN_EFFECTIVE_FROM DATE

Main Effective From
MAIN_EFFECTIVE_TO DATE

Main Effective To
EFFECTIVE_FROM DATE

Effective From
EFFECTIVE_TO DATE

Effective To
ETB_INFORMATION_CONTEXT VARCHAR2 (30)
Developer Flexfield Segment Context
ETB_INFORMATION1 VARCHAR2 (150)
Developer Flexfield Segment 1
ETB_INFORMATION2 VARCHAR2 (150)
Developer Flexfield Segment 2
ETB_INFORMATION3 VARCHAR2 (150)
Developer Flexfield Segment 3
ETB_INFORMATION4 VARCHAR2 (150)
Developer Flexfield Segment 4
ETB_INFORMATION5 VARCHAR2 (150)
Developer Flexfield Segment 5
ETB_INFORMATION6 VARCHAR2 (150)
Developer Flexfield Segment 6
ETB_INFORMATION7 VARCHAR2 (150)
Developer Flexfield Segment 7
ETB_INFORMATION8 VARCHAR2 (150)
Developer Flexfield Segment 8
ETB_INFORMATION9 VARCHAR2 (150)
Developer Flexfield Segment 9
ETB_INFORMATION10 VARCHAR2 (150)
Developer Flexfield Segment 10
ETB_INFORMATION11 VARCHAR2 (150)
Developer Flexfield Segment 11
ETB_INFORMATION12 VARCHAR2 (150)
Developer Flexfield Segment 12
ETB_INFORMATION13 VARCHAR2 (150)
Developer Flexfield Segment 13
ETB_INFORMATION14 VARCHAR2 (150)
Developer Flexfield Segment 14
ETB_INFORMATION15 VARCHAR2 (150)
Developer Flexfield Segment 15
ETB_INFORMATION16 VARCHAR2 (150)
Developer Flexfield Segment 16
ETB_INFORMATION17 VARCHAR2 (150)
Developer Flexfield Segment 17
ETB_INFORMATION18 VARCHAR2 (150)
Developer Flexfield Segment 18
ETB_INFORMATION19 VARCHAR2 (150)
Developer Flexfield Segment 19
ETB_INFORMATION20 VARCHAR2 (150)
Developer Flexfield Segment 20
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20
ACTIVITY_CODE VARCHAR2 (150)
Activity Code
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub Activity Code
TYPE_OF_COMPANY VARCHAR2 (50)
Type Of Company

[top of page]

XLE.XLE_ETB_PROFILES does not reference any database object

XLE.XLE_ETB_PROFILES is referenced by following:

XLE
VIEW - XLE_ETB_PROFILES#

[top of page]

Table: XLE_HISTORIES

Description: XLE_HISTORIES stores table and column names for tracked Registration attributes
Comments
XLE_HISTORIES stores table and column names for tracked Registration attributes
Indexes
Index Type Tablespace Column
XLE_HISTORIES_U1 UNIQUE APPS_TS_TX_IDX HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
HISTORY_ID NUMBER (15) Y History Identifier
SOURCE_TABLE VARCHAR2 (30) Y Source Table
SOURCE_ID NUMBER (15) Y Source Identifier
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Name of the tracked column
SOURCE_COLUMN_VALUE VARCHAR2 (2000)
Value of the tracked column
EFFECTIVE_FROM DATE

Effective From
EFFECTIVE_TO DATE

Effective To
COMMENTS VARCHAR2 (240)
Comments
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

XLE.XLE_HISTORIES does not reference any database object

XLE.XLE_HISTORIES is referenced by following:

XLE
VIEW - XLE_HISTORIES#

[top of page]

Table: XLE_HISTORY_COLUMNS

Description: XLE_HISTORY_COLUMNS stores table and column names for tracked legal entity and establishment attributes
Comments
XLE_HISTORY_COLUMNS stores table and column names for tracked legal entity and establishment attributes
Columns
Name Datatype Length Mandatory Comments
HISTORY_COLUMN_ID NUMBER (15) Y Table identifier
SOURCE_TABLE VARCHAR2 (30) Y Name of the table containing the tracked column
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Name of the tracked column
GEOGRAPHY_ID NUMBER (15)
Geography Identifier. For tracking country dependent columns
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column

[top of page]

XLE.XLE_HISTORY_COLUMNS does not reference any database object

XLE.XLE_HISTORY_COLUMNS is referenced by following:

XLE
VIEW - XLE_HISTORY_COLUMNS#

[top of page]

Table: XLE_HISTORY_COLUMNS_B

Description: XLE_HISTORY_COLUMNS_B stores the information about tracked legal entity and establishment attributes
Comments
XLE_HISTORY_COLUMNS_B stores the information about tracked legal entity and establishment attributes
Indexes
Index Type Tablespace Column
XLE_HISTORY_COLUMNS_B_U1 UNIQUE APPS_TS_TX_IDX HISTORY_COLUMN_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
HISTORY_COLUMN_ID NUMBER (15) Y Table identifier
SOURCE_TABLE VARCHAR2 (30) Y Name of the table containing the tracked column
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Name of the tracked column
GEOGRAPHY_ID NUMBER (15)
Geography Identifier. For tracking country dependent columns
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_HISTORY_COLUMNS_B does not reference any database object

XLE.XLE_HISTORY_COLUMNS_B is referenced by following:

XLE
VIEW - XLE_HISTORY_COLUMNS_B#

[top of page]

Table: XLE_HISTORY_COLUMNS_TL

Description: XLE_HISTORY_COLUMNS_TL stores the translations of the prompts for tracked legal entity and establishment attributes
Comments
XLE_HISTORY_COLUMNS_TL stores the translations of the prompts for tracked legal entity and establishment attributes
Indexes
Index Type Tablespace Column
XLE_HISTORY_COLUMNS_TL_U1 UNIQUE APPS_TS_TX_IDX HISTORY_COLUMN_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
HISTORY_COLUMN_ID NUMBER (15) Y History Column Identifier
SOURCE_COLUMN_PROMPT VARCHAR2 (240) Y Name of the prompt for the tracked column (Translated column)
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
SOURCE_TABLE VARCHAR2 (30) Y Source Table
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Source Column Name
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_HISTORY_COLUMNS_TL does not reference any database object

XLE.XLE_HISTORY_COLUMNS_TL is referenced by following:

XLE
VIEW - XLE_HISTORY_COLUMNS_TL#

[top of page]

Table: XLE_JURISDICTIONS_B

Description: XLE_JURISDICTIONS stores the information about Jurisdictions
Comments
XLE_JURISDICTIONS stores the information about Jurisdictions
Indexes
Index Type Tablespace Column
XLE_JURISDICTIONS_B_U1 UNIQUE APPS_TS_TX_IDX JURISDICTION_ID
ZD_EDITION_NAME
XLE_JURISDICTIONS_B_N1 NONUNIQUE APPS_TS_TX_IDX LEGISLATIVE_CAT_CODE
Columns
Name Datatype Length Mandatory Comments
JURISDICTION_ID NUMBER (15) Y Jurisdiction Identifier
LEGISLATIVE_CAT_CODE VARCHAR2 (30) Y Legislative Category Code
GEOGRAPHY_ID NUMBER (15) Y Geography Identifier
REGISTRATION_CODE_LE VARCHAR2 (30)
Registration code used for Legal Entity
REGISTRATION_CODE_ETB VARCHAR2 (30)
Registration code used for Establishment
IDENTIFYING_FLAG VARCHAR2 (1)
Yes/No flag for Identifying jurisdiction for Legal entities
REQUIRED_LE_FLAG VARCHAR2 (1)
Yes/No flag for defaulting associated Registration Code during Legal Entities creation
REQUIRED_ETB_FLAG VARCHAR2 (1)
Yes/No flag for defaulting associated Registration Code during Establishments creation
EFFECTIVE_FROM DATE

Effective Date From
EFFECTIVE_TO DATE

Effective Date To
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_JURISDICTIONS_B does not reference any database object

XLE.XLE_JURISDICTIONS_B is referenced by following:

XLE
VIEW - XLE_JURISDICTIONS_B#

[top of page]

Table: XLE_JURISDICTIONS_TL

Description: XLE_JURISDICTIONS_TL stores the translations of the prompts for Jurisdictions
Comments
XLE_JURISDICTIONS_TL stores the translations of the prompts for Jurisdictions
Indexes
Index Type Tablespace Column
XLE_JURISDICTIONS_TL_U1 UNIQUE APPS_TS_TX_IDX JURISDICTION_ID
NAME
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
JURISDICTION_ID NUMBER (15) Y Jurisdiction Identifier
NAME VARCHAR2 (240) Y Jurisdiction Name (Translated Column)
LANGUAGE VARCHAR2 (4) Y Language of the translated text in this table
SOURCE_LANG VARCHAR2 (4) Y Source Language
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

XLE.XLE_JURISDICTIONS_TL does not reference any database object

XLE.XLE_JURISDICTIONS_TL is referenced by following:

XLE
VIEW - XLE_JURISDICTIONS_TL#

[top of page]

Table: XLE_JUR_FUNCTIONS

Description: XLE_JUR_FUNCTIONS stores the Legal Functions that the Legal Entity or Establishment might have to fulfill when registering to that Jurisdiction
Comments
XLE_JUR_FUNCTIONS stores the Legal Functions that the Legal Entity or Establishment might have to fulfill when registering to that Jurisdiction
Indexes
Index Type Tablespace Column
XLE_JUR_FUNCTIONS_U1 UNIQUE APPS_TS_TX_IDX JUR_FUNCTION_ID
XLE_JUR_FUNCTIONS_N1 NONUNIQUE APPS_TS_TX_IDX FUNCTION_CODE
Columns
Name Datatype Length Mandatory Comments
JUR_FUNCTION_ID NUMBER (15) Y Jurisdiction Function Identifier
JURISDICTION_ID NUMBER (15) Y Jurisdiction Identifier
FUNCTION_CODE VARCHAR2 (30) Y Function to be fulfilled by Legal Entity
REQUIRED_FLAG VARCHAR2 (1) Y Required Flag for legal process provided by the system
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

XLE.XLE_JUR_FUNCTIONS does not reference any database object

XLE.XLE_JUR_FUNCTIONS is referenced by following:

XLE
VIEW - XLE_JUR_FUNCTIONS#

[top of page]

Table: XLE_LE_BSV_INTERFACE

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
Index Type Tablespace Column
XLE_LE_BSV_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX LE_BSV_ID
XLE_LE_BSV_INTERFACE_U2 UNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
SET_OF_BOOKS_ID
BALANCING_SEGMENT_VALUE
Columns
Name Datatype Length Mandatory Comments
LE_BSV_ID NUMBER (15) Y
LE_SOB_ID NUMBER (15) Y
LEGAL_ENTITY_ID NUMBER (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
BSV_FLEX_VALUE_SET_ID NUMBER (10) Y
BALANCING_SEGMENT_VALUE VARCHAR2 (150) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15)

[top of page]

XLE.XLE_LE_BSV_INTERFACE does not reference any database object

XLE.XLE_LE_BSV_INTERFACE is referenced by following:

XLE
VIEW - XLE_LE_BSV_INTERFACE#

[top of page]

Table: XLE_LE_INTERFACE

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
Index Type Tablespace Column
XLE_LE_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
XLE_LE_INTERFACE_N1 NONUNIQUE APPS_TS_TX_IDX NAME
XLE_LE_INTERFACE_N2 NONUNIQUE APPS_TS_TX_IDX REGISTRATION_NUMBER
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
PARTY_ID NUMBER (15)
NAME VARCHAR2 (240) Y
GEOGRAPHY_ID NUMBER (15) Y
LOCATION_ID NUMBER (15) Y
REGISTRATION_NUMBER VARCHAR2 (30) Y
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
SOURCE VARCHAR2 (30)
REVIEWED_FLAG VARCHAR2 (1) Y
MIGRATE_FLAG VARCHAR2 (1) Y
DO_NOT_MIGRATE_ALLOWED VARCHAR2 (1) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15)

[top of page]

XLE.XLE_LE_INTERFACE does not reference any database object

XLE.XLE_LE_INTERFACE is referenced by following:

XLE
VIEW - XLE_LE_INTERFACE#

[top of page]

Table: XLE_LE_OU_INTERFACE

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
Index Type Tablespace Column
XLE_LE_OU_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX LE_OU_ID
XLE_LE_OU_INTERFACE_U2 UNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
SET_OF_BOOKS_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
LE_OU_ID NUMBER (15) Y
LE_SOB_ID NUMBER (15) Y
LEGAL_ENTITY_ID NUMBER (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
ORGANIZATION_ID NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15)

[top of page]

XLE.XLE_LE_OU_INTERFACE does not reference any database object

XLE.XLE_LE_OU_INTERFACE is referenced by following:

XLE
VIEW - XLE_LE_OU_INTERFACE#

[top of page]

Table: XLE_LE_SOB_INTERFACE

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
Index Type Tablespace Column
XLE_LE_SOB_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX LE_SOB_ID
XLE_LE_SOB_INTERFACE_U2 UNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
SET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
LE_SOB_ID NUMBER (15) Y
LEGAL_ENTITY_ID NUMBER (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15)

[top of page]

XLE.XLE_LE_SOB_INTERFACE does not reference any database object

XLE.XLE_LE_SOB_INTERFACE is referenced by following:

XLE
VIEW - XLE_LE_SOB_INTERFACE#

[top of page]

Table: XLE_REGISTRATIONS

Description: XLE_REGISTRATIONS stores the detailed registration information of Legal Entities and Establishments, such as registration number, place of registration, and legal address
Comments
XLE_REGISTRATIONS stores the detailed registration information of Legal Entities and Establishments, such as registration number, place of registration, and legal address
Indexes
Index Type Tablespace Column
XLE_REGISTRATIONS_U1 UNIQUE APPS_TS_TX_IDX REGISTRATION_ID
XLE_REGISTRATIONS_N1 NONUNIQUE APPS_TS_TX_IDX REGISTRATION_NUMBER
XLE_REGISTRATIONS_N2 NONUNIQUE APPS_TS_TX_IDX SOURCE_TABLE
SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
REGISTRATION_ID NUMBER (15) Y Legal Registration Identifier
REGISTERED_NAME VARCHAR2 (240) Y Registered Name
ALTERNATE_REGISTERED_NAME VARCHAR2 (240)
Alternate Registered Name
SOURCE_TABLE VARCHAR2 (30) Y Source Table Name for the information (XLE_ENTITY_PROFILES XLE_ETB_PROFILES)
SOURCE_ID NUMBER (15)
Identifier for the Registered Legal Entity or Establishment
JURISDICTION_ID NUMBER (15) Y Jurisdiction Identifier
REGISTRATION_NUMBER VARCHAR2 (30) Y Registration Number
PLACE_OF_REGISTRATION VARCHAR2 (30)
Place Of Registration
EFFECTIVE_FROM DATE

Effective Date From
EFFECTIVE_TO DATE

Effective Date To
LOCATION_ID NUMBER (15)
Location ID of the Registered Address
ISSUING_AUTHORITY_ID NUMBER (15)
Issuing Legal Authority Identifier
ISSUING_AUTHORITY_SITE_ID NUMBER (15)
Issuing Legal Authority Site Identifier
IDENTIFYING_FLAG VARCHAR2 (1)
Yes/No flag for Identifying Registration
REG_INFORMATION_CONTEXT VARCHAR2 (30)
Developer Flexfield - Context
REG_INFORMATION1 VARCHAR2 (150)
Developer Flexfield Segment 1
REG_INFORMATION2 VARCHAR2 (150)
Developer Flexfield Segment 2
REG_INFORMATION3 VARCHAR2 (150)
Developer Flexfield Segment 3
REG_INFORMATION4 VARCHAR2 (150)
Developer Flexfield Segment 4
REG_INFORMATION5 VARCHAR2 (150)
Developer Flexfield Segment 5
REG_INFORMATION6 VARCHAR2 (150)
Developer Flexfield Segment 6
REG_INFORMATION7 VARCHAR2 (150)
Developer Flexfield Segment 7
REG_INFORMATION8 VARCHAR2 (150)
Developer Flexfield Segment 8
REG_INFORMATION9 VARCHAR2 (150)
Developer Flexfield Segment 9
REG_INFORMATION10 VARCHAR2 (150)
Developer Flexfield Segment 10
REG_INFORMATION11 VARCHAR2 (150)
Developer Flexfield Segment 11
REG_INFORMATION12 VARCHAR2 (150)
Developer Flexfield Segment 12
REG_INFORMATION13 VARCHAR2 (150)
Developer Flexfield Segment 13
REG_INFORMATION14 VARCHAR2 (150)
Developer Flexfield Segment 14
REG_INFORMATION15 VARCHAR2 (150)
Developer Flexfield Segment 15
REG_INFORMATION16 VARCHAR2 (150)
Developer Flexfield Segment 16
REG_INFORMATION17 VARCHAR2 (150)
Developer Flexfield Segment 17
REG_INFORMATION18 VARCHAR2 (150)
Developer Flexfield Segment 18
REG_INFORMATION19 VARCHAR2 (150)
Developer Flexfield Segment 19
REG_INFORMATION20 VARCHAR2 (150)
Developer Flexfield Segment 20
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20

[top of page]

XLE.XLE_REGISTRATIONS does not reference any database object

XLE.XLE_REGISTRATIONS is referenced by following:

XLE
VIEW - XLE_REGISTRATIONS#

[top of page]

Table: XLE_REG_FUNCTIONS

Description: XLE_REG_FUNCTIONS stores the legal functions that a Legal Entity or an Establishment should perform for a given registration
Comments
XLE_REG_FUNCTIONS stores the legal functions that a Legal Entity or an Establishment should perform for a given registration
Indexes
Index Type Tablespace Column
XLE_REG_FUNCTIONS_U1 UNIQUE APPS_TS_TX_IDX REG_FUNCTION_ID
XLE_REG_FUNCTIONS_N1 NONUNIQUE APPS_TS_TX_IDX FUNCTION_CODE
Columns
Name Datatype Length Mandatory Comments
REG_FUNCTION_ID NUMBER (15) Y Legal Registration Function Identifier
REGISTRATION_ID NUMBER (15) Y Registration Internal Identifier
FUNCTION_CODE VARCHAR2 (30) Y Function the Legal Entity/Etb will fulfill (Payment, Reporting, etc.)
AUTHORITY_ID NUMBER (15)
Party ID of the Legal Authority
AUTHORITY_SITE_ID NUMBER (15)
Party Site ID of the Legal Authority
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20

[top of page]

XLE.XLE_REG_FUNCTIONS does not reference any database object

XLE.XLE_REG_FUNCTIONS is referenced by following:

XLE
VIEW - XLE_REG_FUNCTIONS#

[top of page]

Table: XLE_SOB_INTERFACE

Description: This table is no longer used.
Comments
This table is no longer used.
Indexes
Index Type Tablespace Column
XLE_SOB_INTERFACE_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
XLE_SOB_INTERFACE_U2 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_NAME
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
SET_OF_BOOKS_NAME VARCHAR2 (30) Y
CHART_OF_ACCOUNTS_ID NUMBER (15) Y
BSV_FLEX_VALUE_SET_ID NUMBER (10) Y
OU_ASSOC_FLAG VARCHAR2 (1) Y
LEGAL_ENTITY_ID NUMBER (15)
ACCOUNTING_ENV_TYPE VARCHAR2 (30) Y
ASSIGNMENT_TYPE VARCHAR2 (30)
MAPPING_STATUS_FLAG VARCHAR2 (1)
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15)
BALANCING_SEGMENT_COLUMN_NAME VARCHAR2 (30)

[top of page]

XLE.XLE_SOB_INTERFACE does not reference any database object

XLE.XLE_SOB_INTERFACE is referenced by following:

XLE
VIEW - XLE_SOB_INTERFACE#

[top of page]

Table: XLE_UNQ_PROFILES

Description: XLE_UNQ_PROFILES stores information about an Unqualified Legal Construct
Comments
XLE_UNQ_PROFILES stores information about an Unqualified Legal Construct
Indexes
Index Type Tablespace Column
UNQ_PROFILES_U1 UNIQUE APPS_TS_TX_IDX UNQUALIFIED_ID
UNQ_PROFILES_N1 NONUNIQUE APPS_TS_TX_IDX NAME
UNQ_PROFILES_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
UNQUALIFIED_ID NUMBER (15) Y Unqualified Legal Construct Identifier
PARTY_ID NUMBER (15) Y Party ID for the Unqualified Legal Construct. Foreign key to the HZ_PARTIES table
NAME VARCHAR2 (240) Y Unqualified Legal Construct Name
GEOGRAPHY_ID NUMBER (15) Y Geography Identifier. Foreign key to HZ_GEOGRAPHIES table
LOCATION_ID NUMBER (15)
Location Identifier. Foreign key to HR_LOCATIONS table
REGISTRATION_NUMBER VARCHAR2 (30)
Registration Number
UNQ_INFORMATION_CONTEXT VARCHAR2 (30)
Developer Flexfield - Context
UNQ_INFORMATION1 VARCHAR2 (150)
Developer Flexfield Segment 1
UNQ_INFORMATION2 VARCHAR2 (150)
Developer Flexfield Segment 2
UNQ_INFORMATION3 VARCHAR2 (150)
Developer Flexfield Segment 3
UNQ_INFORMATION4 VARCHAR2 (150)
Developer Flexfield Segment 4
UNQ_INFORMATION5 VARCHAR2 (150)
Developer Flexfield Segment 5
UNQ_INFORMATION6 VARCHAR2 (150)
Developer Flexfield Segment 6
UNQ_INFORMATION7 VARCHAR2 (150)
Developer Flexfield Segment 7
UNQ_INFORMATION8 VARCHAR2 (150)
Developer Flexfield Segment 8
UNQ_INFORMATION9 VARCHAR2 (150)
Developer Flexfield Segment 9
UNQ_INFORMATION10 VARCHAR2 (150)
Developer Flexfield Segment 10
UNQ_INFORMATION11 VARCHAR2 (150)
Developer Flexfield Segment 11
UNQ_INFORMATION12 VARCHAR2 (150)
Developer Flexfield Segment 12
UNQ_INFORMATION13 VARCHAR2 (150)
Developer Flexfield Segment 13
UNQ_INFORMATION14 VARCHAR2 (150)
Developer Flexfield Segment 14
UNQ_INFORMATION15 VARCHAR2 (150)
Developer Flexfield Segment 15
UNQ_INFORMATION16 VARCHAR2 (150)
Developer Flexfield Segment 16
UNQ_INFORMATION17 VARCHAR2 (150)
Developer Flexfield Segment 17
UNQ_INFORMATION18 VARCHAR2 (150)
Developer Flexfield Segment 18
UNQ_INFORMATION19 VARCHAR2 (150)
Developer Flexfield Segment 19
UNQ_INFORMATION20 VARCHAR2 (150)
Developer Flexfield Segment 20
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20
EFFECTIVE_FROM DATE

Effective From Date
EFFECTIVE_TO DATE

Effective To Date
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

XLE.XLE_UNQ_PROFILES does not reference any database object

XLE.XLE_UNQ_PROFILES is referenced by following:

XLE
VIEW - XLE_UNQ_PROFILES#

[top of page]

View: XLE_ASSOCIATIONS_V

Comments
Columns
Name Datatype Length Mandatory Comments
CONTEXT VARCHAR2 (80)
ENTITY_TYPE VARCHAR2 (80)
LEGAL_CONSTRUCT VARCHAR2 (80)
ASSOCIATION_TYPE_ID NUMBER (15)
ASSOCIATION_ID NUMBER (15)
ENTITY_ID NUMBER (15)
ENTITY_NAME VARCHAR2 (240)
LEGAL_CONSTRUCT_ID NUMBER (15)
LEGAL_PARTY_ID NUMBER (15)
LEGAL_CONSTRUCT_NAME VARCHAR2 (240)
LEGAL_PARENT_ID NUMBER (15)
EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

[top of page]

APPS.XLE_ASSOCIATIONS_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_SECURITY
SYNONYM - XLE_ASSOCIATIONS
SYNONYM - XLE_ASSOCIATION_TYPES
SYNONYM - XLE_ASSOC_OBJECT_TYPES
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_ETB_PROFILES
- ORG_ORGANIZATION_DEFINITIONS
APPS.XLE_ASSOCIATIONS_V is referenced by following:

APPS
PACKAGE BODY - INV_INVINPSR_XMLP_PKG
PACKAGE BODY - INV_INVPOPSR_XMLP_PKG

[top of page]

View: XLE_BSV_ASSOCIATIONS

Comments
XLE_BSV_ASSOCIATIONS view retrieves the balancing segment value associations.
Columns
Name Datatype Length Mandatory Comments
CONTEXT VARCHAR2 (80) Y Context
ENTITY_TYPE VARCHAR2 (80) Y Entity Type
LEGAL_CONSTRUCT VARCHAR2 (80) Y Legal Construct
ASSOCIATION_TYPE_ID NUMBER (15) Y Association Type Identifier
ASSOCIATION_ID NUMBER (15) Y Association Identifier
ENTITY_ID NUMBER (15) Y Entity Identifier
ENTITY_NAME VARCHAR2 (150) Y Entity Name
LEGAL_CONSTRUCT_ID NUMBER (15) Y Legal Construct Identifier
LEGAL_PARTY_ID NUMBER (15) Y Legal Party Identifier
LEGAL_CONSTRUCT_NAME VARCHAR2 (240) Y Legal Construct Name
LEGAL_PARENT_ID NUMBER (15)
Legal Parent Identifier
EFFECTIVE_FROM DATE
Y Effective From
EFFECTIVE_TO DATE

Effective To

[top of page]

APPS.XLE_BSV_ASSOCIATIONS references the following:

APPS
SYNONYM - FND_FLEX_VALUES
SYNONYM - XLE_ASSOCIATIONS
SYNONYM - XLE_ASSOCIATION_TYPES
SYNONYM - XLE_ASSOC_OBJECT_TYPES
SYNONYM - XLE_ETB_PROFILES
APPS.XLE_BSV_ASSOCIATIONS is referenced by following:

APPS
PACKAGE BODY - JL_BR_AP_VALIDATE_COLLECTION
PACKAGE BODY - JL_BR_AR_LOG_VALIDATION
PACKAGE BODY - JL_BR_SPED_DATA_EXTRACT_PKG
PACKAGE BODY - JL_BR_WORKDAY_CALENDAR
PACKAGE BODY - JL_JLBRRCAD_XMLP_PKG
PACKAGE BODY - JL_ZZ_AP_LIBRARY_1_PKG

[top of page]

View: XLE_ESTABLISHMENT_V

Comments
XLE_ESTABLISHMENT_V view provides the user with information related to Establishments related to Legal Entities. The view encompasses both First Party and Third Party LEs. End Dates are not discriminated and hence, user has the access to Inactive Legal Entities and Establishments as well.
Columns
Name Datatype Length Mandatory Comments
ESTABLISHMENT_ID NUMBER (15)
Establishment Identifier
ESTABLISHMENT_NAME VARCHAR2 (240)
Establishment Name
PARTY_ID NUMBER (15)
Party Identifier for the Establishment. Foreign key to the HZ_PARTIES table
LEGAL_ENTITY_ID NUMBER (15)
Identifier of the Legal Entity that owns the Establishment. Foreign key to the XLE_ENTITY_PROFILES table
MAIN_ESTABLISHMENT_FLAG VARCHAR2 (1)
Main Establishment Flag
ACTIVITY_CODE VARCHAR2 (150)
Activity Code of Establishment
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub-Activity Code of Establishment
TYPE_OF_COMPANY VARCHAR2 (50)
Type of Company of Establishment
ETB_EFFECTIVE_FROM DATE

Effective From of the Establishment
ETB_EFFECTIVE_TO DATE

Effective To of the Establishment
REGISTRATION_NUMBER VARCHAR2 (30)
Registration Number of the Identifying Registration associated to the Establishment
LEGISLATIVE_CAT_CODE VARCHAR2 (30)
Legislative Category of the Registration
EFFECTIVE_FROM DATE

Effective from of the Registration
EFFECTIVE_TO DATE

Effective To of the Registration
LOCATION_ID NUMBER

Establishment Address: Location ID
ADDRESS_STYLE VARCHAR2 (7)
Establishment Address: Address Style
ADDRESS_LINE_1 VARCHAR2 (240)
Establishment Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Establishment Address: Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Establishment Address: Address Line 3
TOWN_OR_CITY VARCHAR2 (30)
Establishment Address: Town Or City
REGION_1 VARCHAR2 (120)
Establishment Address: Region 1
REGION_2 VARCHAR2 (120)
Establishment Address: Region 2
REGION_3 VARCHAR2 (120)
Establishment Address: Region 3
POSTAL_CODE VARCHAR2 (30)
Establishment Address: Postal Code
COUNTRY VARCHAR2 (60)
Establishment Address: Country

[top of page]

APPS.XLE_ESTABLISHMENT_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - XLE_ETB_PROFILES
VIEW - XLE_JURISDICTIONS_VL
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_ESTABLISHMENT_V is referenced by following:

APPS
PACKAGE BODY - JL_BR_AP_VALIDATE_COLLECTION
PACKAGE BODY - JL_BR_AR_LOG_VALIDATION
PACKAGE BODY - JL_BR_WORKDAY_CALENDAR
PACKAGE BODY - JL_JLBRRCAD_XMLP_PKG
PACKAGE BODY - JL_ZZ_AP_LIBRARY_1_PKG

[top of page]

View: XLE_FIRSTPARTY_INFORMATION_V

Comments
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
LE_INFORMATION_CONTEXT VARCHAR2 (30)
NAME VARCHAR2 (240) Y
PARTY_ID NUMBER (15) Y
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
ACTIVITY_CODE VARCHAR2 (150)
SUB_ACTIVITY_CODE VARCHAR2 (150)
TYPE_OF_COMPANY VARCHAR2 (50)
ACTIVITY_CATEGORY VARCHAR2 (60)
ACTIVITY_DESCRIPTION VARCHAR2 (80)
LE_EFFECTIVE_FROM DATE

LE_EFFECTIVE_TO DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
GEOGRAPHY_ID NUMBER (15) Y
REGISTRATION_NUMBER VARCHAR2 (30) Y
LEGISLATIVE_CAT_CODE VARCHAR2 (30) Y
EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

LOCATION_ID NUMBER (15)
ADDRESS_STYLE VARCHAR2 (7)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (30)
REGION_1 VARCHAR2 (120)
REGION_2 VARCHAR2 (120)
REGION_3 VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (30)
COUNTRY VARCHAR2 (60)

[top of page]

APPS.XLE_FIRSTPARTY_INFORMATION_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - FND_DESCR_FLEX_COLUMN_USAGES
SYNONYM - FND_FLEX_VALUE_SETS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_JURISDICTIONS_B
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_FIRSTPARTY_INFORMATION_V is referenced by following:

APPS
VIEW - CE_FC_AMTS_DISC_V
VIEW - CE_XLA_EXT_HEADERS_V
VIEW - CSTBV_LE_COST_TYPES
VIEW - CSTFV_COST_GROUPS
VIEW - CSTFV_LE_COST_TYPES
VIEW - CSTFV_PAC_PERIODS
VIEW - CST_LE_COST_TYPES_V
VIEW - CST_MGD_LIFO_ITEM_COSTS_V
VIEW - CST_MGD_LIFO_PERIODS_V
VIEW - CST_MTL_RCV_TXN_V
VIEW - CST_PAC_LEGAL_ENTITIES_V
VIEW - CST_PAC_WIP_TXN_V
VIEW - FV_SYSTEM_PARAMETERS_V
VIEW - IBY_EXT_FD_PAYER_1_0_V
VIEW - IBY_PP_FIRST_PARTY_V
VIEW - MTL_FISCAL_CAT_ACCOUNTS_V
VIEW - MTL_LE_ECONOMIC_ZONES_V
VIEW - MTL_STAT_TYPE_USAGES_V
VIEW - PA_VRM_SOURCE_DOCUMENT
VIEW - PA_VRM_SOURCE_DOC_SUB_LINES

[top of page]

View: XLE_FP_ESTABLISHMENT_V

Comments
XLE_FP_ESTABLISHMENT_V view provides the users with access to all First Party Legal Entity Establishemnt Information. This includes the related Identifying Registration. End Dates are not discriminated and hence, user has the access to Inactive Establishments as well.
Columns
Name Datatype Length Mandatory Comments
ESTABLISHMENT_ID NUMBER (15) Y Establishment Identifier
ESTABLISHMENT_NAME VARCHAR2 (240) Y Establishment Name
PARTY_ID NUMBER (15) Y Party Identifier of the Establishment
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier to which the Establishment is associated
MAIN_ESTABLISHMENT_FLAG VARCHAR2 (1)
Indicates whether an Establishment is main Establishment or Not. Y for Main Establishments and N for Other Establishments
ACTIVITY_CODE VARCHAR2 (150)
Activity Code of Establishment
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub-Activity Code of Establishment
REGISTRATION_NUMBER VARCHAR2 (30) Y Registration Number of the Identifying Registration
IDENTIFYING_FLAG VARCHAR2 (1)
Identifying Flag
LEGISLATIVE_CAT_CODE VARCHAR2 (30) Y Legislative Category Code of Identifying Registration
EFFECTIVE_FROM DATE

Start Date of Establishment Registration (Identifying)
EFFECTIVE_TO DATE

End Date of Establishment Registration (Identifying)
ADDRESS_LINE_1 VARCHAR2 (240)
Registration Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Registration Address: Address Line 2
TOWN_OR_CITY VARCHAR2 (30)
Registration Address: Town Or City
REGION_1 VARCHAR2 (120)
Registration Address: Region 1
POSTAL_CODE VARCHAR2 (30)
Registration Address: Postal Code
COUNTRY VARCHAR2 (60)
Registration Address: Country

[top of page]

APPS.XLE_FP_ESTABLISHMENT_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_ETB_PROFILES
VIEW - XLE_JURISDICTIONS_VL
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_FP_ESTABLISHMENT_V is referenced by following:

APPS
VIEW - ZX_TRL_ESL_VAT_NO_V
PACKAGE BODY - ZX_TRN_VALIDATION_PKG

[top of page]

View: XLE_FP_LEDGER_V

Comments
XLE_FP_LEDGER_V view can be used to access the Business Relationship between Ledger and First Party Legal Entity. This view can be used to derive the Legal Information based on Ledger.
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Y Ledger Identifier
LEDGER_NAME VARCHAR2 (30) Y Ledger Name
LEDGER_SHORT_NAME VARCHAR2 (20) Y Ledger Short Name
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Y Legal Entity Name
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
Legal Entity Identifier
LEGAL_ENTITY_COUNTRY VARCHAR2 (2)
Legal Entity Country
LE_EFFECTIVE_FROM DATE

Le Effective From
LE_EFFECTIVE_TO DATE

Le Effective To
LEDGER_CATEGORY_CODE VARCHAR2 (30) Y Ledger Category Code
SEGMENT_VALUE VARCHAR2 (25) Y Balancing Segment Value
START_DATE DATE

Start Date of Balancing Segment Value
END_DATE DATE

End Date of Balancing Segment Value

[top of page]

APPS.XLE_FP_LEDGER_V references the following:

APPS
SYNONYM - GL_LEDGERS
SYNONYM - GL_LEDGER_CONFIGURATIONS
SYNONYM - GL_LEDGER_NORM_SEG_VALS
SYNONYM - HZ_GEOGRAPHIES
SYNONYM - XLE_ENTITY_PROFILES

APPS.XLE_FP_LEDGER_V is not referenced by any database object

[top of page]

View: XLE_FP_OU_LEDGER_V

Comments
XLE_FP_OU_LEDGER_V view can be used to access the Business Relationship between Operating Unit, Ledger and First Party Legal Entity. This view can be used to derive the Legal Information based on Operating Unit / Ledger.
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_ID NUMBER (15) Y Operating Unit Identifier
LEDGER_ID NUMBER (15) Y Ledger Identifier
LEDGER_NAME VARCHAR2 (30) Y Ledger Name
LEDGER_SHORT_NAME VARCHAR2 (20) Y Ledger Short Name
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Y Legal Entity Name
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
Legal Entity Identifier
ACTIVITY_CODE VARCHAR2 (150)
Activity Code of Legal Entity
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub-Activity Code of Legal Entity
TYPE_OF_COMPANY VARCHAR2 (50)
Type Of Company of Legal Entity
LE_EFFECTIVE_FROM DATE

Start Date of of Legal Entity
LE_EFFECTIVE_TO DATE

End Date of of Legal Entity
REGISTRATION_NUMBER VARCHAR2 (30) Y Registration Number of the Identifying Registration associated to the Legal Entity
ADDRESS_LINE_1 VARCHAR2 (240)
Registration Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Registration Address: Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Registration Address: Address Line 3
REGION_1 VARCHAR2 (120)
Registration Address: Region 1
REGION_2 VARCHAR2 (120)
Registration Address: Region 2
REGION_3 VARCHAR2 (120)
Registration Address: Region 3
TOWN_OR_CITY VARCHAR2 (30)
Registration Address: Town Or City
POSTAL_CODE VARCHAR2 (30)
Registration Address: Postal Code
COUNTRY VARCHAR2 (60)
Registration Address: Country

[top of page]

APPS.XLE_FP_OU_LEDGER_V references the following:

APPS
SYNONYM - GL_LEDGERS
SYNONYM - GL_LEDGER_CONFIGURATIONS
SYNONYM - GL_LEDGER_CONFIG_DETAILS
SYNONYM - GL_LEDGER_RELATIONSHIPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_FP_OU_LEDGER_V is referenced by following:

APPS
PACKAGE BODY - CEP_STANDARD
PACKAGE BODY - CE_AUTO_BANK_MATCH
PACKAGE BODY - INL_LANDEDCOST_PVT
PACKAGE BODY - JAI_FBT_PAYMENT_P
PACKAGE BODY - JAI_FBT_SETTLEMENT_P
PACKAGE BODY - XLA_JOURNAL_ENTRIES_PKG
PACKAGE BODY - XLE_UTILITIES_GRP

[top of page]

View: XLE_FP_REGISTRATIONS_V

Comments
XLE_FP_ESTABLISHMENT_V view provides the users with access to all First Party Legal Entity Registration Information. This includes the related Identifying Jurisdiction. End Dates are not discriminated and hence, user has the access to Inactive Establishments as well.
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Y Legal Entity Name
PARTY_ID NUMBER (15) Y Legal Entity Party Identifier
REGISTRATION_NUMBER VARCHAR2 (30) Y Registration Number
IDENTIFYING VARCHAR2 (1)
Identifying Flag of the Jurisdiction
LEGISLATIVE_CATEGORY VARCHAR2 (30) Y Legislative Category
LEGALAUTH_NAME VARCHAR2 (360)
Legal Authority Name
LEGALAUTH_ADDRESS VARCHAR2 (725)
Legal Authority Address
EFFECTIVE_FROM DATE

Start Date of Legal Entity Registration
EFFECTIVE_TO DATE

End Date of Legal Entity Registration
ADDRESS_LINE_1 VARCHAR2 (240)
Registration Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Registration Address: Address Line 2
TOWN_OR_CITY VARCHAR2 (30)
Registration Address: Town Or City
REGION_1 VARCHAR2 (120)
Registration Address: Region 1
POSTAL_CODE VARCHAR2 (30)
Registration Address: Postal Code
COUNTRY VARCHAR2 (60)
Registration Address: Country

[top of page]

APPS.XLE_FP_REGISTRATIONS_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - XLE_ENTITY_PROFILES
VIEW - XLE_JURISDICTIONS_VL
SYNONYM - XLE_REGISTRATIONS

APPS.XLE_FP_REGISTRATIONS_V is not referenced by any database object

[top of page]

View: XLE_HISTORY_COLUMNS_VL

Comments
XLE_HISTORY_COLUMNS_VL view retreives the translated prompts for tracked legal entity and establishment attributes
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
HISTORY_COLUMN_ID NUMBER (15) Y Table identifier
SOURCE_TABLE VARCHAR2 (30) Y Name of the table containing the tracked column
SOURCE_COLUMN_NAME VARCHAR2 (30) Y Name of the tracked column
GEOGRAPHY_ID NUMBER (15)
Geography Identifier,For tracking country dependent columns
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
SOURCE_COLUMN_PROMPT VARCHAR2 (240) Y Name of the prompt for the tracked column (Translated column)

[top of page]

APPS.XLE_HISTORY_COLUMNS_VL references the following:

APPS
SYNONYM - XLE_HISTORY_COLUMNS_B
SYNONYM - XLE_HISTORY_COLUMNS_TL

APPS.XLE_HISTORY_COLUMNS_VL is not referenced by any database object

[top of page]

View: XLE_JURISDICTIONS_VL

Comments
XLE_JURISDICTIONS_VL view retreives the translated jurisdictions.
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
JURISDICTION_ID NUMBER (15) Y Jurisdiction Identifier
LEGISLATIVE_CAT_CODE VARCHAR2 (30) Y Legislative Category Code
GEOGRAPHY_ID NUMBER (15) Y Geography Identifier
REGISTRATION_CODE_LE VARCHAR2 (30)
Legal Entity Registration Code
REGISTRATION_CODE_ETB VARCHAR2 (30)
Establishment Registration Code
IDENTIFYING_FLAG VARCHAR2 (1)
Identifying Flag
REQUIRED_LE_FLAG VARCHAR2 (1)
Required Legal Entity Flag
REQUIRED_ETB_FLAG VARCHAR2 (1)
Required Establishment Flag
EFFECTIVE_FROM DATE

Effective Date From
EFFECTIVE_TO DATE

Effective Date To
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment 15
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment 16
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment 17
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment 18
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment 19
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment 20
NAME VARCHAR2 (240) Y Jurisdiction Name

[top of page]

APPS.XLE_JURISDICTIONS_VL references the following:

APPS
SYNONYM - XLE_JURISDICTIONS_B
SYNONYM - XLE_JURISDICTIONS_TL
APPS.XLE_JURISDICTIONS_VL is referenced by following:

APPS
VIEW - ARBPA_CUSTOMER_TRX_HEADER
PACKAGE BODY - JL_BR_SPED_DATA_EXTRACT_PKG
PACKAGE BODY - RRS_IMPORT_INTERFACE_PKG
PACKAGE - XLE_BUSINESSINFO_GRP
VIEW - XLE_ESTABLISHMENT_V
VIEW - XLE_FP_ESTABLISHMENT_V
VIEW - XLE_FP_REGISTRATIONS_V
VIEW - XLE_REGISTRATIONS_V
PACKAGE - XLE_UTILITIES_GRP
PACKAGE BODY - XLE_UTILITIES_GRP

[top of page]

View: XLE_LEGALAUTH_V

Comments
XLE_LEGALAUTH_V view provides the list of Legal Authorities.
Columns
Name Datatype Length Mandatory Comments
LEGALAUTH_ID NUMBER (15) Y Legal Authority Identifier
AUTHORITY_NAME VARCHAR2 (360) Y Legal Authority Name
ADDRESS_STYLE VARCHAR2 (30)
Address Style
ADDRESS1 VARCHAR2 (240) Y Address1
ADDRESS2 VARCHAR2 (240)
Address2
ADDRESS3 VARCHAR2 (240)
Address3
ADDRESS4 VARCHAR2 (240)
Address4
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code
COUNTRY VARCHAR2 (60) Y Country
PARTY_ID NUMBER (15) Y Party id of the Legal Authority
PARTY_SITE_ID NUMBER (15) Y Party Site id of the Legal Authority
LEGISLATIVE_CATEGORY_CODE VARCHAR2 (30)
Legislative Category of the Legal Authority. Ex: - Income Tax

[top of page]

APPS.XLE_LEGALAUTH_V references the following:

APPS
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
APPS.XLE_LEGALAUTH_V is referenced by following:

APPS
VIEW - ARBPA_CUSTOMER_TRX_HEADER
PACKAGE BODY - JG_ZZ_PTCE_DT_PKG
PACKAGE - JG_ZZ_RTCE_DT_PKG
PACKAGE BODY - JG_ZZ_RTCE_DT_PKG
PACKAGE BODY - JG_ZZ_SUMMARY_ALL_PKG
PACKAGE BODY - ZX_EXTRACT_PKG

[top of page]

View: XLE_LEGAL_CONTACTS_V

Comments
XLE_LEGAL_CONTACTS_V view provides the users with access to information related to Legal Contacts
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER (15)
Owning Legal Entitys Contact ID orOwning Establishment Contact ID
ENTITY_TYPE VARCHAR2 (13)
LEGAL_ENTITY OR ESTABLISHMENT
ENTITY_PARTY_ID NUMBER (15)
Party ID of the Contacts Owning Legal Entity or Establishment
CONTACT_PARTY_ID NUMBER (15)
Party ID of the Legal Contact
CONTACT_NAME VARCHAR2 (360)
Name of the Legal Contact
CONTACT_LEGAL_ID VARCHAR2 (20)
Legal Representative ID of the Contact
ROLE CHAR (13)
Role of the Contact
TITLE VARCHAR2 (30)
Title of the Contact
CONTACT_NUMBER VARCHAR2 (30)
Contact Number
JOB_TITLE VARCHAR2 (4000)
Job title of the contact

[top of page]

APPS.XLE_LEGAL_CONTACTS_V references the following:

APPS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PERSON_PROFILES
SYNONYM - HZ_RELATIONSHIPS
PACKAGE - XLE_CONTACT_GRP
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_ETB_PROFILES
APPS.XLE_LEGAL_CONTACTS_V is referenced by following:

APPS
PACKAGE BODY - ZX_EXTRACT_PKG

[top of page]

View: XLE_LE_FROM_REGISTRATIONS

Comments
XLE_LE_FROM_REGISTRATIONS view provides the users with access to all Legal Entity Registration Information
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_ID NUMBER (15)
Operating Unit Identifier
LEDGER_ID NUMBER (15)
Ledger Identifier
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
REGISTRATION_ID NUMBER (15)
Registration Identifier
LEGISLATIVE_CATEGORY_CODE VARCHAR2 (30)
Legislative Category Code
LEGISLATIVE_CATEGORY_MEANING VARCHAR2 (80)
Legislative Category of the Registration
REGISTRATION_NUMBER VARCHAR2 (50)
Registration Number of the Registration
COUNTRY_OF_REGISTRATION VARCHAR2 (30)
Country Of Registration
TRANSACTION_TAX_REGN_CONTEXT VARCHAR2 (61)
Transaction Tax Registration Context
EFFECTIVE_FROM DATE

Registration Start Date
EFFECTIVE_TO DATE

Registration End Date

[top of page]

APPS.XLE_LE_FROM_REGISTRATIONS references the following:

APPS
SYNONYM - GL_LEDGERS
SYNONYM - GL_LEDGER_CONFIGURATIONS
SYNONYM - GL_LEDGER_CONFIG_DETAILS
SYNONYM - GL_LEDGER_RELATIONSHIPS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - 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 - ZX_REGISTRATIONS
- AR_LOOKUPS

APPS.XLE_LE_FROM_REGISTRATIONS is not referenced by any database object

[top of page]

View: XLE_LE_FROM_REGISTRATIONS_V

Comments
XLE_LE_FROM_REGISTRATIONS_V view provides the users with access to all Legal Entity Registration Information
Columns
Name Datatype Length Mandatory Comments
REGISTRATION_ID NUMBER (15)
Registration Identifier
LEGISLATIVE_CATEGORY_CODE VARCHAR2 (30)
Legislative Category Code
LEGISLATIVE_CATEGORY_MEANING VARCHAR2 (80)
Legislative Category of the Registration
REGISTRATION_NUMBER VARCHAR2 (50)
Registration Number of the Registration
COUNTRY_OF_REGISTRATION VARCHAR2 (30)
Country Of Registration
TRANSACTION_TAX_REGN_CONTEXT VARCHAR2 (61)
Transaction Tax Registration Context
EFFECTIVE_FROM DATE

Registration Start Date
EFFECTIVE_TO DATE

Registration End Date
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name

[top of page]

APPS.XLE_LE_FROM_REGISTRATIONS_V references the following:

APPS
SYNONYM - 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 - ZX_REGISTRATIONS
- AR_LOOKUPS

APPS.XLE_LE_FROM_REGISTRATIONS_V is not referenced by any database object

[top of page]

View: XLE_LE_OU_LEDGER_V

Comments
XLE_LE_OU_LEDGER_V view can be used to access the Business Relationship between Operating Unit, Ledger and Legal Entity. This view can be used to derive the Legal Information based on Operating Unit / Ledger.
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_ID NUMBER (15) Y Operating Unit Identifier
LEDGER_ID NUMBER (15) Y Ledger Identifier
LEDGER_NAME VARCHAR2 (30) Y Ledger Name
LEDGER_SHORT_NAME VARCHAR2 (20) Y Ledger Short Name
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Internal Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Y Legal Entity Name
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
Tax Registration Number orUnique LE identifier
ACTIVITY_CODE VARCHAR2 (150)
Activity Code of the Legal Entity
SUB_ACTIVITY_CODE VARCHAR2 (150)
Sub-Activity Code of the Legal Entity
TYPE_OF_COMPANY VARCHAR2 (50)
Type Of Company of the Legal Entity
LE_EFFECTIVE_FROM DATE

Start Date of Legal Entity Registration (Identifying)
LE_EFFECTIVE_TO DATE

End Date of Legal Entity Registration (Identifying)
REGISTRATION_NUMBER VARCHAR2 (30) Y Registration Number of the Identifying Registration of the Legal Entity
ADDRESS_LINE_1 VARCHAR2 (240)
Legal Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Legal Address: Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Legal Address: Address Line 3
REGION_1 VARCHAR2 (120)
Legal Address: Region 1
REGION_2 VARCHAR2 (120)
Legal Address: Region 2
REGION_3 VARCHAR2 (120)
Legal Address: Region 3
TOWN_OR_CITY VARCHAR2 (30)
Legal Address: Town Or City
POSTAL_CODE VARCHAR2 (30)
Legal Address: Postal Code
COUNTRY VARCHAR2 (60)
Legal Address: Country

[top of page]

APPS.XLE_LE_OU_LEDGER_V references the following:

APPS
SYNONYM - GL_LEDGERS
SYNONYM - GL_LEDGER_CONFIGURATIONS
SYNONYM - GL_LEDGER_CONFIG_DETAILS
SYNONYM - GL_LEDGER_RELATIONSHIPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_LE_OU_LEDGER_V is referenced by following:

APPS
PACKAGE BODY - ARP_LEGAL_ENTITY_UTIL
VIEW - AR_INTEREST_HEADERS_V
PACKAGE BODY - AR_INVOICE_UTILS
VIEW - IGI_RPI_STANDING_CHARGES_V
PACKAGE BODY - OKL_OPEN_INTERFACE_PVT
PACKAGE BODY - OKL_PRB_UPGRADE_PVT
- AR_INTEREST_HEADERS_V
- IGI_RPI_STANDING_CHARGES_V

[top of page]

View: XLE_LOOKUPS

Comments
XLE_LOOKUPS view provides information about the lookup codes and values defined for Oracle Legal Entity Configurator
Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y Lookup Type
LOOKUP_CODE VARCHAR2 (30) Y Lookup Code
MEANING VARCHAR2 (80) Y Lookup Code Meaning
DESCRIPTION VARCHAR2 (240)
Lookup Code Description
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active

[top of page]

APPS.XLE_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.XLE_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - JL_BR_SPED_DATA_EXTRACT_PKG
PACKAGE BODY - RRS_IMPORT_INTERFACE_PKG
PACKAGE BODY - XLE_CONTACT_GRP
PACKAGE - XLE_UTILITIES_GRP
PACKAGE BODY - XLE_UTILITIES_GRP

[top of page]

View: XLE_REGISTRATIONS_V

Comments
XLE_REGISTRATIONS_V view provides information about Registrations that are Identifying and Non-Identifying. Additionally, the user can access the Legal Authority Information related to the Registration.
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER

Legal Entity ID of the LE to which Registration is associated to .Value NULL if the Registration is associated to an Establishment
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name of the LE to which Registration is associated to. Value NULL if the Registration is associated to an Establishment
PARTY_ID NUMBER

Party id of the LE to which Registration is associated. Value NULL if the Registration is associated to an Establishment
ESTABLISHMENT_ID NUMBER

Establishment ID of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
ESTABLISHMENT_NAME VARCHAR2 (240)
Establishment Name of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
ESTABLISHMENT_PARTY_ID NUMBER

Establishment Name of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
REGISTRATION_ID NUMBER (15)
Registration ID of the Registration
REGISTRATION_NUMBER VARCHAR2 (30)
Registration Number of the Registration
REGISTERED_NAME VARCHAR2 (240)
Registered Name of the Registration
ALTERNATE_REGISTERED_NAME VARCHAR2 (240)
Alternate Registered Name of the Registration
IDENTIFYING VARCHAR2 (1)
Identifying Flag. Value Y for Identifying Registrations and Value N for Non-Identifying Registrations
LEGISLATIVE_CATEGORY VARCHAR2 (30)
Legislative Category
LEGALAUTH_ID NUMBER (15)
Issuing Legal Authority Identifier
LEGALAUTH_NAME VARCHAR2 (360)
Issuing Legal Authority Name
LEGALAUTH_ADDRESS VARCHAR2 (725)
Issuing Legal Authority Address
EFFECTIVE_FROM DATE

Registration Start Date
EFFECTIVE_TO DATE

Registration End Date
LOCATION_ID NUMBER (15)
Location Identifier
ADDRESS_STYLE VARCHAR2 (7)
Registered Address: Address Style
ADDRESS_LINE_1 VARCHAR2 (240)
Registered Address: Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Registered Address: Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Registered Address: Address Line 3
TOWN_OR_CITY VARCHAR2 (30)
Registered Address: Town Or City
REGION_1 VARCHAR2 (120)
Registered Address: Region 1
REGION_2 VARCHAR2 (120)
Registered Address: Region 2
REGION_3 VARCHAR2 (120)
Registered Address: Region 3
POSTAL_CODE VARCHAR2 (30)
Registered Address: Postal Code
COUNTRY VARCHAR2 (60)
Registered Address: Country

[top of page]

APPS.XLE_REGISTRATIONS_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - XLE_ENTITY_PROFILES
SYNONYM - XLE_ETB_PROFILES
VIEW - XLE_JURISDICTIONS_VL
SYNONYM - XLE_REGISTRATIONS
APPS.XLE_REGISTRATIONS_V is referenced by following:

APPS
PACKAGE BODY - JE_JEITAPEX_XMLP_PKG
PACKAGE BODY - JE_JEITXLRG_XMLP_PKG
PACKAGE BODY - JE_ZZ_AUDIT_AP_PKG
PACKAGE BODY - JG_TAXID_VAL_PKG
PACKAGE BODY - JG_ZZ_RGRH_PKG

[top of page]

View: XLE_TAX_ASSOCIATIONS

Comments
XLE_TAX_ASSOCIATIONS retrieves the Legal Tax Associations
Columns
Name Datatype Length Mandatory Comments
CONTEXT VARCHAR2 (80) Y Context
ENTITY_TYPE VARCHAR2 (80) Y Object Type Name
LEGAL_CONSTRUCT VARCHAR2 (80) Y Subject Type Name
ASSOCIATION_TYPE_ID NUMBER (15) Y Association Type Identifier
ASSOCIATION_ID NUMBER (15) Y Legal Association Identifier
ENTITY_ID NUMBER (15) Y Entity Identifier
ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
LEGAL_CONSTRUCT_ID NUMBER (15) Y Identifier of the Subject of the Legal Association
LEGAL_PARTY_ID NUMBER (15) Y Parent ID of the Subject ID. Will currently store the Legal Entity ID if the Subject Type is an Establishment
LEGAL_CONSTRUCT_NAME VARCHAR2 (240) Y Name of the Legal Construct
LEGAL_PARENT_ID NUMBER (15)
Legal Parent Identifier
EFFECTIVE_FROM DATE
Y Date from which the association is effective
EFFECTIVE_TO DATE

Date after which the association is ended

[top of page]

APPS.XLE_TAX_ASSOCIATIONS references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - XLE_ASSOCIATIONS
SYNONYM - XLE_ASSOCIATION_TYPES
SYNONYM - XLE_ASSOC_OBJECT_TYPES
SYNONYM - XLE_ETB_PROFILES
APPS.XLE_TAX_ASSOCIATIONS is referenced by following:

APPS
PACKAGE BODY - XLE_BUSINESSINFO_GRP
PACKAGE BODY - ZX_AP_POPULATE_PKG
PACKAGE BODY - ZX_AR_POPULATE_PKG
PACKAGE BODY - ZX_TCM_PTP_PKG

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract