PA Invoice Flow Detail
Description
Categories: BI Publisher
Application: Projects
Source: FLW: Invoice Flow Detail (XML)
Short Name: PAXPCIDF_XML
DB package: PA_PAXPCIDF_XMLP_PKG
Source: FLW: Invoice Flow Detail (XML)
Short Name: PAXPCIDF_XML
DB package: PA_PAXPCIDF_XMLP_PKG
select substr(p.organization_name,1,60) project_organization, p.member_name, p.project_role, p.project_number, p.project_name, i.invoice_status, i.draft_invoice_num invoice_number, i.draft_invoice_num_credited credit_of, i.bill_through_date bill_thru_date, i.creation_date, i.approved_date, i.released_date, i.days_awaiting_approval awaiting_approval, i.invoice_amount amount, i.invoice_curr_amount inv_amount, i.invoice_currency_code from pa_proj_members_view p, pa_org_reporting_view vw, pa_proj_invoices_view i, pa_lookups lk where p.organization_id = vw.organization_id and nvl(:project_role_type ,'PROJECT MANAGER') = p.project_role_type and nvl(:project_member,p.member_person_id) = p.member_person_id and p.project_id =i.project_id and i.invoice_amount between :low_range and :high_range and decode(:invoice_status, null,lk.lookup_code, 'ALL',lk.lookup_code, :invoice_status)= lk.lookup_code and lk.lookup_type='INVOICE STATUS' and lk.meaning(+)=i.invoice_status 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 decode(:include_released_status,'N',released_date,null) is null order by p.organization_name,p.member_name, i.invoice_status,p.project_number,i.draft_invoice_num |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Start Organization |
|
LOV Oracle | |
Project Member |
|
LOV Oracle | |
Project Role Type |
|
LOV Oracle | |
Creation Date From |
|
Date | |
Creation Date To |
|
Date | |
Include Released Invoices |
|
LOV Oracle | |
Invoice Amount Ranges |
|
LOV Oracle | |
Invoice Status |
|
LOV Oracle |