View: PA_ONLINE_PROJECTS_V

Product:	PA - Projects
Description:	Customizable view for projects used in Self Service Time application. PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application
Implementation/DBA Data:	APPS.PA_ONLINE_PROJECTS_V

View Text

SELECT DISTINCT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, PROJECT_TYPE
, START_DATE
, COMPLETION_DATE
, CARRYING_OUT_ORGANIZATION_ID
, (SELECT NAME
FROM HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = CARRYING_OUT_ORGANIZATION_ID) CARRYING_OUT_ORGANIZATION_NAME
FROM PA_PROJECTS_EXPEND_V

Columns