Query to fetch the Customer Details

Can any one Please provide the query to fetch the below details.

Customer name (excluding Intercompany Customer)

Open Balance amount

Status of customer (active or inactive)

Ship to address