Product: | EC - e-Commerce Gateway |
---|---|
Description: | This view extracts advice detailsfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Details View@rep:category BUSINESS_ENTITY EC_APPLICATION |
Implementation/DBA Data: | APPS.ECE_ADVO_DETAILS_V |
SELECT ADVICE_DETAIL_ID
, ADVICE_HEADER_ID
, ADVO_DATE_TIME
, ADVO_STATUS_CODE
, EXTERNAL_REFERENCE1
, EXTERNAL_REFERENCE2
, EXTERNAL_REFERENCE3
, EXTERNAL_REFERENCE4
, EXTERNAL_REFERENCE5
, EXTERNAL_REFERENCE6
, INTERNAL_REFERENCE1
, INTERNAL_REFERENCE2
, INTERNAL_REFERENCE3
, INTERNAL_REFERENCE4
, INTERNAL_REFERENCE5
, INTERNAL_REFERENCE6
, ADVO_MESSAGE_CODE
, ADVO_MESSAGE_DESC
, ADVO_DATA_BAD
, ADVO_DATA_GOOD
FROM ECE_ADVO_DETAILS