PA Invoice Flow Summary

select 
 org.organization_id,
 substr(p.organization_name,1,60) project_organization, 
 p.member_name project_member2,
 i.invoice_status,
 i.project_id||i.draft_invoice_num invoice,
i.invoice_currency_code,
i.project_id proj_id,
i.draft_invoice_num draft_num 
--	PA_PAXPCIFS_XMLP_PKG.c_inv_amountformula(:C_inv_amount1, :C_inv_amount2, :C_inv_amount3) C_inv_amount, 
--	PA_PAXPCIFS_XMLP_PKG.c_inv_countformula(:C_inv_count1, :C_inv_count2, :C_inv_count3) C_inv_count, 
--	PA_PAXPCIFS_XMLP_PKG.c_amountformula(:C_amount1, :C_amount2, :C_amount3) C_amount, 
--	PA_PAXPCIFS_XMLP_PKG.c_countformula(:C_count1, :C_count2, :C_count3) C_count
from 
 pa_org_reporting_view org,
 pa_proj_members_view p,
 pa_proj_invoices_view i
where p.organization_id = org.organization_id 
and p.project_id = i.project_id
and p.member_person_id =  
       nvl(:project_member,p.member_person_id) 
and p.project_role_type  = 
       nvl(:PROJECT_ROLE_TYPE,'PROJECT MANAGER')
and nvl(trunc(i.creation_date),sysdate) between 
      nvl(:CREATION_DATE_FROM,
      nvl(trunc(i.creation_date),sysdate-1)) and 
      nvl(:CREATION_DATE_TO,
           nvl(trunc(i.creation_date),sysdate+1))
and :c_enter is null
ORDER BY 2 ASC,1 ASC,3 ASC,4 ASC,7 ASC,8 ASC,6 ASC,5 ASC