View: XDP_INBOUND_MESSAGES_V

Product:	XDP - Provisioning
Description:	This View shows the information on all the Inbound Messages.
Implementation/DBA Data:	APPS.XDP_INBOUND_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
, M.ADAPTER_NAME
, LK.MEANING
, M.RETRIES
, M.SEND_RCV_DATE
, FE.DISPLAY_NAME
, M.CREATION_DATE
, M.DIRECTION_INDICATOR
FROM XNP_MSGS M
, XNP_IN_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