VIEW: APPS.CSI_SRS_PARTY_NAME_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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