eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: EC.ECE_ADVO_DETAILS_INTERFACE#

Source

View Text - Preformatted


select RUN_ID RUN_ID, ADVICE_DETAIL_ID ADVICE_DETAIL_ID, ADVICE_HEADER_ID ADVICE_HEADER_ID, ADVO_DATE_TIME ADVO_DATE_TIME, ADVO_STATUS_CODE ADVO_STATUS_CODE, EXTERNAL_REFERENCE1 EXTERNAL_REFERENCE1, EXTERNAL_REFERENCE2 EXTERNAL_REFERENCE2, EXTERNAL_REFERENCE3 EXTERNAL_REFERENCE3, EXTERNAL_REFERENCE4 EXTERNAL_REFERENCE4, EXTERNAL_REFERENCE5 EXTERNAL_REFERENCE5, EXTERNAL_REFERENCE6 EXTERNAL_REFERENCE6, INTERNAL_REFERENCE1 INTERNAL_REFERENCE1, INTERNAL_REFERENCE2 INTERNAL_REFERENCE2, INTERNAL_REFERENCE3 INTERNAL_REFERENCE3, INTERNAL_REFERENCE4 INTERNAL_REFERENCE4, INTERNAL_REFERENCE5 INTERNAL_REFERENCE5, INTERNAL_REFERENCE6 INTERNAL_REFERENCE6, ADVO_MESSAGE_CODE ADVO_MESSAGE_CODE, ADVO_MESSAGE_DESC ADVO_MESSAGE_DESC, ADVO_DATA_BAD ADVO_DATA_BAD, ADVO_DATA_GOOD ADVO_DATA_GOOD, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_ADVO_DETAILS_INTERFACE"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, ADVICE_DETAIL_ID ADVICE_DETAIL_ID
, ADVICE_HEADER_ID ADVICE_HEADER_ID
, ADVO_DATE_TIME ADVO_DATE_TIME
, ADVO_STATUS_CODE ADVO_STATUS_CODE
, EXTERNAL_REFERENCE1 EXTERNAL_REFERENCE1
, EXTERNAL_REFERENCE2 EXTERNAL_REFERENCE2
, EXTERNAL_REFERENCE3 EXTERNAL_REFERENCE3
, EXTERNAL_REFERENCE4 EXTERNAL_REFERENCE4
, EXTERNAL_REFERENCE5 EXTERNAL_REFERENCE5
, EXTERNAL_REFERENCE6 EXTERNAL_REFERENCE6
, INTERNAL_REFERENCE1 INTERNAL_REFERENCE1
, INTERNAL_REFERENCE2 INTERNAL_REFERENCE2
, INTERNAL_REFERENCE3 INTERNAL_REFERENCE3
, INTERNAL_REFERENCE4 INTERNAL_REFERENCE4
, INTERNAL_REFERENCE5 INTERNAL_REFERENCE5
, INTERNAL_REFERENCE6 INTERNAL_REFERENCE6
, ADVO_MESSAGE_CODE ADVO_MESSAGE_CODE
, ADVO_MESSAGE_DESC ADVO_MESSAGE_DESC
, ADVO_DATA_BAD ADVO_DATA_BAD
, ADVO_DATA_GOOD ADVO_DATA_GOOD
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_ADVO_DETAILS_INTERFACE"