View: PA_SECURED_PROJECTS_V

Product:	PA - Projects
Description:	This view shows a list of secured projects.
Implementation/DBA Data:	APPS.PA_SECURED_PROJECTS_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.TEMPLATE_FLAG
, PPA.CREATED_FROM_PROJECT_ID
, NVL(PA_PROJECT_STRUCTURE_UTILS.CHECK_WORKPLAN_ENABLED(PPA.PROJECT_ID)
, 'N')
, NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(PPA.PROJECT_ID)
, 'N')
, PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(PPA.PROJECT_ID)
, PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_ENABLED(PPA.PROJECT_ID)
, PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVAL_REQUIRED(PPA.PROJECT_ID)
FROM PA_PROJECTS_ALL PPA
, (SELECT PA_SECURITY_PVT.GET_GRANTEE_KEY GRANTEE_KEY
, DECODE(EMPLOYEE_ID
, NULL
, PA_UTILS.GET_PARTY_ID(USER_ID)
, EMPLOYEE_ID) RESOURCE_SOURCE_ID
, DECODE(EMPLOYEE_ID
, NULL
, 112
, 101) RESOURCE_TYPE_ID
, FND_PROFILE.VALUE_SPECIFIC('PA_SUPER_PROJECT'
, USER_ID) SUPER_USER_EDIT
, FND_PROFILE.VALUE_SPECIFIC('PA_SUPER_PROJECT_VIEW'
, USER_ID) SUPER_USER_VIEW
FROM FND_USER
WHERE USER_ID = FND_GLOBAL.USER_ID) LOGIN_USER
WHERE PPA.TEMPLATE_FLAG = 'N'
AND ((LOGIN_USER.SUPER_USER_EDIT = 'Y' OR LOGIN_USER.SUPER_USER_VIEW = 'Y') OR EXISTS( SELECT '1'
FROM PA_PROJECT_PARTIES
WHERE PROJECT_ID = PPA.PROJECT_ID
AND RESOURCE_SOURCE_ID = LOGIN_USER.RESOURCE_SOURCE_ID
AND RESOURCE_TYPE_ID = LOGIN_USER.RESOURCE_TYPE_ID) OR EXISTS( SELECT '1'
FROM FND_GRANTS FG
, FND_OBJECTS FO
WHERE FG.GRANTEE_KEY = LOGIN_USER.GRANTEE_KEY
AND FG.GRANTEE_TYPE = 'USER'
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND SYSDATE BETWEEN FG.START_DATE
AND NVL( FG.END_DATE
, SYSDATE + 1 )
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FO.OBJ_NAME = 'ORGANIZATION'
AND PPA.CARRYING_OUT_ORGANIZATION_ID = TO_NUMBER(FG.INSTANCE_PK1_VALUE) ))

Columns