PA Transfer Activity

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: MGT: Transfer Activity Report (XML)
Short Name: PAXEXTAR_XML
DB package: PA_PAXEXTAR_XMLP_PKG
Run PA Transfer Activity and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
ECC Project Manufacturing, Procurement Activities, SQL4 ECC Project Manufacturing, Exceptions and Overdues, SQL10 ECC Project Manufacturing, Exceptions and Overdues, SQL11 ECC Project Manufacturing, Exceptions and Overdues, SQL8 ECC Project Manufacturing, Exceptions and Overdues, SQL9 ECC Project Manufacturing, Exceptions and Overdues, SQL6 ECC Project Manufacturing, Exceptions and Overdues, SQL7 ECC Project Manufacturing, Exceptions and Overdues, SQL5 ECC Project Manufacturing, Commitments
Blitz Report™

Blitz Report™ provides multiple benefits: