VIEW: APPS.PA_PROJ_ROLE_TYPES_V

Source

View Text - Preformatted

SELECT 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.STATUS_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 FROM PA_PROJECT_ROLE_TYPES_VL role WHERE role.project_role_id not in (2,3,4,5,6,7) AND role.role_party_class='PERSON'

View Text - HTML Formatted

SELECT 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.STATUS_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
FROM PA_PROJECT_ROLE_TYPES_VL ROLE
WHERE ROLE.PROJECT_ROLE_ID NOT IN (2
, 3
, 4
, 5
, 6
, 7)
AND ROLE.ROLE_PARTY_CLASS='PERSON'