Product: | ICX - Oracle iProcurement |
---|---|
Description: | Customer Profile View |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUSTOMER_ID
, CUSTOMER_NAME
, UPPER( CUSTOMER_NAME )
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('CODE_STATUS'
, STATUS)
, STATUS
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('CUSTOMER_TYPE'
, CUSTOMER_TYPE)
, CUSTOMER_TYPE
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('CUSTOMER_PROSPECT_CODE'
, CUSTOMER_PROSPECT_CODE)
, CUSTOMER_CLASS_CODE
, PRIMARY_SALESREP_ID
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('SALES_CHANNEL'
, SALES_CHANNEL_CODE)
, SALES_CHANNEL_CODE
, SIC_CODE
, ANALYSIS_FY
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('CUSTOMER_CATEGORY'
, CUSTOMER_CATEGORY_CODE)
, DECODE( FISCAL_YEAREND_MONTH
, NULL
, NULL
, TO_CHAR( TO_DATE ( '01-' || FISCAL_YEAREND_MONTH || '-1900'
, 'DD-MM-YYYY' )
, 'MONTH' ))
, NET_WORTH
, NUM_OF_EMPLOYEES
, POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY
, TAX_CODE
, TAX_REFERENCE
, DUNNING_SITE_USE_ID
, STATEMENT_SITE_USE_ID
, COTERMINATE_DAY_MONTH
, YEAR_ESTABLISHED
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('FOB'
, FOB_POINT)
, FREIGHT_TERM
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('YES/NO'
, GSA_INDICATOR)
, ICX_CUSTOMER_PANEL.GET_AR_CODE ('YES/NO'
, SHIP_PARTIAL)
, SHIP_VIA
, JGZZ_FISCAL_CODE
, DO_NOT_MAIL_FLAG
, MISSION_STATEMENT
, URL
FROM RA_CUSTOMERS