VIEW: APPS.PA_PROJECT_ROLELIST_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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