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_REGISTRATION_DETAILS

Object Details

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

Table contains data in fourth normal form for storage requirements not anticipated in the FND_REGISTRATIONS table. Both flex architecture and extra data requirements (for instance, if your flow wishes to record shoe size) should be maintained in this table.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_REGISTRATION_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	APPLICATION_ID REGISTRATION_TYPE
FND_REGISTRATION_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REGISTRATION_ID FIELD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTRATION_ID	NUMBER	(15)	Yes	FK to FND_REGISTRATIONS
APPLICATION_ID	NUMBER	(15)	Yes	FK to FND_APPLICATIONS, striping the data by the application for which the user is registering. Also part of the FK to FND_REGISTRATION_TYPES.
REGISTRATION_TYPE	VARCHAR2	(255)	Yes	With APPLICATION_ID, FK to FND_REGISTRATION_TYPES, allowing multiple types of registration within a particular application.
FIELD_NAME	VARCHAR2	(255)	Yes	This is the field name for the value stored in FIELD_VALUE
FIELD_TYPE	VARCHAR2	(255)		The datatype for the data in FIELD_VALUE. This is so that data can be more clearly labeled as NUMBER, DATE, etc
FIELD_FORMAT	VARCHAR2	(255)		This is an attribute column in case other data is required to fully model the data in FIELD_VALUE. E.g. for a DATE, this might by MM-DD-RRRR to specify a particular format the value is stored in the text field.
FIELD_VALUE_STRING	VARCHAR2	(4000)		String Data for the user
FIELD_VALUE_NUMBER	NUMBER			Numeric Data for the user.
FIELD_VALUE_DATE	DATE			Date Data for the user.
LAST_UPDATE_DATE	DATE		Yes	Who field.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who field.
CREATED_BY	NUMBER	(15)	Yes	Who field.
CREATION_DATE	DATE		Yes	Who field.
LAST_UPDATE_LOGIN	NUMBER	(15)		Who field.

Query Text

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


SELECT REGISTRATION_ID
,      APPLICATION_ID
,      REGISTRATION_TYPE
,      FIELD_NAME
,      FIELD_TYPE
,      FIELD_FORMAT
,      FIELD_VALUE_STRING
,      FIELD_VALUE_NUMBER
,      FIELD_VALUE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_REGISTRATION_DETAILS;

Dependencies

[top of page]

APPLSYS.FND_REGISTRATION_DETAILS does not reference any database object

APPLSYS.FND_REGISTRATION_DETAILS is referenced by following:

APPS: FND_REGISTRATION_DETAILS