[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
ID1 |
ID2 |
NAME |
DESCRIPTION |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CUST_ACCOUNT_ID |
PROFILE_CLASS_ID |
SITE_USE_ID |
ACCOUNT_STATUS |
Name |