FND Design Data [Home] [Help]

View: ECE_ADVO_DETAILS_V

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: ViewAPPS.ECE_ADVO_DETAILS_V
View Text

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

Columns

Name
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