Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Enterprise Resource Planning (ERP)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 8, 2012 6:09 AM by
SQL query to find Approved projects which are open
Oct 5, 2012 5:31 PM
Can anyone provide a SQL query which will show only the approved projects which are open.
This content has been marked as final.
Show 1 reply
Re: SQL query to find Approved projects which are open
Oct 8, 2012 6:09 AM
in response to
select PROJECT_ID , NAME from pa_projects_all
where project_status_code = 'APPROVED'
and NVL(CLOSED_DATE,SYSDATE+1) > SYSDATE