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

Object Details

Object Name:	CSF_M_USER_V
Object Type:	VIEW
Owner:	APPS
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

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

This view contains information about the users

[View Source]

Columns

Name	Datatype	Length	Comments
ACCESS_ID	NUMBER		The Unique Access Identifier
USER_ID	NUMBER		The unique User Identifier
USER_NAME	VARCHAR2	(100)	User Name
RESOURCE_ID	NUMBER		The Resource or agent identifier
CLIENT_NUMBER	NUMBER		Client Number
LANGUAGE	VARCHAR2	(4000)	Language
ORG_ID	NUMBER		Org Identifier
LAST_SYNC_DATE_START	DATE		Last Sync Start Date
LAST_SYNC_DATE_END	DATE		Last Sync End Date
FIRST_NAME	VARCHAR2	(360)
LAST_NAME	VARCHAR2	(360)
FULL_NAME	VARCHAR2	(360)
RESPONSIBILITY_ID	NUMBER
MIGRATION_COMPLETED	VARCHAR2	(1)
MIGRATION_COMPLETED_DATE	DATE
MIGRATION_COMPLETION_VERSION	NUMBER
PARTY_ID	NUMBER
ROLE_NAME	VARCHAR2	(60)
ROLE_TYPE	VARCHAR2	(30)
GROUP_ID	NUMBER
IN_CURRENT_GROUP	VARCHAR2	(1)
PRIMARY_USER	VARCHAR2	(1)

Query Text

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


SELECT ACCESS_ID
,      USER_ID
,      USER_NAME
,      RESOURCE_ID
,      CLIENT_NUMBER
,      LANGUAGE
,      ORG_ID
,      LAST_SYNC_DATE_START
,      LAST_SYNC_DATE_END
,      FIRST_NAME
,      LAST_NAME
,      FULL_NAME
,      RESPONSIBILITY_ID
,      MIGRATION_COMPLETED
,      MIGRATION_COMPLETED_DATE
,      MIGRATION_COMPLETION_VERSION
,      PARTY_ID
,      ROLE_NAME
,      ROLE_TYPE
,      GROUP_ID
,      IN_CURRENT_GROUP
,      PRIMARY_USER
FROM APPS.CSF_M_USER_V;

Dependencies

[top of page]

APPS.CSF_M_USER_V references the following:

APPS: ASG_BASE - show dependent code; ASG_USER; CSM_USER_ACC; CSM_UTIL_PKG - show dependent code; FND_USER; JTF_RS_RESOURCE_EXTNS; JTF_RS_ROLES_B; JTF_RS_ROLES_TL

APPS.CSF_M_USER_V is not referenced by any database object