[Home] [Help]
View: OKX_CUSTOMER_PROFILES_V
View Text
SELECT CUST_ACCOUNT_PROFILE_ID
, '#'ID2
, CUST_ACCOUNT_PROFILE_ID
, CUST_ACCOUNT_PROFILE_ID
, STATUS
, TO_DATE('1950-01-01 00:00:00'
, 'YYYY-MM-DD HH24:MI:SS') START_DATE_ACTIVE
, TO_DATE(NULL) END_DATE_ACTIVE
, CUST_ACCOUNT_ID
, PROFILE_CLASS_ID
, SITE_USE_ID
, ACCOUNT_STATUS
FROM HZ_CUSTOMER_PROFILES
Columns
| Name |
| ID1 |
| ID2 |
| NAME |
| DESCRIPTION |
| STATUS |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| CUST_ACCOUNT_ID |
| PROFILE_CLASS_ID |
| SITE_USE_ID |
| ACCOUNT_STATUS |