What is the right query using sql to get the right status of an account (Customer)

i need to create a report using data model, in my requirement i need to select only active accounts

in analysis it only shows active account but in sql it show all, even i filter out the status of party table to only active

seems like i missed some other table (relationship table that hold the correct account status

SELECT ORG.ORGANIZATION_NAME FROM HZ_ORGANIZATION_PROFILES ORG, HZ_PARTIES PAR

WHERE ORG.PARTY_ID = PAR.PARTY_ID

and PAR.PARTY_ID ='A'

another requirement using SQL statement is to trim down the return value

currently our Organization Name is composed of Account Name - Country.