PA Projects Periods

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Projects Periods (XML)
Short Name: PAXRWPST_XML
DB package: PA_PAXRWPST_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select  s.meaning status
,     	p.period_name
,	p.start_date
,	p.end_date
from 	pa_lookups s
,	pa_periods p
where	p.status = s.lookup_code
and	s.lookup_type = 'CLOSING STATUS'
and	p.status = nvl(:p_status_code,p.status)
order by p.start_date desc
Parameter Name SQL text Validation
Closing Status 
 
 LOV Oracle
Download
   
Related Blitz Reports
CAC WIP Account Value PA Project Manager Reporting Pack CAC Manufacturing Variance Summary CAC WIP Material Usage Variance CAC Receiving Value (Period-End) CAC ICP PII WIP Material Usage Variance CAC Accounting Period Status CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Material Usage with Configuration and Lot Variances CAC WIP Resource Efficiency
Blitz Report™

Blitz Report™ provides multiple benefits: