[Home] [Help] [Dependency Information]
Object Name: | OAM_PAT_WS_REQUEST |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.OAM_PAT_WS_REQUEST |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OAM_PAT_WS_REQUEST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MESSAGE_ID |
OAM_PAT_WS_REQUEST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_TIMESTAMP |
OAM_PAT_WS_REQUEST_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
MESSAGE_ID | VARCHAR2 | (50) | Yes | |
REQUEST_TIMESTAMP | DATE | Yes | ||
USER_ID | NUMBER | (15) | ||
RESPONSIBILITY_ID | NUMBER | (15) | ||
RESPONSIBILITY_APPLICATION_ID | NUMBER | |||
NLS_LANGUAGE | VARCHAR2 | (30) | ||
SECURITY_GROUP_NAME | VARCHAR2 | (30) | ||
IREP_NAME | VARCHAR2 | (2000) | ||
IP_ADDRESS | VARCHAR2 | (25) | Yes | |
TARGET_URI | VARCHAR2 | (2000) | ||
METHOD | VARCHAR2 | (250) | ||
INTERFACE | VARCHAR2 | (250) | ||
NO_OF_ATTACHMENTS | NUMBER | (5) | ||
ATTRIB1 | VARCHAR2 | (250) | ||
ATTRIB2 | VARCHAR2 | (250) | ||
ATTRIB3 | VARCHAR2 | (250) | ||
ATTRIB4 | VARCHAR2 | (250) | ||
ATTRIB5 | VARCHAR2 | (250) | ||
ATTRIB6 | VARCHAR2 | (250) | ||
ATTRIB7 | VARCHAR2 | (250) | ||
ATTRIB8 | VARCHAR2 | (250) | ||
ATTRIB9 | VARCHAR2 | (250) | ||
ATTRIB10 | VARCHAR2 | (250) | ||
ATTRIB11 | VARCHAR2 | (250) | ||
ATTRIB12 | VARCHAR2 | (250) | ||
ATTRIB13 | VARCHAR2 | (250) | ||
ATTRIB14 | VARCHAR2 | (250) | ||
ATTRIB15 | VARCHAR2 | (250) |
Cut, paste (and edit) the following text to query this object:
SELECT CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MESSAGE_ID
, REQUEST_TIMESTAMP
, USER_ID
, RESPONSIBILITY_ID
, RESPONSIBILITY_APPLICATION_ID
, NLS_LANGUAGE
, SECURITY_GROUP_NAME
, IREP_NAME
, IP_ADDRESS
, TARGET_URI
, METHOD
, INTERFACE
, NO_OF_ATTACHMENTS
, ATTRIB1
, ATTRIB2
, ATTRIB3
, ATTRIB4
, ATTRIB5
, ATTRIB6
, ATTRIB7
, ATTRIB8
, ATTRIB9
, ATTRIB10
, ATTRIB11
, ATTRIB12
, ATTRIB13
, ATTRIB14
, ATTRIB15
FROM APPLSYS.OAM_PAT_WS_REQUEST;
APPLSYS.OAM_PAT_WS_REQUEST does not reference any database object
APPLSYS.OAM_PAT_WS_REQUEST is referenced by following:
|
|
|