VIEW: EC.ECE_ADVO_HEADERS#

Source

View Text - Preformatted

select ADVICE_HEADER_ID ADVICE_HEADER_ID, TP_HEADER_ID TP_HEADER_ID, COMMUNICATION_METHOD COMMUNICATION_METHOD, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_CODE DOCUMENT_CODE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG, EDI_PROCESS_DATE EDI_PROCESS_DATE, 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_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT, TP_ENTITY_TYPE TP_ENTITY_TYPE, TP_CODE TP_CODE, 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 TP_COUNTRY, TP_STATE TP_STATE, TP_PROVINCE TP_PROVINCE, TP_COUNTY TP_COUNTY, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_ADVO_HEADERS"

View Text - HTML Formatted

SELECT ADVICE_HEADER_ID ADVICE_HEADER_ID
, TP_HEADER_ID TP_HEADER_ID
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_CODE DOCUMENT_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3
, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG
, EDI_PROCESS_DATE EDI_PROCESS_DATE
, 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_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, TP_ENTITY_TYPE TP_ENTITY_TYPE
, TP_CODE TP_CODE
, 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 TP_COUNTRY
, TP_STATE TP_STATE
, TP_PROVINCE TP_PROVINCE
, TP_COUNTY TP_COUNTY
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_ADVO_HEADERS"