View: PA_PROJECTS_SEC_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECTS_SEC_V

View Text

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

Columns