View: PA_PROJECTS_CUST_360_V

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

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPA.PUBLIC_SECTOR_FLAG
, PPA.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, PPA.DISTRIBUTION_RULE
, PPA.TEMPLATE_FLAG
, PPA.CREATED_FROM_PROJECT_ID
, PPA.TEMPLATE_START_DATE_ACTIVE
, PPA.TEMPLATE_END_DATE_ACTIVE
, PPA.SUMMARY_FLAG
, PPA.ENABLED_FLAG
, PPA.ORG_ID
, PPA.PROJECT_CURRENCY_CODE
, PARTIES.RESOURCE_SOURCE_ID
, PEOPLE.FULL_NAME
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER(PPA.PROJECT_ID)
, PPA.PM_PRODUCT_CODE
, PPA.PM_PROJECT_REFERENCE
, PPA.ACTUAL_START_DATE
, PPA.ACTUAL_FINISH_DATE
, PPA.EARLY_START_DATE
, PPA.EARLY_FINISH_DATE
, PPA.LATE_START_DATE
, PPA.LATE_FINISH_DATE
, PPA.SCHEDULED_START_DATE
, PPA.SCHEDULED_FINISH_DATE
, PPA.PROBABILITY_MEMBER_ID
, PPA.EXPECTED_APPROVAL_DATE
, PPA.PROJECT_VALUE
, PPA.RECORD_VERSION_NUMBER
FROM PA_PROJECTS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_PROJECT_STATUSES PPS
, PER_ALL_PEOPLE_F PEOPLE
, PA_PROJECT_PARTIES PARTIES
, (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
FROM FND_USER
WHERE USER_ID = FND_GLOBAL.USER_ID) LOGIN_USER
, (SELECT FND_PROFILE.VALUE_SPECIFIC('PA_SUPER_PROJECT'
, FND_GLOBAL.USER_ID) SUPER_USER_EDIT
FROM DUAL)
, (SELECT FND_PROFILE.VALUE_SPECIFIC('PA_SUPER_PROJECT_VIEW'
, FND_GLOBAL.USER_ID) SUPER_USER_VIEW
FROM DUAL)
WHERE PPA.TEMPLATE_FLAG = 'N'
AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PARTIES.PROJECT_ROLE_ID (+) = 1
AND PARTIES.PROJECT_ID (+) = PPA.PROJECT_ID
AND SYSDATE BETWEEN PARTIES.START_DATE_ACTIVE(+)
AND NVL(PARTIES.END_DATE_ACTIVE(+)
, SYSDATE)
AND PARTIES.RESOURCE_SOURCE_ID = PEOPLE.PERSON_ID (+)
AND SYSDATE BETWEEN PEOPLE.EFFECTIVE_START_DATE (+)
AND PEOPLE.EFFECTIVE_END_DATE (+)
AND ((PPA.SECURITY_LEVEL = 1
AND LOGIN_USER.RESOURCE_TYPE_ID= 101) OR (SUPER_USER_EDIT = 'Y' OR SUPER_USER_VIEW = 'Y') OR EXISTS( SELECT '1'
FROM PA_PROJECT_PARTIES
WHERE PROJECT_ID = PPA.PROJECT_ID
AND OBJECT_TYPE = 'PA_PROJECTS'
AND OBJECT_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