VIEW: APPS.MST_ALL_PARTIES_V

Source

View Text - Preformatted

SELECT HZC.CUST_ACCOUNT_ID PARTY_ID, HZP.PARTY_NAME,HZC.ACCOUNT_NUMBER FROM HZ_PARTIES HZP, hz_cust_accounts hzc WHERE HZP.PARTY_ID = HZC.PARTY_ID AND HZC.STATUS ='A'

View Text - HTML Formatted

SELECT HZC.CUST_ACCOUNT_ID PARTY_ID
, HZP.PARTY_NAME
, HZC.ACCOUNT_NUMBER
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZC
WHERE HZP.PARTY_ID = HZC.PARTY_ID
AND HZC.STATUS ='A'