View: ECE_ADVO_HEADERS_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A
Implementation/DBA Data:	APPS.ECE_ADVO_HEADERS_V

View Text

SELECT EAH.ADVICE_HEADER_ID ADVICE_HEADER_ID
, EAH.COMMUNICATION_METHOD COMMUNICATION_METHOD
, ETD.TEST_FLAG TP_TEST_FLAG
, 'ADVO' TP_DOCUMENT_ID
, EAH.DOCUMENT_TYPE DOCUMENT_TYPE
, EAH.DOCUMENT_CODE DOCUMENT_CODE
, EAH.TP_ENTITY_TYPE TP_ENTITY_TYPE
, EAH.TP_HEADER_ID TP_HEADER_ID
, ETD.TRANSLATOR_CODE TP_TRANSLATOR_CODE
, EAH.TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, ETH.TP_DESCRIPTION TP_DESCRIPTION
, ETH.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETH.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, EAH.TRANSACTION_DATE TRANSACTION_DATE
, EAH.TRANSACTION_CONTROL1 TRANSACTION_CONTROL1
, EAH.TRANSACTION_CONTROL2 TRANSACTION_CONTROL2
, EAH.TRANSACTION_CONTROL3 TRANSACTION_CONTROL3
, ETH.ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, ETH.ATTRIBUTE1 TPH_ATTRIBUTE1
, ETH.ATTRIBUTE2 TPH_ATTRIBUTE2
, ETH.ATTRIBUTE3 TPH_ATTRIBUTE3
, ETH.ATTRIBUTE4 TPH_ATTRIBUTE4
, ETH.ATTRIBUTE5 TPH_ATTRIBUTE5
, ETH.ATTRIBUTE6 TPH_ATTRIBUTE6
, ETH.ATTRIBUTE7 TPH_ATTRIBUTE7
, ETH.ATTRIBUTE8 TPH_ATTRIBUTE8
, ETH.ATTRIBUTE9 TPH_ATTRIBUTE9
, ETH.ATTRIBUTE10 TPH_ATTRIBUTE10
, ETH.ATTRIBUTE11 TPH_ATTRIBUTE11
, ETH.ATTRIBUTE12 TPH_ATTRIBUTE12
, ETH.ATTRIBUTE13 TPH_ATTRIBUTE13
, ETH.ATTRIBUTE14 TPH_ATTRIBUTE14
, ETH.ATTRIBUTE15 TPH_ATTRIBUTE15
, EAH.RELATED_DOCUMENT_ID RELATED_DOCUMENT_ID
, EAH.EXTERNAL_REFERENCE1 EXTERNAL_REFERENCE1
, EAH.EXTERNAL_REFERENCE2 EXTERNAL_REFERENCE2
, EAH.EXTERNAL_REFERENCE3 EXTERNAL_REFERENCE3
, EAH.EXTERNAL_REFERENCE4 EXTERNAL_REFERENCE4
, EAH.EXTERNAL_REFERENCE5 EXTERNAL_REFERENCE5
, EAH.EXTERNAL_REFERENCE6 EXTERNAL_REFERENCE6
, EAH.INTERNAL_REFERENCE1 INTERNAL_REFERENCE1
, EAH.INTERNAL_REFERENCE2 INTERNAL_REFERENCE2
, EAH.INTERNAL_REFERENCE3 INTERNAL_REFERENCE3
, EAH.INTERNAL_REFERENCE4 INTERNAL_REFERENCE4
, EAH.INTERNAL_REFERENCE5 INTERNAL_REFERENCE5
, EAH.INTERNAL_REFERENCE6 INTERNAL_REFERENCE6
, EAH.TP_CODE TP_CODE_INTERNAL
, EAH.TP_NAME TP_NAME
, EAH.TP_ADDRESS1 TP_ADDRESS1
, EAH.TP_ADDRESS2 TP_ADDRESS2
, EAH.TP_ADDRESS3 TP_ADDRESS3
, EAH.TP_ADDRESS4 TP_ADDRESS4
, EAH.TP_CITY TP_CITY
, EAH.TP_POSTAL_CODE TP_POSTAL_CODE
, EAH.TP_COUNTRY TP_COUNTRY_INT
, EAH.TP_STATE TP_STATE_INT
, EAH.TP_PROVINCE TP_PROVINCE_INT
, EAH.TP_COUNTY TP_COUNTY_INT
, ETG.TP_GROUP_CODE TP_GROUP_CODE
, ETD.DOCUMENT_STANDARD DOCUMENT_STANDARD
, ETD.MAP_ID MAP_ID
FROM ECE_TP_GROUP ETG
, ECE_TP_DETAILS ETD
, ECE_TP_HEADERS ETH
, ECE_ADVO_HEADERS EAH
WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
AND EAH.TP_HEADER_ID = ETH.TP_HEADER_ID
AND EAH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETD.EDI_FLAG = 'Y'
AND ETD.DOCUMENT_ID = 'ADVO'
AND NVL(EAH.EDI_PROCESSED_FLAG
, 'N') = 'N'

Columns