View: PA_MU_PROJECTS_LOV_V

Product:	PA - Projects
Description:	This view displays all the active projects the user is allowed to query. - Retrofitted
Implementation/DBA Data:	APPS.PA_MU_PROJECTS_LOV_V

View Text

SELECT P.PROJECT_ID
, P.NAME
, P.SEGMENT1
, O.NAME
, TO_CHAR(O.ORGANIZATION_ID) ORGANIZATION_ID
, O.NAME
, TO_CHAR(O.ORGANIZATION_ID) PROJECT_ORGANIZATION_ID
, PA_SECURITY.ALLOW_UPDATE(P.PROJECT_ID)
FROM PA_PROJECTS P
, HR_ORGANIZATION_UNITS O
WHERE PA_PROJECT_STUS_UTILS.IS_PROJECT_STATUS_CLOSED(P.PROJECT_STATUS_CODE) = 'N'
AND 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
FROM SYS.DUAL)
AND P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID

Columns