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

VIEW: APPS.ECX_IN_PROCESS_VL

Object Details
Object Name: ECX_IN_PROCESS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewECX.ECX_IN_PROCESS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Status for Inbound Messages


[View Source]

Columns
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_ID NUMBER

Party Identifier
PARTY_SITE_ID NUMBER

Party Site Identifier
PARTY_TYPE VARCHAR2 (30)
Party Type
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
INTERNAL_CONTROL_NUMBER NUMBER

Internal Message Control Number
PROCESSING_STATUS VARCHAR2 (256)
Processing Status
PROCESSING_MESSAGE VARCHAR2 (4000)
Processing Message
PROCESSING_TIMESTAMP DATE

Processing Timestamp
PROCESSING_LOGFILE VARCHAR2 (256)
Processing Logfile
OUT_MSGID RAW (16)
Message Identifier
MSGID RAW (16) Yes Message Identifier
Query Text

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


SELECT TRIGGER_ID
,      DOCUMENT_ID
,      TRANSACTION_TYPE
,      TRANSACTION_SUBTYPE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_TYPE
,      SOURCE_TP_LOCATION_CODE
,      INTERNAL_CONTROL_NUMBER
,      PROCESSING_STATUS
,      PROCESSING_MESSAGE
,      PROCESSING_TIMESTAMP
,      PROCESSING_LOGFILE
,      OUT_MSGID
,      MSGID
FROM APPS.ECX_IN_PROCESS_VL;

Dependencies

[top of page]

APPS.ECX_IN_PROCESS_VL references the following:

SchemaAPPS
PL/SQL PackageECX_DEBUG - show dependent code
SynonymECX_DOCLOGS
SynonymECX_ERROR_MSGS
SynonymECX_EXT_PROCESSES
SynonymECX_INBOUND_LOGS
SynonymECX_STANDARDS
SynonymECX_TP_DETAILS
SynonymECX_TP_HEADERS
APPS.ECX_IN_PROCESS_VL is referenced by following:

SchemaAPPS
SynonymECX_IN_PROCESS_V