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

TABLE: DOM.DOM_OCS_SYNC_PENDING_DATA

Object Details
Object Name: DOM_OCS_SYNC_PENDING_DATA
Object Type: TABLE
Owner: DOM
FND Design Data: TableDOM.DOM_OCS_SYNC_PENDING_DATA
Subobject Name:
Status: VALID


DOM_OCS_SYNC_PENDING_DATA


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
PROCESS_ID NUMBER (15) Yes Process internal id
CAT_ID NUMBER (15)
Category id
DOC_ID NUMBER (15)
Document id
REV_ID NUMBER (15)
Revision id
CHANGE_ID NUMBER (15)
Change Id
USER_ID NUMBER (15)
User id
GRP_ID NUMBER (15)
Group id
EBS_ROLE NUMBER (15)
EBS Role id
OCS_ROLE VARCHAR2 (30)
OCS Role id
ST_DATE DATE

Start date
ED_DATE DATE

End Date
REP_ID NUMBER (15)
REp_ID
PROCESS_FLAG VARCHAR2 (30)
Flag to indicate if the data has been processed or approved
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
Query Text

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


SELECT LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      PROCESS_ID
,      CAT_ID
,      DOC_ID
,      REV_ID
,      CHANGE_ID
,      USER_ID
,      GRP_ID
,      EBS_ROLE
,      OCS_ROLE
,      ST_DATE
,      ED_DATE
,      REP_ID
,      PROCESS_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM DOM.DOM_OCS_SYNC_PENDING_DATA;

Dependencies

[top of page]

DOM.DOM_OCS_SYNC_PENDING_DATA does not reference any database object

DOM.DOM_OCS_SYNC_PENDING_DATA is referenced by following:

SchemaAPPS
SynonymDOM_OCS_SYNC_PENDING_DATA