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 |
