DBA Data[Home] [Help] [Dependency Information]

TABLE: CSM.CSF_M_USER_INQ

Object Details
Object Name: CSF_M_USER_INQ
Object Type: TABLE
Owner: CSM
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (100)
USER_ID NUMBER

USER_NAME VARCHAR2 (100)
RESOURCE_ID NUMBER

CLIENT_NUMBER NUMBER

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)
LANGUAGE#1 VARCHAR2 (4000)
Query Text

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


SELECT CLID$$CS
,      USER_ID
,      USER_NAME
,      RESOURCE_ID
,      CLIENT_NUMBER
,      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
,      LANGUAGE#1
FROM CSM.CSF_M_USER_INQ;

Dependencies

[top of page]

CSM.CSF_M_USER_INQ does not reference any database object

CSM.CSF_M_USER_INQ is referenced by following:

SchemaCSM
ViewCSF_M_USER_INQ#