View: PA_PROJECT_ROLES_LOV_V

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

View Text

SELECT DISTINCT ROLE.ROW_ID
, ROLE.PROJECT_ROLE_ID
, ROLE.PROJECT_ROLE_TYPE
, ROLE.MEANING
, PA_ROLE_UTILS.GET_SCHEDULABLE_FLAG(ROLE.PROJECT_ROLE_ID) SCHEDULABLE_FLAG
, ROLE.QUERY_LABOR_COST_FLAG
, ROLE.START_DATE_ACTIVE
, ROLE.RECORD_VERSION_NUMBER
, ROLE.LAST_UPDATE_DATE
, ROLE.LAST_UPDATED_BY
, ROLE.CREATION_DATE
, ROLE.CREATED_BY
, ROLE.LAST_UPDATE_LOGIN
, ROLE.END_DATE_ACTIVE
, ROLE.DESCRIPTION
, ROLE.DEFAULT_MIN_JOB_LEVEL
, ROLE.DEFAULT_MAX_JOB_LEVEL
, ROLE.MENU_ID
, ROLE.DEFAULT_JOB_ID
, ROLE.FREEZE_RULES_FLAG
, ROLE.DEFAULT_ACCESS_LEVEL
, ROLE.ROLE_PARTY_CLASS
, ROLE.ATTRIBUTE_CATEGORY
, ROLE.ATTRIBUTE1
, ROLE.ATTRIBUTE2
, ROLE.ATTRIBUTE3
, ROLE.ATTRIBUTE4
, ROLE.ATTRIBUTE5
, ROLE.ATTRIBUTE6
, ROLE.ATTRIBUTE7
, ROLE.ATTRIBUTE8
, ROLE.ATTRIBUTE9
, ROLE.ATTRIBUTE10
, ROLE.ATTRIBUTE11
, ROLE.ATTRIBUTE12
, ROLE.ATTRIBUTE13
, ROLE.ATTRIBUTE14
, ROLE.ATTRIBUTE15
FROM PA_PROJECT_ROLE_TYPES_VL ROLE
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(ROLE.START_DATE_ACTIVE)
AND TRUNC(NVL(ROLE.END_DATE_ACTIVE
, SYSDATE))
AND ROLE.PROJECT_ROLE_ID NOT IN (2
, 3
, 4
, 5
, 6
, 7)
AND (ROLE.ROLE_PARTY_CLASS<>'PERSON' OR EXISTS (SELECT 'Y'
FROM PA_ROLE_CONTROLS CONTROL
WHERE CONTROL.PROJECT_ROLE_ID=ROLE.PROJECT_ROLE_ID
AND CONTROL.ROLE_CONTROL_CODE='ALLOW_AS_PROJ_MEMBER'))

Columns