VIEW: APPS.PA_PROJECTS_SEC_V

Source

View Text - Preformatted

SELECT project_id, name, long_name, segment1, description, project_type, carrying_out_organization_id, project_status_code, template_flag, org_id, project_currency_code FROM pa_projects ppa, (SELECT pa_security_pvt.get_grantee_key curr_grantee_key, DECODE (employee_id, NULL, 'Y', 'N') external_user FROM fnd_user WHERE user_id = fnd_global.user_id) WHERE template_flag = 'N' AND ( (ppa.security_level = 1 AND external_user = 'N') OR EXISTS ( SELECT '1' FROM pa_project_parties WHERE project_id = ppa.project_id AND ( ( resource_source_id = fnd_global.employee_id AND resource_type_id = 101 ) OR ( resource_type_id = 112 AND resource_source_id = (SELECT customer_id FROM fnd_user WHERE user_id = fnd_global.user_id) ) )) OR EXISTS ( SELECT '1' FROM fnd_grants fg, fnd_objects fo WHERE fg.grantee_key = curr_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 PROJECT_ID
, NAME
, LONG_NAME
, SEGMENT1
, DESCRIPTION
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PROJECT_STATUS_CODE
, TEMPLATE_FLAG
, ORG_ID
, PROJECT_CURRENCY_CODE
FROM PA_PROJECTS PPA
, (SELECT PA_SECURITY_PVT.GET_GRANTEE_KEY CURR_GRANTEE_KEY
, DECODE (EMPLOYEE_ID
, NULL
, 'Y'
, 'N') EXTERNAL_USER
FROM FND_USER
WHERE USER_ID = FND_GLOBAL.USER_ID)
WHERE TEMPLATE_FLAG = 'N'
AND ( (PPA.SECURITY_LEVEL = 1
AND EXTERNAL_USER = 'N') OR EXISTS ( SELECT '1'
FROM PA_PROJECT_PARTIES
WHERE PROJECT_ID = PPA.PROJECT_ID
AND ( ( RESOURCE_SOURCE_ID = FND_GLOBAL.EMPLOYEE_ID
AND RESOURCE_TYPE_ID = 101 ) OR ( RESOURCE_TYPE_ID = 112
AND RESOURCE_SOURCE_ID = (SELECT CUSTOMER_ID
FROM FND_USER
WHERE USER_ID = FND_GLOBAL.USER_ID) ) )) OR EXISTS ( SELECT '1'
FROM FND_GRANTS FG
, FND_OBJECTS FO
WHERE FG.GRANTEE_KEY = CURR_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)) )