VIEW: AR.RA_ADDRESSES_ALL#

Source

View Text - Preformatted

select ADDRESS_ID ADDRESS_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CUSTOMER_ID CUSTOMER_ID, STATUS STATUS, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORG_ID ORG_ID, COUNTRY COUNTRY, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, POSTAL_CODE POSTAL_CODE, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TERRITORY_ID TERRITORY_ID, ADDRESS_KEY ADDRESS_KEY, BILL_TO_FLAG BILL_TO_FLAG, MARKET_FLAG MARKET_FLAG, SHIP_TO_FLAG SHIP_TO_FLAG, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LOCATION_ID LOCATION_ID, SERVICE_TERRITORY_ID SERVICE_TERRITORY_ID, PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID, SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE, CUSTOMER_GROUP_CODE CUSTOMER_GROUP_CODE, CUSTOMER_SUBGROUP_CODE CUSTOMER_SUBGROUP_CODE, REFERENCE_USE_FLAG REFERENCE_USE_FLAG, ANALYSIS_FY ANALYSIS_FY, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH, NET_WORTH NET_WORTH, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES, POTENTIAL_REVENUE_CURR_FY POTENTIAL_REVENUE_CURR_FY, POTENTIAL_REVENUE_NEXT_FY POTENTIAL_REVENUE_NEXT_FY, RANK RANK, COMPETITOR_FLAG COMPETITOR_FLAG, THIRD_PARTY_FLAG THIRD_PARTY_FLAG, YEAR_ESTABLISHED YEAR_ESTABLISHED, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG, ADDRESS_STYLE ADDRESS_STYLE, LANGUAGE LANGUAGE, KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG, TP_HEADER_ID TP_HEADER_ID, WH_UPDATE_DATE WH_UPDATE_DATE, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE, SALES_TAX_GEOCODE SALES_TAX_GEOCODE, SALES_TAX_INSIDE_CITY_LIMITS SALES_TAX_INSIDE_CITY_LIMITS, TERRITORY TERRITORY, TRANSLATED_CUSTOMER_NAME TRANSLATED_CUSTOMER_NAME, ADDRESS_TEXT ADDRESS_TEXT from "AR"."RA_ADDRESSES_ALL"

View Text - HTML Formatted

SELECT ADDRESS_ID ADDRESS_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CUSTOMER_ID CUSTOMER_ID
, STATUS STATUS
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORG_ID ORG_ID
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TERRITORY_ID TERRITORY_ID
, ADDRESS_KEY ADDRESS_KEY
, BILL_TO_FLAG BILL_TO_FLAG
, MARKET_FLAG MARKET_FLAG
, SHIP_TO_FLAG SHIP_TO_FLAG
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LOCATION_ID LOCATION_ID
, SERVICE_TERRITORY_ID SERVICE_TERRITORY_ID
, PRIMARY_SPECIALIST_ID PRIMARY_SPECIALIST_ID
, SECONDARY_SPECIALIST_ID SECONDARY_SPECIALIST_ID
, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, CUSTOMER_GROUP_CODE CUSTOMER_GROUP_CODE
, CUSTOMER_SUBGROUP_CODE CUSTOMER_SUBGROUP_CODE
, REFERENCE_USE_FLAG REFERENCE_USE_FLAG
, ANALYSIS_FY ANALYSIS_FY
, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH
, NET_WORTH NET_WORTH
, NUM_OF_EMPLOYEES NUM_OF_EMPLOYEES
, POTENTIAL_REVENUE_CURR_FY POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY POTENTIAL_REVENUE_NEXT_FY
, RANK RANK
, COMPETITOR_FLAG COMPETITOR_FLAG
, THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, DO_NOT_MAIL_FLAG DO_NOT_MAIL_FLAG
, ADDRESS_STYLE ADDRESS_STYLE
, LANGUAGE LANGUAGE
, KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG
, TP_HEADER_ID TP_HEADER_ID
, WH_UPDATE_DATE WH_UPDATE_DATE
, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE
, SALES_TAX_GEOCODE SALES_TAX_GEOCODE
, SALES_TAX_INSIDE_CITY_LIMITS SALES_TAX_INSIDE_CITY_LIMITS
, TERRITORY TERRITORY
, TRANSLATED_CUSTOMER_NAME TRANSLATED_CUSTOMER_NAME
, ADDRESS_TEXT ADDRESS_TEXT
FROM "AR"."RA_ADDRESSES_ALL"