VIEW: ONT.OE_CUSTOMER_INFO_IFACE_ALL#

Source

View Text - Preformatted

select CUSTOMER_INFO_REF CUSTOMER_INFO_REF, CURRENT_CUSTOMER_NUMBER CURRENT_CUSTOMER_NUMBER, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID, CUSTOMER_TYPE CUSTOMER_TYPE, CUSTOMER_INFO_TYPE_CODE CUSTOMER_INFO_TYPE_CODE, PARENT_CUSTOMER_REF PARENT_CUSTOMER_REF, ORGANIZATION_NAME ORGANIZATION_NAME, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX, PERSON_TITLE PERSON_TITLE, CUSTOMER_NUMBER CUSTOMER_NUMBER, EMAIL_ADDRESS EMAIL_ADDRESS, PARTY_NUMBER PARTY_NUMBER, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, PHONE_AREA_CODE PHONE_AREA_CODE, PHONE_NUMBER PHONE_NUMBER, PHONE_EXTENSION PHONE_EXTENSION, COUNTRY COUNTRY, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, POSTAL_CODE POSTAL_CODE, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, IS_SHIP_TO_ADDRESS IS_SHIP_TO_ADDRESS, IS_BILL_TO_ADDRESS IS_BILL_TO_ADDRESS, IS_DELIVER_TO_ADDRESS IS_DELIVER_TO_ADDRESS, SITE_NUMBER SITE_NUMBER, LOCATION_NUMBER LOCATION_NUMBER, NEW_PARTY_ID NEW_PARTY_ID, NEW_PARTY_NUMBER NEW_PARTY_NUMBER, NEW_ACCOUNT_ID NEW_ACCOUNT_ID, NEW_ACCOUNT_NUMBER NEW_ACCOUNT_NUMBER, NEW_CONTACT_ID NEW_CONTACT_ID, NEW_ADDRESS_ID_SHIP NEW_ADDRESS_ID_SHIP, NEW_ADDRESS_ID_BILL NEW_ADDRESS_ID_BILL, NEW_ADDRESS_ID_DELIVER NEW_ADDRESS_ID_DELIVER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, 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, 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, ERROR_FLAG ERROR_FLAG, REJECTED_FLAG REJECTED_FLAG, ORG_ID ORG_ID, IS_SOLD_TO_ADDRESS IS_SOLD_TO_ADDRESS, NEW_ADDRESS_ID_SOLD_TO NEW_ADDRESS_ID_SOLD_TO, INST_ID INST_ID from "ONT"."OE_CUSTOMER_INFO_IFACE_ALL"

View Text - HTML Formatted

SELECT CUSTOMER_INFO_REF CUSTOMER_INFO_REF
, CURRENT_CUSTOMER_NUMBER CURRENT_CUSTOMER_NUMBER
, CURRENT_CUSTOMER_ID CURRENT_CUSTOMER_ID
, CUSTOMER_TYPE CUSTOMER_TYPE
, CUSTOMER_INFO_TYPE_CODE CUSTOMER_INFO_TYPE_CODE
, PARENT_CUSTOMER_REF PARENT_CUSTOMER_REF
, ORGANIZATION_NAME ORGANIZATION_NAME
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, PERSON_TITLE PERSON_TITLE
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, EMAIL_ADDRESS EMAIL_ADDRESS
, PARTY_NUMBER PARTY_NUMBER
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, PHONE_AREA_CODE PHONE_AREA_CODE
, PHONE_NUMBER PHONE_NUMBER
, PHONE_EXTENSION PHONE_EXTENSION
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, IS_SHIP_TO_ADDRESS IS_SHIP_TO_ADDRESS
, IS_BILL_TO_ADDRESS IS_BILL_TO_ADDRESS
, IS_DELIVER_TO_ADDRESS IS_DELIVER_TO_ADDRESS
, SITE_NUMBER SITE_NUMBER
, LOCATION_NUMBER LOCATION_NUMBER
, NEW_PARTY_ID NEW_PARTY_ID
, NEW_PARTY_NUMBER NEW_PARTY_NUMBER
, NEW_ACCOUNT_ID NEW_ACCOUNT_ID
, NEW_ACCOUNT_NUMBER NEW_ACCOUNT_NUMBER
, NEW_CONTACT_ID NEW_CONTACT_ID
, NEW_ADDRESS_ID_SHIP NEW_ADDRESS_ID_SHIP
, NEW_ADDRESS_ID_BILL NEW_ADDRESS_ID_BILL
, NEW_ADDRESS_ID_DELIVER NEW_ADDRESS_ID_DELIVER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, 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
, 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
, ERROR_FLAG ERROR_FLAG
, REJECTED_FLAG REJECTED_FLAG
, ORG_ID ORG_ID
, IS_SOLD_TO_ADDRESS IS_SOLD_TO_ADDRESS
, NEW_ADDRESS_ID_SOLD_TO NEW_ADDRESS_ID_SOLD_TO
, INST_ID INST_ID
FROM "ONT"."OE_CUSTOMER_INFO_IFACE_ALL"