[Home] [Help] [Dependency Information]
Object Name: | XNP_MSGS# |
---|---|
Object Type: | VIEW |
Owner: | XNP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSG_ID | NUMBER | Yes | ||
BODY_TEXT | CLOB | (4000) | Yes | |
MSG_CODE | VARCHAR2 | (20) | Yes | |
MSG_CREATION_DATE | DATE | |||
DIRECTION_INDICATOR | VARCHAR2 | (1) | ||
REFERENCE_ID | VARCHAR2 | (1996) | ||
OPP_REFERENCE_ID | VARCHAR2 | (1996) | ||
MSG_VERSION | NUMBER | |||
SENDER_NAME | VARCHAR2 | (300) | ||
RECIPIENT_NAME | VARCHAR2 | (40) | ||
SEND_RCV_DATE | DATE | |||
MSG_STATUS | VARCHAR2 | (10) | ||
DESCRIPTION | VARCHAR2 | (1996) | ||
RETRIES | NUMBER | |||
ORDER_ID | NUMBER | |||
WI_INSTANCE_ID | NUMBER | |||
FA_INSTANCE_ID | NUMBER | |||
FE_NAME | VARCHAR2 | (40) | ||
ADAPTER_NAME | VARCHAR2 | (40) | ||
UPDATED_BY_USER | VARCHAR2 | (40) | ||
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) | ||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT MSG_ID
, BODY_TEXT
, MSG_CODE
, MSG_CREATION_DATE
, DIRECTION_INDICATOR
, REFERENCE_ID
, OPP_REFERENCE_ID
, MSG_VERSION
, SENDER_NAME
, RECIPIENT_NAME
, SEND_RCV_DATE
, MSG_STATUS
, DESCRIPTION
, RETRIES
, ORDER_ID
, WI_INSTANCE_ID
, FA_INSTANCE_ID
, FE_NAME
, ADAPTER_NAME
, UPDATED_BY_USER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_MSGS#;
|
|
|