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
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Enterprise Resource Planning (ERP)
This discussion is archived
on Oct 8, 2012 11:09 AM by Pradeep Kalyan
SQL query to find Approved projects which are open
Oct 5, 2012 10: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 11: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