eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XLE.XLE_ASSOCIATIONS

Object Details

Object Name:	XLE_ASSOCIATIONS
Object Type:	TABLE
Owner:	XLE
FND Design Data:	XLE.XLE_ASSOCIATIONS
Subobject Name:
Status:	VALID

XLE_ASSOCIATIONS stores the Legal Associations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLE_ASSOCIATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_ID
XLE_ASSOCIATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_TYPE_ID SUBJECT_ID OBJECT_ID EFFECTIVE_FROM

Columns

Name	Datatype	Length	Mandatory	Comments
ASSOCIATION_ID	NUMBER	(15)	Yes	Legal Association Identifier
ASSOCIATION_TYPE_ID	NUMBER	(15)	Yes	Association Type Identifier.Foreign Key to XLE_ASSOCIATION_TYPES table
SUBJECT_ID	NUMBER	(15)	Yes	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)	Yes	Identifier of the Object of the Legal Association.Foreign Key to the base table where instances of the subjects are stored.
EFFECTIVE_FROM	DATE		Yes	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)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSOCIATION_ID
,      ASSOCIATION_TYPE_ID
,      SUBJECT_ID
,      SUBJECT_PARENT_ID
,      OBJECT_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASSOC_INFORMATION_CONTEXT
,      ASSOC_INFORMATION1
,      ASSOC_INFORMATION2
,      ASSOC_INFORMATION3
,      ASSOC_INFORMATION4
,      ASSOC_INFORMATION5
,      ASSOC_INFORMATION6
,      ASSOC_INFORMATION7
,      ASSOC_INFORMATION8
,      ASSOC_INFORMATION9
,      ASSOC_INFORMATION10
,      ASSOC_INFORMATION11
,      ASSOC_INFORMATION12
,      ASSOC_INFORMATION13
,      ASSOC_INFORMATION14
,      ASSOC_INFORMATION15
,      ASSOC_INFORMATION16
,      ASSOC_INFORMATION17
,      ASSOC_INFORMATION18
,      ASSOC_INFORMATION19
,      ASSOC_INFORMATION20
FROM XLE.XLE_ASSOCIATIONS;

Dependencies

[top of page]

XLE.XLE_ASSOCIATIONS does not reference any database object

XLE.XLE_ASSOCIATIONS is referenced by following:

APPS: XLE_ASSOCIATIONS