[Home] [Help]
View: CS_IB_PARTY_NAME_V
| Product: | CS - Service |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT /*+ FIRST_ROWS */ HZP.PARTY_NAME PARTY_NAME
, HZA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, DECODE((SELECT 'X'
FROM CS_CUSTOMER_PRODUCTS_ALL CS
WHERE CS.CUSTOMER_ID = HZA.CUST_ACCOUNT_ID
AND ROWNUM < 2)
, 'X'
, 'Y'
, 'N') EXISTS_IN_IB
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZA
WHERE HZP.PARTY_ID = HZA.PARTY_ID
Columns
| Name |
| PARTY_NAME |
| CUSTOMER_NUMBER |
| EXISTS_IN_IB |