VIEW: APPS.PA_PROJECT_ROLES_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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