VIEW: APPS.PA_SECURED_PROJECTS_V

Source

View Text - Preformatted

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) ))

View Text - HTML Formatted

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) ))