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: CSM.CSF_M_USER_INQ#

Object Details

Object Name:	CSF_M_USER_INQ#
Object Type:	VIEW
Owner:	CSM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
CLID$$CS	VARCHAR2	(100)
USER_ID	NUMBER
USER_NAME	VARCHAR2	(100)
RESOURCE_ID	NUMBER
CLIENT_NUMBER	NUMBER
LANGUAGE	VARCHAR2	(4000)
ORG_ID	NUMBER
LAST_SYNC_DATE_START	DATE
LAST_SYNC_DATE_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
DMLTYPE$$	VARCHAR2	(1)
SEQNO$$	NUMBER
TRANID$$	NUMBER	(10)
VERSION$$	NUMBER	(10)
ROLE_NAME	VARCHAR2	(4000)
ROLE_TYPE	VARCHAR2	(4000)
GROUP_ID	NUMBER
IN_CURRENT_GROUP	VARCHAR2	(4000)
PRIMARY_USER	VARCHAR2	(1)

Query Text

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


SELECT CLID$$CS
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      ROLE_NAME
,      ROLE_TYPE
,      GROUP_ID
,      IN_CURRENT_GROUP
,      PRIMARY_USER
FROM CSM.CSF_M_USER_INQ#;

Dependencies

[top of page]

CSM.CSF_M_USER_INQ# references the following:

CSM: CSF_M_USER_INQ

CSM.CSF_M_USER_INQ# is referenced by following:

APPS: CSF_M_USER_INQ