Product: | ICX - Oracle iProcurement |
---|---|
Description: | Customer View |
Implementation/DBA Data: | Not implemented in this database |
SELECT "CUSTOMER_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATION_DATE"
, "CREATED_BY"
, "CUSTOMER_NAME"
, "CUSTOMER_NUMBER"
, "ORIG_SYSTEM_REFERENCE"
, "STATUS"
, "LAST_UPDATE_LOGIN"
, "CUSTOMER_TYPE"
, "TAX_EXEMPT"
, "TAX_EXEMPT_NUM"
, "TAX_EXEMPT_REASON_CODE"
, "CUSTOMER_CLASS_CODE"
, "PRIMARY_SALESREP_ID"
, "SALES_CHANNEL_CODE"
, "SIC_CODE"
, "ORDER_TYPE_ID"
, "PRICE_LIST_ID"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "ANALYSIS_FY"
, "CUSTOMER_CATEGORY_CODE"
, "CUSTOMER_GROUP_CODE"
, "CUSTOMER_KEY"
, "CUSTOMER_SUBGROUP_CODE"
, "FISCAL_YEAREND_MONTH"
, "NET_WORTH"
, "NUM_OF_EMPLOYEES"
, "POTENTIAL_REVENUE_CURR_FY"
, "POTENTIAL_REVENUE_NEXT_FY"
, "RANK"
, "REFERENCE_USE_FLAG"
, "TAX_CODE"
, "TAX_REFERENCE"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "THIRD_PARTY_FLAG"
, "ACCESS_TEMPLATE_ENTITY_CODE"
, "PRIMARY_SPECIALIST_ID"
, "SECONDARY_SPECIALIST_ID"
, "DUNNING_SITE_USE_ID"
, "STATEMENT_SITE_USE_ID"
, "ORIG_SYSTEM"
, "YEAR_ESTABLISHED"
, "SHIP_VIA"
, "FOB_POINT"
, "SHIP_PARTIAL"
, "GSA_INDICATOR"
, "WAREHOUSE_ID"
, "FREIGHT_TERM"
, "COTERMINATE_DAY_MONTH"
, "PAYMENT_TERM_ID"
, "COMPETITOR_FLAG"
, "JGZZ_FISCAL_CODE"
, "DO_NOT_MAIL_FLAG"
, "MISSION_STATEMENT"
, "CUSTOMER_NAME_PHONETIC"
FROM RA_CUSTOMERS