PA Projects Periods
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Projects Periods (XML)
Short Name: PAXRWPST_XML
DB package: PA_PAXRWPST_XMLP_PKG
Source: IMP: Projects Periods (XML)
Short Name: PAXRWPST_XML
DB package: PA_PAXRWPST_XMLP_PKG
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 |