SQL for Project Events Invoice

Summary:

Trying to get the approved Invoices only and I am getting incorrect values.

Content (please ensure you mask any confidential information):

Code Snippet (add any code snippets that support your topic, if applicable):

here is my script:

select segment1, task_number, event_type_name, description, completion_date, invoiced_amt, contract_amt, account_dr, account_cr, gl_period, contract_number, cognomen, customer_name
from (
select distinct
t5.segment1,
t7.task_number,
t12.event_type_name, t12.description,
to_char(t4.completion_date, 'MM-DD-YYYY') completion_date,
t4.contract_curr_amt invoiced_amt,
t1.estimated_amount contract_amt,
t4.revenue_amt account_dr, t4.invoice_curr_pot_amt account_cr,