PA Transfer Activity

Description
Categories: BI Publisher, Financials
Application: Projects
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
Employee
 
LOV Oracle
Expenditure Type
 
LOV Oracle
Task Number
 
LOV Oracle
Project Number
 
LOV Oracle