[Home] [Help]
View: OKE_CUSTOMER_ACCOUNTS_V
View Text
SELECT CA.CUST_ACCOUNT_ID
, '#'
, CA.PARTY_ID
, P.PARTY_NAME
, CA.ACCOUNT_NUMBER
, CA.CUSTOMER_TYPE
, CA.STATUS
, DECODE(CA.STATUS
, 'A'
, 'A'
, 'I'
, 'I'
, 'I')
, CA.COTERMINATE_DAY_MONTH
, CA.ACCOUNT_ESTABLISHED_DATE
, CA.ACCOUNT_TERMINATION_DATE
, CA.ACCOUNT_ACTIVATION_DATE
, CA.CUSTOMER_CLASS_CODE
, NULL
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 |
END_DATE_ACTIVE |
START_DATE_ACTIVE |
CUSTOMER_CLASS_CODE |
PRIMARY_UOM_CODE |