Coding a Customer/Modifier SQL Using EBS Tables

Hi,

Using ESB tables, I'm trying to create SQL that will return the customer number, customer name, ship-to address, sales territory, invoice number, invoice date, invoice balance in USD currency, and the modifier name and modifier extended amount for all modifier lines present on the invoice (if any) for all invoices which have a current balance.

Can you help me understand the relationship between these entities? 

Is this correct?

1.  A customer can have zero to many invoices.
2.  A invoice can have one to many items.
3.  A item can have one to many prices.
4.  A price can have zero to many modifiers.