VIEW: MSC.MSC_ST_TRADING_PARTNER_SITES#

Source

View Text - Preformatted

select PARTNER_ID PARTNER_ID, PARTNER_SITE_ID PARTNER_SITE_ID, PARTNER_ADDRESS PARTNER_ADDRESS, SR_TP_ID SR_TP_ID, SR_TP_SITE_ID SR_TP_SITE_ID, TP_SITE_CODE TP_SITE_CODE, LOCATION LOCATION, PARTNER_TYPE PARTNER_TYPE, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, LONGITUDE LONGITUDE, LATITUDE LATITUDE, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, PARTNER_NAME PARTNER_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, ERROR_TEXT ERROR_TEXT, COUNTRY COUNTRY, STATE STATE, CITY CITY, POSTAL_CODE POSTAL_CODE, ORGANIZATION_CODE ORGANIZATION_CODE, PARTNER_SITE_NUMBER PARTNER_SITE_NUMBER, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, PROVINCE PROVINCE, COUNTY COUNTY, OPERATING_UNIT OPERATING_UNIT, LOCATION_ID LOCATION_ID, SHIPPING_CONTROL SHIPPING_CONTROL, SOURCE_SR_TP_ID SOURCE_SR_TP_ID, SOURCE_SR_TP_SITE_ID SOURCE_SR_TP_SITE_ID, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER from "MSC"."MSC_ST_TRADING_PARTNER_SITES"

View Text - HTML Formatted

SELECT PARTNER_ID PARTNER_ID
, PARTNER_SITE_ID PARTNER_SITE_ID
, PARTNER_ADDRESS PARTNER_ADDRESS
, SR_TP_ID SR_TP_ID
, SR_TP_SITE_ID SR_TP_SITE_ID
, TP_SITE_CODE TP_SITE_CODE
, LOCATION LOCATION
, PARTNER_TYPE PARTNER_TYPE
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, LONGITUDE LONGITUDE
, LATITUDE LATITUDE
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, PARTNER_NAME PARTNER_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, ERROR_TEXT ERROR_TEXT
, COUNTRY COUNTRY
, STATE STATE
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, ORGANIZATION_CODE ORGANIZATION_CODE
, PARTNER_SITE_NUMBER PARTNER_SITE_NUMBER
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, PROVINCE PROVINCE
, COUNTY COUNTY
, OPERATING_UNIT OPERATING_UNIT
, LOCATION_ID LOCATION_ID
, SHIPPING_CONTROL SHIPPING_CONTROL
, SOURCE_SR_TP_ID SOURCE_SR_TP_ID
, SOURCE_SR_TP_SITE_ID SOURCE_SR_TP_SITE_ID
, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
FROM "MSC"."MSC_ST_TRADING_PARTNER_SITES"