PA Transfer Activity
Description
Categories: BI Publisher
Application: Projects
Source: MGT: Transfer Activity Report (XML)
Short Name: PAXEXTAR_XML
DB package: PA_PAXEXTAR_XMLP_PKG
Source: MGT: Transfer Activity Report (XML)
Short Name: PAXEXTAR_XML
DB package: PA_PAXEXTAR_XMLP_PKG
SELECT pt.to_project_num pnum , pt.to_project_name pname , pt.to_task_name tname , pt.incurred_by_name ename , pt.expenditure_type etype , substr(pt.organization_name,1,60) org , pt.expenditure_item_date eidate , pt.quantity qty , pt.burden_cost cost , pt.to_expenditure_item_id to_ei FROM pa_proj_transfers_view pt WHERE pt.to_project_id = :project AND pt.to_task_id = nvl( :task, pt.to_task_id ) AND pt.to_task_id != pt.from_task_id AND pt.expenditure_type = nvl( :exp_type, pt.expenditure_type ) AND nvl(pt.incurred_by_person_id, -999) = nvl( :employee, nvl(pt.incurred_by_person_id, -999) ) ORDER BY 1 ASC,2 ASC,6 ASC , pt.expenditure_type , pt.expenditure_item_date , pt.incurred_by_name , pt.organization_name , pt.to_project_num , pt.to_project_name , pt.to_task_name , pt.quantity , pt.burden_cost |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Project Number |
|
LOV Oracle | |
Task Number |
|
LOV Oracle | |
Expenditure Type |
|
LOV Oracle | |
Employee |
|
LOV Oracle |