View: PA_PROJECT_ROLELIST_LOV_V

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

View Text

SELECT DISTINCT ROLE.ROW_ID ROW_ID
, ROLE.PROJECT_ROLE_ID
, ROLE.PROJECT_ROLE_TYPE
, ROLE.MEANING
, ROLE.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.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
, PRLM.ROLE_LIST_ID
, PPA.NAME
, PPA.SEGMENT1
FROM PA_PROJECT_ROLE_TYPES_V ROLE
, PA_ROLE_CONTROLS CONTROL
, PA_ROLE_LIST_MEMBERS PRLM
, PA_PROJECTS_ALL PPA
WHERE PRLM.PROJECT_ROLE_ID = ROLE.PROJECT_ROLE_ID
AND ROLE.PROJECT_ROLE_ID=CONTROL.PROJECT_ROLE_ID
AND CONTROL.ROLE_CONTROL_CODE='ALLOW_AS_PROJ_MEMBER'
AND PPA.ROLE_LIST_ID = PRLM.ROLE_LIST_ID UNION ALL SELECT DISTINCT ROLE.ROW_ID ROW_ID
, ROLE.PROJECT_ROLE_ID
, ROLE.PROJECT_ROLE_TYPE
, ROLE.MEANING
, ROLE.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.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
, PPA.ROLE_LIST_ID
, PPA.NAME
, PPA.SEGMENT1
FROM PA_PROJECT_ROLE_TYPES_V ROLE
, PA_ROLE_CONTROLS CONTROL
, PA_PROJECTS_ALL PPA
WHERE ROLE.PROJECT_ROLE_ID=CONTROL.PROJECT_ROLE_ID
AND CONTROL.ROLE_CONTROL_CODE='ALLOW_AS_PROJ_MEMBER'
AND PPA.ROLE_LIST_ID IS NULL

Columns