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

TABLE: XNP.XNP_SYNC_REGISTRATION

Object Details
Object Name: XNP_SYNC_REGISTRATION
Object Type: TABLE
Owner: XNP
FND Design Data: TableXNP.XNP_SYNC_REGISTRATION
Subobject Name:
Status: VALID


XNP_SYNC_REGISTRATION maintains the state of synchronized workflows


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XNP_SYNC_REGISTRATION_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSYNC_REGISTRATION_ID
XNP_SYNC_REGISTRATION_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSYNC_LABEL
ColumnORDER_ID
Columns
Name Datatype Length Mandatory Comments
SYNC_REGISTRATION_ID NUMBER
Yes Synchronized registration identifier
SYNC_LABEL VARCHAR2 (240) Yes Synchronization token given to a group of synchronized workflows
ORDER_ID NUMBER
Yes Order Id of the SFM order to which all the synchronized workflows belong
STATUS VARCHAR2 (40) Yes Status that indicates if the workflows are in synch with each other
MAX_PARTICIPANTS NUMBER
Yes Total number of participants be synchronized
PARTIES_NOT_IN_SYNC NUMBER
Yes Participants yet to synchronize
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT SYNC_REGISTRATION_ID
,      SYNC_LABEL
,      ORDER_ID
,      STATUS
,      MAX_PARTICIPANTS
,      PARTIES_NOT_IN_SYNC
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SYNC_REGISTRATION;

Dependencies

[top of page]

XNP.XNP_SYNC_REGISTRATION does not reference any database object

XNP.XNP_SYNC_REGISTRATION is referenced by following:

SchemaXNP
ViewXNP_SYNC_REGISTRATION#