[Home] [Help] [Dependency Information]
Object Name: | ECX_OUT_PROCESS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ECX.ECX_OUT_PROCESS_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Status for Outbound Messages
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Triggerring Identifier | |
DOCUMENT_ID | VARCHAR2 | (256) | Document Identifier | |
TRANSACTION_TYPE | VARCHAR2 | (100) | Internal Transaction Type | |
TRANSACTION_SUBTYPE | VARCHAR2 | (100) | Internal Transaction Subtype | |
PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
PARTY_ID | VARCHAR2 | (256) | Party Identifier | |
PARTY_SITE_ID | VARCHAR2 | (256) | Party Site Identifier | |
GENERATION_STATUS | VARCHAR2 | (256) | Message Generation Status | |
GENERATION_MESSAGE | VARCHAR2 | (4000) | Generating Message | |
GENERATION_TIMESTAMP | DATE | Generating Timestamp | ||
GENERATION_LOGFILE | VARCHAR2 | (256) | Message Generated Logfile | |
OUT_MSGID | RAW | (16) | Message Identifier | |
DELIVERY_STATUS | VARCHAR2 | (240) | Delivery Status | |
DELIVERY_MESSAGE | VARCHAR2 | (4000) | Delivery Message | |
DELIVERY_TIMESTAMP | DATE | Delivery Timestamp | ||
RETRY_STATUS | VARCHAR2 | (240) | Retry Status | |
RETRY_MESSAGE | VARCHAR2 | (4000) | Retry Message | |
RETRY_TIMESTAMP | DATE | Retry Timestamp | ||
PROTOCOL_TYPE | VARCHAR2 | (500) | Protocol Type | |
PROTOCOL_ADDRESS | VARCHAR2 | (2000) | Protocol Address | |
RETRY_MSGID | RAW | (16) | Retry Message Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TRIGGER_ID
, DOCUMENT_ID
, TRANSACTION_TYPE
, TRANSACTION_SUBTYPE
, PARTY_TYPE
, PARTY_ID
, PARTY_SITE_ID
, GENERATION_STATUS
, GENERATION_MESSAGE
, GENERATION_TIMESTAMP
, GENERATION_LOGFILE
, OUT_MSGID
, DELIVERY_STATUS
, DELIVERY_MESSAGE
, DELIVERY_TIMESTAMP
, RETRY_STATUS
, RETRY_MESSAGE
, RETRY_TIMESTAMP
, PROTOCOL_TYPE
, PROTOCOL_ADDRESS
, RETRY_MSGID
FROM APPS.ECX_OUT_PROCESS_VL;
|
|
|