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


TABLE: HR.HR_DE_ORGANIZATION_LINKS

Object Details
Object Name: HR_DE_ORGANIZATION_LINKS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_DE_ORGANIZATION_LINKS
Subobject Name:
Status: VALID


HR_DE_ORGANIZATION_LINKS is used to maintain links between HR Organizations and External Organizations


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_LINK_ID NUMBER (15) Yes System-generated primary key column.
PARENT_ORGANIZATION_ID NUMBER (15) Yes Organization id of the parent in the relationship
CHILD_ORGANIZATION_ID NUMBER (15) Yes Organization id of the Child in the relationship
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group ID
ORG_LINK_TYPE VARCHAR2 (30) Yes Holds the Type of Link that the Organizations have
ORG_LINK_INFORMATION_CATEGORY VARCHAR2 (30)
Determines the type of Info held in the segments below
ORG_LINK_INFORMATION1 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION2 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION3 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION4 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION5 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION6 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION7 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION8 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION9 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION10 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION11 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION12 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION13 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION14 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION15 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION16 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION17 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION18 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION19 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION20 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION21 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION22 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION23 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION24 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION25 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION26 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION27 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION28 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION29 VARCHAR2 (150)
Developer descriptive flex column.
ORG_LINK_INFORMATION30 VARCHAR2 (150)
Developer descriptive flex column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Determines the type of Info held in the Descriptive FF segments below
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flex column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flex column
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
Query Text

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


SELECT ORGANIZATION_LINK_ID
,      PARENT_ORGANIZATION_ID
,      CHILD_ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      ORG_LINK_TYPE
,      ORG_LINK_INFORMATION_CATEGORY
,      ORG_LINK_INFORMATION1
,      ORG_LINK_INFORMATION2
,      ORG_LINK_INFORMATION3
,      ORG_LINK_INFORMATION4
,      ORG_LINK_INFORMATION5
,      ORG_LINK_INFORMATION6
,      ORG_LINK_INFORMATION7
,      ORG_LINK_INFORMATION8
,      ORG_LINK_INFORMATION9
,      ORG_LINK_INFORMATION10
,      ORG_LINK_INFORMATION11
,      ORG_LINK_INFORMATION12
,      ORG_LINK_INFORMATION13
,      ORG_LINK_INFORMATION14
,      ORG_LINK_INFORMATION15
,      ORG_LINK_INFORMATION16
,      ORG_LINK_INFORMATION17
,      ORG_LINK_INFORMATION18
,      ORG_LINK_INFORMATION19
,      ORG_LINK_INFORMATION20
,      ORG_LINK_INFORMATION21
,      ORG_LINK_INFORMATION22
,      ORG_LINK_INFORMATION23
,      ORG_LINK_INFORMATION24
,      ORG_LINK_INFORMATION25
,      ORG_LINK_INFORMATION26
,      ORG_LINK_INFORMATION27
,      ORG_LINK_INFORMATION28
,      ORG_LINK_INFORMATION29
,      ORG_LINK_INFORMATION30
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.HR_DE_ORGANIZATION_LINKS;

Dependencies

[top of page]

HR.HR_DE_ORGANIZATION_LINKS does not reference any database object

HR.HR_DE_ORGANIZATION_LINKS is referenced by following:

SchemaAPPS
SynonymHR_DE_ORGANIZATION_LINKS
TriggerHR_DE_ORGANIZATION_LINKS_WHO
SchemaPUBLIC
SynonymHR_DE_ORGANIZATION_LINKS