[Home] [Help]
View: XDP_OUTBOUND_MESSAGES_V
Product: | XDP - Provisioning |
Description: | This View shows the information on all the Outbound Messages. |
Implementation/DBA Data: |
APPS.XDP_OUTBOUND_MESSAGES_V
|
View Text
SELECT M.MSG_ID
, M.MSG_CODE
, M.MSG_VERSION
, M.ORDER_ID
, M.REFERENCE_ID
, M.OPP_REFERENCE_ID
, M.SENDER_NAME
, M.RECIPIENT_NAME
, M.FE_NAME
, Q.USER_DATA
, M.ADAPTER_NAME
, LK.MEANING STATUS
, M.RETRIES
, M.SEND_RCV_DATE
, FE.DISPLAY_NAME FE_DISPLAY
, M.CREATION_DATE
FROM XNP_MSGS M
, XNP_OUT_MSG_QTAB Q
, XDP_FES_VL FE
, FND_LOOKUPS LK
WHERE M.MSG_ID = XDP_SYSCN_UTIL.FGET_MESSAGE_ID(Q.USER_DATA)
AND LK.LOOKUP_TYPE = 'XNP_MSG_STATUS'
AND LK.LOOKUP_CODE = M.MSG_STATUS
AND FE.FULFILLMENT_ELEMENT_NAME(+) = M.FE_NAME
Columns
Name |
MSG_ID |
CODE |
VERSION |
INTERNAL_ORDER_ID |
REFERENCE_ID |
OPP_REFERENCE_ID |
SENDER |
RECIPIENT |
FE |
USER_DATA |
ADAPTER |
STATUS |
RETRIES |
SEND_RCV_DATE |
FE_DISPLAY |
CREATION_DATE |