VIEW: APPS.JAI_CMN_CUSTOMERS_V

Source

View Text - Preformatted

SELECT c.cust_account_id party_id , party_number party_number, party_name party_name from hz_parties p , hz_cust_accounts c WHERE p.party_id = c.party_id and exists ( select 1 from JAI_CMN_CUS_ADDRESSES where customer_id = c.cust_account_id )

View Text - HTML Formatted

SELECT C.CUST_ACCOUNT_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, PARTY_NAME PARTY_NAME
FROM HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE P.PARTY_ID = C.PARTY_ID
AND EXISTS ( SELECT 1
FROM JAI_CMN_CUS_ADDRESSES
WHERE CUSTOMER_ID = C.CUST_ACCOUNT_ID )