[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 |