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_BIS_USER_FAVORITE_PLUGS

Object Details

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

This table is for storing Chart report information for each user-defined Favorite Plug

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_BIS_USER_FAVORITE_PLUGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID PLUG_ID FUNCTION_ID SEQ RESPONSIBILITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLUG_ID	NUMBER		Yes	Plug ID for ICX PHP Plugs
USER_ID	NUMBER		Yes	The User ID of the user that created this record
FUNCTION_ID	NUMBER		Yes	Function ID of the Favorite report
RESPONSIBILITY_ID	NUMBER		Yes	Responsibility ID of the user that created this record
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created 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_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SEQ	NUMBER		Yes	Sequential number of the report
REPORT_PARAMETER	VARCHAR2	(2000)		For the storage of the HTML strings of report parameters
FAVORITE_LINK_NAME	VARCHAR2	(240)		The name of the Favorite report
REPORT_ID	VARCHAR2	(30)		The report ID of the Favorite report
RDF_FILE_NAME	VARCHAR2	(30)		The report file name of the Favorite report
APPLICATION_ID	NUMBER			The application ID of the Favorite report
SECURITY_GROUP_ID	NUMBER			Used to identify a Company/Subscriber in hosted solutions like CRM Online Services

Query Text

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


SELECT PLUG_ID
,      USER_ID
,      FUNCTION_ID
,      RESPONSIBILITY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEQ
,      REPORT_PARAMETER
,      FAVORITE_LINK_NAME
,      REPORT_ID
,      RDF_FILE_NAME
,      APPLICATION_ID
,      SECURITY_GROUP_ID
FROM JTF.JTF_BIS_USER_FAVORITE_PLUGS;

Dependencies

[top of page]

JTF.JTF_BIS_USER_FAVORITE_PLUGS does not reference any database object

JTF.JTF_BIS_USER_FAVORITE_PLUGS is referenced by following:

JTF: JTF_BIS_USER_FAVORITE_PLUGS#