VIEW: APPS.ECE_ADVO_HEADERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'