VIEW: EC.ECE_ADVO_HEADERS_INTERFACE#

Source

View Text - Preformatted

select ADVICE_HEADER_ID ADVICE_HEADER_ID, COMMUNICATION_METHOD COMMUNICATION_METHOD, TP_TEST_FLAG TP_TEST_FLAG, TP_DOCUMENT_ID TP_DOCUMENT_ID, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_CODE DOCUMENT_CODE, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE, TP_ENTITY_TYPE TP_ENTITY_TYPE, TP_TRANSLATOR_CODE TP_TRANSLATOR_CODE, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT, TP_DESCRIPTION TP_DESCRIPTION, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2, TRANSACTION_DATE TRANSACTION_DATE, RUN_ID RUN_ID, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15, RELATED_DOCUMENT_ID RELATED_DOCUMENT_ID, 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, TP_CODE_INTERNAL TP_CODE_INTERNAL, TP_CODE_EXTERNAL TP_CODE_EXTERNAL, TP_NAME TP_NAME, TP_ADDRESS1 TP_ADDRESS1, TP_ADDRESS2 TP_ADDRESS2, TP_ADDRESS3 TP_ADDRESS3, TP_ADDRESS4 TP_ADDRESS4, TP_CITY TP_CITY, TP_POSTAL_CODE TP_POSTAL_CODE, TP_COUNTRY_INT TP_COUNTRY_INT, TP_COUNTRY_EXT TP_COUNTRY_EXT, TP_STATE_INT TP_STATE_INT, TP_STATE_EXT TP_STATE_EXT, TP_PROVINCE_INT TP_PROVINCE_INT, TP_PROVINCE_EXT TP_PROVINCE_EXT, TP_COUNTY_INT TP_COUNTY_INT, 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, DOCUMENT_STANDARD DOCUMENT_STANDARD, MAP_ID MAP_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_ADVO_HEADERS_INTERFACE"

View Text - HTML Formatted

SELECT ADVICE_HEADER_ID ADVICE_HEADER_ID
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, TP_TEST_FLAG TP_TEST_FLAG
, TP_DOCUMENT_ID TP_DOCUMENT_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_CODE DOCUMENT_CODE
, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE
, TP_ENTITY_TYPE TP_ENTITY_TYPE
, TP_TRANSLATOR_CODE TP_TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, TP_DESCRIPTION TP_DESCRIPTION
, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, TRANSACTION_DATE TRANSACTION_DATE
, RUN_ID RUN_ID
, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3
, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15
, RELATED_DOCUMENT_ID RELATED_DOCUMENT_ID
, 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
, TP_CODE_INTERNAL TP_CODE_INTERNAL
, TP_CODE_EXTERNAL TP_CODE_EXTERNAL
, TP_NAME TP_NAME
, TP_ADDRESS1 TP_ADDRESS1
, TP_ADDRESS2 TP_ADDRESS2
, TP_ADDRESS3 TP_ADDRESS3
, TP_ADDRESS4 TP_ADDRESS4
, TP_CITY TP_CITY
, TP_POSTAL_CODE TP_POSTAL_CODE
, TP_COUNTRY_INT TP_COUNTRY_INT
, TP_COUNTRY_EXT TP_COUNTRY_EXT
, TP_STATE_INT TP_STATE_INT
, TP_STATE_EXT TP_STATE_EXT
, TP_PROVINCE_INT TP_PROVINCE_INT
, TP_PROVINCE_EXT TP_PROVINCE_EXT
, TP_COUNTY_INT TP_COUNTY_INT
, 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
, DOCUMENT_STANDARD DOCUMENT_STANDARD
, MAP_ID MAP_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_ADVO_HEADERS_INTERFACE"