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