VIEW: APPS.OKE_CUSTOMER_ACCOUNTS_V

Source

View Text - Preformatted

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.CUSTOMER_CLASS_CODE , NULL FROM HZ_CUST_ACCOUNTS CA , HZ_PARTIES P WHERE CA.PARTY_ID = P.PARTY_ID

View Text - HTML Formatted

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.CUSTOMER_CLASS_CODE
, NULL
FROM HZ_CUST_ACCOUNTS CA
, HZ_PARTIES P
WHERE CA.PARTY_ID = P.PARTY_ID