VIEW: APPS.OKX_CUSTOMER_ACCOUNTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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