[Home] [Help] [Dependency Information]

TABLE: HRI.EDW_ORGA_TREE1_LVL7_LTC

Object Details

Object Name:	EDW_ORGA_TREE1_LVL7_LTC
Object Type:	TABLE
Owner:	HRI
FND Design Data:	HRI.EDW_ORGA_TREE1_LVL7_LTC
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_ORGA_TREE1_LVL7_LTC_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORG_TREE1_LVL7_PK_KEY
EDW_ORGA_TREE1_LVL7_LTC_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORG_TREE1_LVL7_PK ORG_TREE1_LVL7_PK_KEY
EDW_ORGA_TREE1_LVL7_LTC_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_TREE1_LVL8_FK_KEY

Columns

Query Text

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

SELECT BUSINESS_GROUP
,      CREATION_DATE
,      INSTANCE
,      LAST_UPDATE_DATE
,      NAME
,      ORGANIZATION_ID
,      ORG_TREE1_LVL7_PK
,      ORG_TREE1_LVL7_PK_KEY
,      ORG_TREE1_LVL8_FK
,      ORG_TREE1_LVL8_FK_KEY
,      PRIMARY_ORG_DP
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM HRI.EDW_ORGA_TREE1_LVL7_LTC;

Dependencies

[top of page]

HRI.EDW_ORGA_TREE1_LVL7_LTC does not reference any database object

HRI.EDW_ORGA_TREE1_LVL7_LTC is referenced by following:

APPS

EDW_ORGA_TREE1_LVL7_LTC