VIEW: APPS.ECX_IN_PROCESS_VL

Source

View Text - Preformatted

SELECT int.trigger_id,
    doc.document_number document_id,
    doc.transaction_type,
    doc.transaction_subtype,
    tpsetup.party_id,
    tpsetup.party_site_id,
    tpsetup.party_type,
    tpsetup.source_tp_location_code,
    doc.internal_control_number,
    int.status processing_status,
    ecx_debug.getMessage(err.message, err.message_parameters) processing_message,
    int.time_stamp processing_timestamp,
    int.logfile processing_logfile,
    doc.out_msgid,
    doc.msgid
  FROM ecx_doclogs doc,
    ecx_inbound_logs INT,
    ecx_error_msgs err,
    (SELECT eep.ext_type,
      eep.ext_subtype,
      etd.source_tp_location_code,
      es.standard_code,
      es.standard_type,
      eth.party_id,
      eth.party_site_id,
      eth.party_type
    FROM ecx_ext_processes eep,
      ecx_standards es,
      ecx_tp_details etd,
      ecx_tp_headers eth
    WHERE eep.direction    = 'IN'
    AND eep.standard_id    = es.standard_id
    AND etd.ext_process_id = eep.ext_process_id
    AND etd.tp_header_id   = eth.tp_header_id
    ) tpsetup
  WHERE int.error_id          = err.error_id(+)
  AND doc.msgid               = int.msgid(+)
  AND doc.direction           = 'IN'
  AND doc.transaction_type    = tpsetup.ext_type(+)
  AND doc.transaction_subtype = tpsetup.ext_subtype(+)
  AND doc.party_site_id       = tpsetup.source_tp_location_code(+)
  AND doc.message_type        = tpsetup.standard_type(+)
  AND doc.message_standard    = tpsetup.standard_code(+)

View Text - HTML Formatted

SELECT INT.TRIGGER_ID
, DOC.DOCUMENT_NUMBER DOCUMENT_ID
, DOC.TRANSACTION_TYPE
, DOC.TRANSACTION_SUBTYPE
, TPSETUP.PARTY_ID
, TPSETUP.PARTY_SITE_ID
, TPSETUP.PARTY_TYPE
, TPSETUP.SOURCE_TP_LOCATION_CODE
, DOC.INTERNAL_CONTROL_NUMBER
, INT.STATUS PROCESSING_STATUS
, ECX_DEBUG.GETMESSAGE(ERR.MESSAGE
, ERR.MESSAGE_PARAMETERS) PROCESSING_MESSAGE
, INT.TIME_STAMP PROCESSING_TIMESTAMP
, INT.LOGFILE PROCESSING_LOGFILE
, DOC.OUT_MSGID
, DOC.MSGID
FROM ECX_DOCLOGS DOC
, ECX_INBOUND_LOGS INT
, ECX_ERROR_MSGS ERR
, (SELECT EEP.EXT_TYPE
, EEP.EXT_SUBTYPE
, ETD.SOURCE_TP_LOCATION_CODE
, ES.STANDARD_CODE
, ES.STANDARD_TYPE
, ETH.PARTY_ID
, ETH.PARTY_SITE_ID
, ETH.PARTY_TYPE
FROM ECX_EXT_PROCESSES EEP
, ECX_STANDARDS ES
, ECX_TP_DETAILS ETD
, ECX_TP_HEADERS ETH
WHERE EEP.DIRECTION = 'IN'
AND EEP.STANDARD_ID = ES.STANDARD_ID
AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID
AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID ) TPSETUP
WHERE INT.ERROR_ID = ERR.ERROR_ID(+)
AND DOC.MSGID = INT.MSGID(+)
AND DOC.DIRECTION = 'IN'
AND DOC.TRANSACTION_TYPE = TPSETUP.EXT_TYPE(+)
AND DOC.TRANSACTION_SUBTYPE = TPSETUP.EXT_SUBTYPE(+)
AND DOC.PARTY_SITE_ID = TPSETUP.SOURCE_TP_LOCATION_CODE(+)
AND DOC.MESSAGE_TYPE = TPSETUP.STANDARD_TYPE(+)
AND DOC.MESSAGE_STANDARD = TPSETUP.STANDARD_CODE(+)