[Home] [Help]
View: OKX_CUSTOMER_ACCOUNTS_V
View Text
SELECT CA.CUST_ACCOUNT_ID ID1
, '#' ID2
, CA.PARTY_ID PARTY_ID
, DECODE(CA.ACCOUNT_NAME
, NULL
, P.PARTY_NAME
, CA.ACCOUNT_NAME) NAME
, CA.ACCOUNT_NUMBER DESCRIPTION
, CA.CUSTOMER_TYPE CUSTOMER_TYPE
, CA.STATUS B_STATUS
, CA.STATUS STATUS
, CA.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, CA.ACCOUNT_ESTABLISHED_DATE ACCOUNT_ESTABLISHED_DATE
, CA.CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, NULL PRIMARY_UOM_CODE
, CA.SALES_CHANNEL_CODE
, DECODE( P.PARTY_TYPE
, 'ORGANIZATION'
, P.GSA_INDICATOR_FLAG
, 'N') GSA_INDICATOR
, P.EMAIL_ADDRESS EMAIL_ADDRESS
FROM HZ_CUST_ACCOUNTS CA
, HZ_PARTIES P
WHERE CA.PARTY_ID = P.PARTY_ID
Columns
Name |
ID1 |
ID2 |
PARTY_ID |
NAME |
DESCRIPTION |
CUSTOMER_TYPE |
B_STATUS |
STATUS |
COTERMINATE_DAY_MONTH |
ACCOUNT_ESTABLISHED_DATE |
CUSTOMER_CLASS_CODE |
PRIMARY_UOM_CODE |
SALES_CHANNEL_CODE |
GSA_INDICATOR |
EMAIL_ADDRESS |