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]

VIEW: APPS.JTF_RS_ROLE_RELATIONS_VL

Object Details

Object Name:	JTF_RS_ROLE_RELATIONS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_ROLE_RELATIONS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows the listing of details of roles attached to resource.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROLE_RELATE_ID	NUMBER		Yes	Role Relation identifier (PK)
ROLE_RESOURCE_TYPE	VARCHAR2	(30)	Yes	Resource type. (lookup type: JTF_RS_ ROLE_RES_TYPE)
ROLE_RESOURCE_ID	NUMBER		Yes	Resource identifier (foreign key to JTF_RESOURCE_EXTN) or (foreign key to JTF_RS_GROUPS_VL) or (foreign key to JTF_RS_GROUPS_MEMBERS or (foreign key to JTF_RS_TEAMS_VL) or (foreign key to JTF_RS_TEAM_MEMBERS)
ROLE_ID	NUMBER		Yes	Role identifier (foreign key to JTF_RS_ROLES)
START_DATE_ACTIVE	DATE		Yes	Date this role-resource becomes active
END_DATE_ACTIVE	DATE			Date this role-resource becomes inactive
ROLE_NAME	VARCHAR2	(60)	Yes	Role Name
MEMBER_FLAG	VARCHAR2	(1)		Flag indicating this role is a member role or not
ADMIN_FLAG	VARCHAR2	(1)		Flag indicating this role is a admin role or not
LEAD_FLAG	VARCHAR2	(1)		Flag indicating this role is a leader role or not
MANAGER_FLAG	VARCHAR2	(1)		Flag indicating this role is a manager role or not
ROLE_TYPE_CODE	VARCHAR2	(240)	Yes	Role type identifier ( lookup type: JTF_RS_ROLE_TYPE )
MEANING	VARCHAR2	(80)	Yes	Meaning of Role Type Code
ROLE_CODE	VARCHAR2	(30)	Yes	Role code.

Query Text

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


SELECT ROLE_RELATE_ID
,      ROLE_RESOURCE_TYPE
,      ROLE_RESOURCE_ID
,      ROLE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ROLE_NAME
,      MEMBER_FLAG
,      ADMIN_FLAG
,      LEAD_FLAG
,      MANAGER_FLAG
,      ROLE_TYPE_CODE
,      MEANING
,      ROLE_CODE
FROM APPS.JTF_RS_ROLE_RELATIONS_VL;

Dependencies

[top of page]

APPS.JTF_RS_ROLE_RELATIONS_VL references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_RS_ROLES_VL; JTF_RS_ROLE_RELATIONS

APPS.JTF_RS_ROLE_RELATIONS_VL is referenced by following:

APPS: AHL_APPROVALS_PVT - show dependent code; AHL_APPROVERS_TYPE_V; AHL_APPROVERS_V; AHL_PP_MATERIALS_PVT - show dependent code; AMV_USER_PVT - show dependent code; AST_RS_GRP_VALID_V; IBU_DYN_USER_GROUPS_PKG - show dependent code; IEX_COLLECTORS_TO_RESOURCE - show dependent code; JTF_RS_GRP_HIER_MEM_V; JTF_TR_ALL_RESOURCES_V; OKL_AM_ASSET_RETURN_WF - show dependent code; OKL_AM_PORTFOLIO_TEAMS_UV; OKL_AM_REMARKET_TEAMS_UV