VIEW: APPS.XDP_INBOUND_MESSAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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