VIEW: WSH.WSH_CC_TRANS_LINES#

Source

View Text - Preformatted

select TRANSACTION_LINE_ID TRANSACTION_LINE_ID, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_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, INT_PARTY_NAME INT_PARTY_NAME, INT_PARTY_ADDRESS INT_PARTY_ADDRESS, INT_PARTY_CITY INT_PARTY_CITY, INT_PARTY_STATE INT_PARTY_STATE, INT_PARTY_COUNTRY INT_PARTY_COUNTRY, INT_POSTAL_CODE INT_POSTAL_CODE, PR_LOOKUP PR_LOOKUP, PR_PRODUCT_ID PR_PRODUCT_ID, PR_END_USE_TYPE PR_END_USE_TYPE, PR_CLASSIFIER_TYPE PR_CLASSIFIER_TYPE, PR_CLASSIFIER_LABEL PR_CLASSIFIER_LABEL, PR_CLASSIFICATION_TYPE PR_CLASSIFICATION_TYPE, PR_CLASSIFICATION_LABEL PR_CLASSIFICATION_LABEL, PR_ENC_MASSMARKET PR_ENC_MASSMARKET, PR_ENC_PUBLIC PR_ENC_PUBLIC, PR_ENC_TYPE PR_ENC_TYPE, LICENSE_EXCEPTION LICENSE_EXCEPTION, LICENSE_EXCEPTION_TYPE LICENSE_EXCEPTION_TYPE, LICENSE_VALID_FR_DT_VALUE LICENSE_VALID_FR_DT_VALUE, LICENSE_VALID_TO_DT_VALUE LICENSE_VALID_TO_DT_VALUE, 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, INT_CONTACT_NAME INT_CONTACT_NAME, INT_PHONE INT_PHONE, INT_EMAIL INT_EMAIL, INT_FAX INT_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, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, 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, 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, IT_CONTACT_NAME IT_CONTACT_NAME, IT_PHONE IT_PHONE, IT_EMAIL IT_EMAIL, IT_FAX IT_FAX from "WSH"."WSH_CC_TRANS_LINES"

View Text - HTML Formatted

SELECT TRANSACTION_LINE_ID TRANSACTION_LINE_ID
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_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
, INT_PARTY_NAME INT_PARTY_NAME
, INT_PARTY_ADDRESS INT_PARTY_ADDRESS
, INT_PARTY_CITY INT_PARTY_CITY
, INT_PARTY_STATE INT_PARTY_STATE
, INT_PARTY_COUNTRY INT_PARTY_COUNTRY
, INT_POSTAL_CODE INT_POSTAL_CODE
, PR_LOOKUP PR_LOOKUP
, PR_PRODUCT_ID PR_PRODUCT_ID
, PR_END_USE_TYPE PR_END_USE_TYPE
, PR_CLASSIFIER_TYPE PR_CLASSIFIER_TYPE
, PR_CLASSIFIER_LABEL PR_CLASSIFIER_LABEL
, PR_CLASSIFICATION_TYPE PR_CLASSIFICATION_TYPE
, PR_CLASSIFICATION_LABEL PR_CLASSIFICATION_LABEL
, PR_ENC_MASSMARKET PR_ENC_MASSMARKET
, PR_ENC_PUBLIC PR_ENC_PUBLIC
, PR_ENC_TYPE PR_ENC_TYPE
, LICENSE_EXCEPTION LICENSE_EXCEPTION
, LICENSE_EXCEPTION_TYPE LICENSE_EXCEPTION_TYPE
, LICENSE_VALID_FR_DT_VALUE LICENSE_VALID_FR_DT_VALUE
, LICENSE_VALID_TO_DT_VALUE LICENSE_VALID_TO_DT_VALUE
, 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
, INT_CONTACT_NAME INT_CONTACT_NAME
, INT_PHONE INT_PHONE
, INT_EMAIL INT_EMAIL
, INT_FAX INT_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
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, 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
, 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
, IT_CONTACT_NAME IT_CONTACT_NAME
, IT_PHONE IT_PHONE
, IT_EMAIL IT_EMAIL
, IT_FAX IT_FAX
FROM "WSH"."WSH_CC_TRANS_LINES"