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: APPLSYS.FND_OBJECT_KEY_SETS

Object Details

Object Name:	FND_OBJECT_KEY_SETS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_OBJECT_KEY_SETS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: FND_OBJECT_KEY_SETS_PK

OBJECT_ID
KEY_SET_NAME
KEY_SET_SEQUENCE
ZD_EDITION_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_OBJECT_KEY_SETS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID KEY_SET_NAME KEY_SET_SEQUENCE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory
OBJECT_ID	NUMBER	(15)	Yes
KEY_SET_NAME	VARCHAR2	(120)	Yes
KEY_SET_SEQUENCE	NUMBER	(3)	Yes
KEY1_MEMBER_NAME	VARCHAR2	(240)
KEY2_MEMBER_NAME	VARCHAR2	(240)
KEY3_MEMBER_NAME	VARCHAR2	(240)
KEY4_MEMBER_NAME	VARCHAR2	(240)
KEY5_MEMBER_NAME	VARCHAR2	(240)
ALT1_MEMBER_NAME	VARCHAR2	(240)
ALT2_MEMBER_NAME	VARCHAR2	(240)
ALT3_MEMBER_NAME	VARCHAR2	(240)
ALT4_MEMBER_NAME	VARCHAR2	(240)
ALT5_MEMBER_NAME	VARCHAR2	(240)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT OBJECT_ID
,      KEY_SET_NAME
,      KEY_SET_SEQUENCE
,      KEY1_MEMBER_NAME
,      KEY2_MEMBER_NAME
,      KEY3_MEMBER_NAME
,      KEY4_MEMBER_NAME
,      KEY5_MEMBER_NAME
,      ALT1_MEMBER_NAME
,      ALT2_MEMBER_NAME
,      ALT3_MEMBER_NAME
,      ALT4_MEMBER_NAME
,      ALT5_MEMBER_NAME
,      ZD_EDITION_NAME
FROM APPLSYS.FND_OBJECT_KEY_SETS;

Dependencies

[top of page]

APPLSYS.FND_OBJECT_KEY_SETS does not reference any database object

APPLSYS.FND_OBJECT_KEY_SETS is referenced by following:

APPLSYS: FND_OBJECT_KEY_SETS#