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: BIS.BIS_CUSTOM_RELATED_LINKS

Object Details

Object Name:	BIS_CUSTOM_RELATED_LINKS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_CUSTOM_RELATED_LINKS
Subobject Name:
Status:	VALID

Customized Related Links

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_CUSTOM_RELATED_LINKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_SITE_ID
BIS_CUSTOM_RELATED_LINKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_RESPONSIBILITY_ID
BIS_CUSTOM_RELATED_LINKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_ORG_ID
BIS_CUSTOM_RELATED_LINKS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_APPLICATION_ID
BIS_CUSTOM_RELATED_LINKS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_FUNCTION_ID
BIS_CUSTOM_RELATED_LINKS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNCTION_ID LEVEL_USER_ID
BIS_CUSTOM_RELATED_LINKS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATED_LINK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RELATED_LINK_ID	NUMBER		Yes	Related Link Id
FUNCTION_ID	NUMBER		Yes	Function id
LINK_TYPE	VARCHAR2	(30)	Yes	Link Type
LINKED_FUNCTION_ID	NUMBER			Linked Function Id
LINKED_FIELD	VARCHAR2	(61)		Linked Field
LINK_PARAMETERS	VARCHAR2	(4000)		Link Parameters
LINK_CONDITION	VARCHAR2	(4000)		Link Condtion
USER_URL	VARCHAR2	(2000)		User URL
RESPONSIBILITY_ID	NUMBER			Responsibility Id
SECURITY_GROUP_ID	NUMBER			Security Group Id
RESPONSIBILITY_APPLICATION_ID	NUMBER			Responsibility Application Id
DISPLAY_SEQUENCE	NUMBER			Display Sequence
LEVEL_SITE_ID	NUMBER			Level SITE ID
LEVEL_RESPONSIBILITY_ID	NUMBER			Level Responsibility Id
LEVEL_ORG_ID	NUMBER			Level Org Id
LEVEL_APPLICATION_ID	NUMBER			Level APPLICATION Id
LEVEL_FUNCTION_ID	NUMBER			Level Function Id
LEVEL_USER_ID	NUMBER			Level User Id
CREATION_DATE	DATE		Yes	Creation date
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_DATE	DATE		Yes	Last Update date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated By
LAST_UPDATE_LOGIN	NUMBER			Last Update Login

Query Text

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


SELECT RELATED_LINK_ID
,      FUNCTION_ID
,      LINK_TYPE
,      LINKED_FUNCTION_ID
,      LINKED_FIELD
,      LINK_PARAMETERS
,      LINK_CONDITION
,      USER_URL
,      RESPONSIBILITY_ID
,      SECURITY_GROUP_ID
,      RESPONSIBILITY_APPLICATION_ID
,      DISPLAY_SEQUENCE
,      LEVEL_SITE_ID
,      LEVEL_RESPONSIBILITY_ID
,      LEVEL_ORG_ID
,      LEVEL_APPLICATION_ID
,      LEVEL_FUNCTION_ID
,      LEVEL_USER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.BIS_CUSTOM_RELATED_LINKS;

Dependencies

[top of page]

BIS.BIS_CUSTOM_RELATED_LINKS does not reference any database object

BIS.BIS_CUSTOM_RELATED_LINKS is referenced by following:

APPS: BIS_CUSTOM_RELATED_LINKS