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.OKX_RESOURCE_ROLES_V

Object Details

Object Name:	OKX_RESOURCE_ROLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_RESOURCE_ROLES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER		Yes	Role Relation identifier (PK)
ID2	CHAR	(1)		(Multi-part) Primary Key
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)
RESOURCE_TYPE	VARCHAR2	(30)	Yes	Resource type. (lookup type: JTF_RS_ ROLE_RES_TYPE)
ROLE_RELATE_ID	NUMBER		Yes	Role Relation identifier (PK)
ROLE_ID	NUMBER		Yes	Role identifier (foreign key to JTF_RS_ROLES)
NAME	VARCHAR2	(60)	Yes	Role name
DESCRIPTION	VARCHAR2	(120)		Role Description
STATUS	VARCHAR2	(1)		Flag indicating this role is an active role or not
START_DATE_ACTIVE	DATE		Yes	Date this role-resource becomes active
END_DATE_ACTIVE	DATE			Date this role-resource becomes inactive
ROLE_TYPE_CODE	VARCHAR2	(240)	Yes	Role type identifier ( lookup type: JTF_RS_ROLE_TYPE )
ROLE_CODE	VARCHAR2	(30)	Yes	Role Code
DELETE_FLAG	VARCHAR2	(1)		Delete Flag indicates whether this record is logically deleted or not?
SEEDED_FLAG	VARCHAR2	(1)		Flag indicating pre-defined role types
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

Query Text

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


SELECT ID1
,      ID2
,      RESOURCE_ID
,      RESOURCE_TYPE
,      ROLE_RELATE_ID
,      ROLE_ID
,      NAME
,      DESCRIPTION
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ROLE_TYPE_CODE
,      ROLE_CODE
,      DELETE_FLAG
,      SEEDED_FLAG
,      MEMBER_FLAG
,      ADMIN_FLAG
,      LEAD_FLAG
,      MANAGER_FLAG
FROM APPS.OKX_RESOURCE_ROLES_V;

Dependencies

[top of page]

APPS.OKX_RESOURCE_ROLES_V references the following:

APPS: JTF_RS_ROLES_B; JTF_RS_ROLES_TL; JTF_RS_ROLE_RELATIONS

APPS.OKX_RESOURCE_ROLES_V is referenced by following:

APPS: OKC_RESOURCE_GROUPS_V; OKC_RESOURCE_USERS_V