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: JTF.JTF_AUTH_MAPS_SOURCES

Object Details

Object Name:	JTF_AUTH_MAPS_SOURCES
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_AUTH_MAPS_SOURCES
Subobject Name:
Status:	VALID

This table stores the source information for the user-role mapping table. A role can be assigned to a user coming from different sources. An entry in JTF_AUTH_PRINCIPAL_MAPS can correspond to 1 or more entries in this table. The foreign key is JTF_AUTH_PRINCIPAL_MAPPING_ID. Source table name has to come from FND lookup for JTF_AUTH_OWNERTABLE_NAME.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_AUTH_MAPS_SOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JTF_AUTH_MAPS_SOURCE_ID
JTF_AUTH_MAPS_SOURCES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OWNERTABLE_NAME OWNERTABLE_KEY JTF_AUTH_PRINCIPAL_MAPPING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JTF_AUTH_MAPS_SOURCE_ID	NUMBER	(16)	Yes	Primary key
JTF_AUTH_PRINCIPAL_MAPPING_ID	NUMBER	(16)	Yes	This points to the user-role mapping entry in JTF_AUTH_PRINCIPAL_MAPS
OWNERTABLE_NAME	VARCHAR2	(60)	Yes	Table name of the source table. For example a role can be assigned to a user depending on the user-type in which case JTF_UM_USERTYPES_B can be the source table. Any candidate source table should be listed in JTF_AUTH_OWNERTABLE_NAME FND lookup.
OWNERTABLE_KEY	VARCHAR2	(60)	Yes	Primary key of the source table to which this user-role mapping comes from
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPLICATION_ID	NUMBER	(15)	Yes	ID used to stripe data by applications
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard object version numbers

Query Text

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


SELECT JTF_AUTH_MAPS_SOURCE_ID
,      JTF_AUTH_PRINCIPAL_MAPPING_ID
,      OWNERTABLE_NAME
,      OWNERTABLE_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_AUTH_MAPS_SOURCES;

Dependencies

[top of page]

JTF.JTF_AUTH_MAPS_SOURCES does not reference any database object

JTF.JTF_AUTH_MAPS_SOURCES is referenced by following:

APPS: JTF_AUTH_MAPS_SOURCES