[Home] [Help]
View: CSI_SRS_PARTY_NAME_V
Product: | CSI - Install Base |
Description: | View to display all the parties who have Customer Products. |
Implementation/DBA Data: |
APPS.CSI_SRS_PARTY_NAME_V
|
View Text
SELECT HZP.PARTY_NAME PARTY_NAME
, HZA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HZP.PARTY_ID PARTY_ID
, DECODE( ( SELECT 'X' FROM CSI_ITEM_INSTANCES CSI WHERE CSI.OWNER_PARTY_ACCOUNT_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 |
PARTY_ID |
EXISTS_IN_IB |