View: OE_RA_CUSTOMERS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_RA_CUSTOMERS_V

View Text

SELECT CUST_ACCT.CUST_ACCOUNT_ID
, CUST_ACCT.LAST_UPDATE_DATE
, CUST_ACCT.LAST_UPDATED_BY
, CUST_ACCT.CREATION_DATE
, CUST_ACCT.CREATED_BY
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)/*CUSTOMER_NAME*/
, CUST_ACCT.ACCOUNT_NUMBER /*CUSTOMER_NUMBER*/
, CUST_ACCT.ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS
, CUST_ACCT.LAST_UPDATE_LOGIN
, CUST_ACCT.CUSTOMER_TYPE
, 'CUSTOMER'
, CUST_ACCT.CUSTOMER_CLASS_CODE
, CUST_ACCT.PRIMARY_SALESREP_ID
, CUST_ACCT.SALES_CHANNEL_CODE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.SIC_CODE
, NULL)
, CUST_ACCT.ORDER_TYPE_ID
, CUST_ACCT.PRICE_LIST_ID
, CUST_ACCT.ATTRIBUTE_CATEGORY
, CUST_ACCT.ATTRIBUTE1
, CUST_ACCT.ATTRIBUTE2
, CUST_ACCT.ATTRIBUTE3
, CUST_ACCT.ATTRIBUTE4
, CUST_ACCT.ATTRIBUTE5
, CUST_ACCT.ATTRIBUTE6
, CUST_ACCT.ATTRIBUTE7
, CUST_ACCT.ATTRIBUTE8
, CUST_ACCT.ATTRIBUTE9
, CUST_ACCT.ATTRIBUTE10
, CUST_ACCT.REQUEST_ID
, CUST_ACCT.PROGRAM_APPLICATION_ID
, CUST_ACCT.PROGRAM_ID
, CUST_ACCT.PROGRAM_UPDATE_DATE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ANALYSIS_FY
, NULL)
, PARTY.CATEGORY_CODE
, NULL /*CUSTOMER_GROUP_CODE*/
, PARTY.CUSTOMER_KEY
, NULL /*CUSTOMER_SUBGROUP_CODE*/
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.FISCAL_YEAREND_MONTH
, NULL)
, TO_NUMBER(NULL) /*NET_WORTH*/
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.EMPLOYEES_TOTAL
, TO_NUMBER(NULL))
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.CURR_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.NEXT_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, NULL /*RANK*/
, PARTY.REFERENCE_USE_FLAG
, CUST_ACCT.TAX_CODE
, PARTY.TAX_REFERENCE
, CUST_ACCT.ATTRIBUTE11
, CUST_ACCT.ATTRIBUTE12
, CUST_ACCT.ATTRIBUTE13
, CUST_ACCT.ATTRIBUTE14
, CUST_ACCT.ATTRIBUTE15
, PARTY.THIRD_PARTY_FLAG
, NULL /*ACCESS_TEMPLATE_ENTITY_CODE*/
, CUST_ACCT.PRIMARY_SPECIALIST_ID
, CUST_ACCT.SECONDARY_SPECIALIST_ID
, PARTY.COMPETITOR_FLAG
, TO_NUMBER(NULL) /*DUNNING_SITE_USE_ID*/
, TO_NUMBER(NULL) /*STATEMENT_SITE_USE_ID */
, NULL /*ORIG_SYSTEM*/
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.YEAR_ESTABLISHED
, TO_NUMBER(NULL))
, CUST_ACCT.COTERMINATE_DAY_MONTH
, CUST_ACCT.FOB_POINT
, CUST_ACCT.FREIGHT_TERM
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.GSA_INDICATOR_FLAG
, 'N')
, CUST_ACCT.SHIP_PARTIAL
, CUST_ACCT.SHIP_VIA
, CUST_ACCT.WAREHOUSE_ID
, CUST_ACCT.PAYMENT_TERM_ID
, NULL /*TAX_EXEMPT*/
, NULL /*TAX_EXEMPT_NUM*/
, NULL /*TAX_EXEMPT_REASON_CODE*/
, PARTY.JGZZ_FISCAL_CODE
, PARTY.DO_NOT_MAIL_FLAG
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.MISSION_STATEMENT
, NULL)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL)
, CUST_ACCT.TAX_HEADER_LEVEL_FLAG
, CUST_ACCT.TAX_ROUNDING_RULE
, CUST_ACCT.WH_UPDATE_DATE
, CUST_ACCT.GLOBAL_ATTRIBUTE1
, CUST_ACCT.GLOBAL_ATTRIBUTE2
, CUST_ACCT.GLOBAL_ATTRIBUTE3
, CUST_ACCT.GLOBAL_ATTRIBUTE4
, CUST_ACCT.GLOBAL_ATTRIBUTE5
, CUST_ACCT.GLOBAL_ATTRIBUTE6
, CUST_ACCT.GLOBAL_ATTRIBUTE7
, CUST_ACCT.GLOBAL_ATTRIBUTE8
, CUST_ACCT.GLOBAL_ATTRIBUTE9
, CUST_ACCT.GLOBAL_ATTRIBUTE10
, CUST_ACCT.GLOBAL_ATTRIBUTE11
, CUST_ACCT.GLOBAL_ATTRIBUTE12
, CUST_ACCT.GLOBAL_ATTRIBUTE13
, CUST_ACCT.GLOBAL_ATTRIBUTE14
, CUST_ACCT.GLOBAL_ATTRIBUTE15
, CUST_ACCT.GLOBAL_ATTRIBUTE16
, CUST_ACCT.GLOBAL_ATTRIBUTE17
, CUST_ACCT.GLOBAL_ATTRIBUTE18
, CUST_ACCT.GLOBAL_ATTRIBUTE19
, CUST_ACCT.GLOBAL_ATTRIBUTE20
, CUST_ACCT.GLOBAL_ATTRIBUTE_CATEGORY
, PARTY.URL
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID=PARTY.PARTY_ID

Columns