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_RELATED_LINKS

Object Details

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

This table store Links to Releted Reports. Each Link is striped for a User, Report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_BIS_RELATED_LINKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RELATED_LINK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RELATED_LINK_ID	NUMBER		Yes	The Primary Key Column generated by a Sequence
USER_ID	NUMBER			The Id of the User who created this Related Link
FUNCTION_ID	NUMBER		Yes	The Function Id of the Report as defined in the Fnd_Form_Functions
LINK_TYPE	VARCHAR2	(30)	Yes	The type of the Link, whether it is a WWW url or a Report, etc.
DISPLAY_SEQUENCE	NUMBER			The sequence in which you want to see the Charts
LINKED_FUNCTION_ID	NUMBER			The Function Id of the Linked Report, if any
LINKED_FIELD	VARCHAR2	(80)		For backward compatibility
LINK_PARAMETERS	VARCHAR2	(4000)		Parameters, if any for the Related Link
LINK_CONDITION	VARCHAR2	(4000)		Conditions, if any for the Related Link
USER_URL	VARCHAR2	(2000)		External URLs
USER_LINK_NAME	VARCHAR2	(256)		Name for the URL
PREGENERATE	VARCHAR2	(1)		Should the Report be Pregenerated or not
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).
RESPONSIBILITY_ID	NUMBER			Responsibility ID of the user that created who record
APPLICATION_ID	NUMBER			The Application Id of the User who creted this record
SECURITY_GROUP_ID	NUMBER			Used to identify a Company/Subscriber in hosted solutions like CRM Online Services
SOURCE_CODE	VARCHAR2	(30)		For backward compatibility only
SOURCE_TYPE	VARCHAR2	(30)		For backward compatibility only

Query Text

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


SELECT RELATED_LINK_ID
,      USER_ID
,      FUNCTION_ID
,      LINK_TYPE
,      DISPLAY_SEQUENCE
,      LINKED_FUNCTION_ID
,      LINKED_FIELD
,      LINK_PARAMETERS
,      LINK_CONDITION
,      USER_URL
,      USER_LINK_NAME
,      PREGENERATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RESPONSIBILITY_ID
,      APPLICATION_ID
,      SECURITY_GROUP_ID
,      SOURCE_CODE
,      SOURCE_TYPE
FROM JTF.JTF_BIS_RELATED_LINKS;

Dependencies

[top of page]

JTF.JTF_BIS_RELATED_LINKS does not reference any database object

JTF.JTF_BIS_RELATED_LINKS is referenced by following:

APPS: JTF_BIS_RELATED_LINKS