VIEW: WSH.WSH_CC_TRANS_HEADERS#

Source

View Text - Preformatted

select TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, TRANSACTION_CONTROL_ID TRANSACTION_CONTROL_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, SF_COUNTRY SF_COUNTRY, ST_COUNTRY ST_COUNTRY, SF_PARTY_NAME SF_PARTY_NAME, SF_PARTY_ADDRESS SF_PARTY_ADDRESS, SF_PARTY_CITY SF_PARTY_CITY, SF_PARTY_STATE SF_PARTY_STATE, SF_PARTY_COUNTRY SF_PARTY_COUNTRY, SF_POSTAL_CODE SF_POSTAL_CODE, ST_PARTY_NAME ST_PARTY_NAME, ST_PARTY_ADDRESS ST_PARTY_ADDRESS, ST_PARTY_CITY ST_PARTY_CITY, ST_PARTY_STATE ST_PARTY_STATE, ST_PARTY_COUNTRY ST_PARTY_COUNTRY, ST_POSTAL_CODE ST_POSTAL_CODE, IT_PARTY_NAME IT_PARTY_NAME, IT_PARTY_ADDRESS IT_PARTY_ADDRESS, IT_PARTY_CITY IT_PARTY_CITY, IT_PARTY_STATE IT_PARTY_STATE, IT_PARTY_COUNTRY IT_PARTY_COUNTRY, IT_POSTAL_CODE IT_POSTAL_CODE, CUST_PARTY_NAME CUST_PARTY_NAME, CUST_PARTY_COUNTRY CUST_PARTY_COUNTRY, WF_ITEM_KEY WF_ITEM_KEY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SF_CONTACT_NAME SF_CONTACT_NAME, SF_PHONE SF_PHONE, SF_EMAIL SF_EMAIL, SF_FAX SF_FAX, ST_CONTACT_NAME ST_CONTACT_NAME, ST_PHONE ST_PHONE, ST_EMAIL ST_EMAIL, ST_FAX ST_FAX, IT_CONTACT_NAME IT_CONTACT_NAME, IT_PHONE IT_PHONE, IT_EMAIL IT_EMAIL, IT_FAX IT_FAX, CUST_PARTY_ADDRESS CUST_PARTY_ADDRESS, CUST_PARTY_CITY CUST_PARTY_CITY, CUST_PARTY_STATE CUST_PARTY_STATE, CUST_POSTAL_CODE CUST_POSTAL_CODE, CUST_CONTACT_NAME CUST_CONTACT_NAME, CUST_PHONE CUST_PHONE, CUST_EMAIL CUST_EMAIL, CUST_FAX CUST_FAX, 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, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, DT_PARTY_NAME DT_PARTY_NAME, DT_PARTY_ADDRESS DT_PARTY_ADDRESS, DT_PARTY_CITY DT_PARTY_CITY, DT_PARTY_STATE DT_PARTY_STATE, DT_PARTY_COUNTRY DT_PARTY_COUNTRY, DT_POSTAL_CODE DT_POSTAL_CODE, DT_CONTACT_NAME DT_CONTACT_NAME, DT_PHONE DT_PHONE, DT_EMAIL DT_EMAIL, DT_FAX DT_FAX from "WSH"."WSH_CC_TRANS_HEADERS"

View Text - HTML Formatted

SELECT TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TRANSACTION_CONTROL_ID TRANSACTION_CONTROL_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, SF_COUNTRY SF_COUNTRY
, ST_COUNTRY ST_COUNTRY
, SF_PARTY_NAME SF_PARTY_NAME
, SF_PARTY_ADDRESS SF_PARTY_ADDRESS
, SF_PARTY_CITY SF_PARTY_CITY
, SF_PARTY_STATE SF_PARTY_STATE
, SF_PARTY_COUNTRY SF_PARTY_COUNTRY
, SF_POSTAL_CODE SF_POSTAL_CODE
, ST_PARTY_NAME ST_PARTY_NAME
, ST_PARTY_ADDRESS ST_PARTY_ADDRESS
, ST_PARTY_CITY ST_PARTY_CITY
, ST_PARTY_STATE ST_PARTY_STATE
, ST_PARTY_COUNTRY ST_PARTY_COUNTRY
, ST_POSTAL_CODE ST_POSTAL_CODE
, IT_PARTY_NAME IT_PARTY_NAME
, IT_PARTY_ADDRESS IT_PARTY_ADDRESS
, IT_PARTY_CITY IT_PARTY_CITY
, IT_PARTY_STATE IT_PARTY_STATE
, IT_PARTY_COUNTRY IT_PARTY_COUNTRY
, IT_POSTAL_CODE IT_POSTAL_CODE
, CUST_PARTY_NAME CUST_PARTY_NAME
, CUST_PARTY_COUNTRY CUST_PARTY_COUNTRY
, WF_ITEM_KEY WF_ITEM_KEY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SF_CONTACT_NAME SF_CONTACT_NAME
, SF_PHONE SF_PHONE
, SF_EMAIL SF_EMAIL
, SF_FAX SF_FAX
, ST_CONTACT_NAME ST_CONTACT_NAME
, ST_PHONE ST_PHONE
, ST_EMAIL ST_EMAIL
, ST_FAX ST_FAX
, IT_CONTACT_NAME IT_CONTACT_NAME
, IT_PHONE IT_PHONE
, IT_EMAIL IT_EMAIL
, IT_FAX IT_FAX
, CUST_PARTY_ADDRESS CUST_PARTY_ADDRESS
, CUST_PARTY_CITY CUST_PARTY_CITY
, CUST_PARTY_STATE CUST_PARTY_STATE
, CUST_POSTAL_CODE CUST_POSTAL_CODE
, CUST_CONTACT_NAME CUST_CONTACT_NAME
, CUST_PHONE CUST_PHONE
, CUST_EMAIL CUST_EMAIL
, CUST_FAX CUST_FAX
, 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
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, DT_PARTY_NAME DT_PARTY_NAME
, DT_PARTY_ADDRESS DT_PARTY_ADDRESS
, DT_PARTY_CITY DT_PARTY_CITY
, DT_PARTY_STATE DT_PARTY_STATE
, DT_PARTY_COUNTRY DT_PARTY_COUNTRY
, DT_POSTAL_CODE DT_POSTAL_CODE
, DT_CONTACT_NAME DT_CONTACT_NAME
, DT_PHONE DT_PHONE
, DT_EMAIL DT_EMAIL
, DT_FAX DT_FAX
FROM "WSH"."WSH_CC_TRANS_HEADERS"