VIEW: APPS.PA_MU_PROJECTS_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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