VIEW: APPS.PA_PROJECT_ROLE_TYPES

Source

View Text - Preformatted

SELECT vl.row_id , vl.project_role_type , vl.query_labor_cost_flag , vl.start_date_active , vl.end_date_active , vl.attribute_category , vl.attribute1 , vl.attribute2 , vl.attribute3 , vl.attribute4 , vl.attribute5 , vl.attribute6 , vl.attribute7 , vl.attribute8 , vl.attribute9 , vl.attribute10 , vl.attribute11 , vl.attribute12 , vl.attribute13 , vl.attribute14 , vl.attribute15 , vl.project_role_id , vl.menu_id , vl.default_job_id , vl.default_min_job_level , vl.default_max_job_level , vl.record_version_number , vl.freeze_rules_flag , vl.default_access_level , vl.role_party_class , vl.language , vl.source_lang , vl.meaning , vl.description , vl.last_update_date , vl.last_updated_by , vl.creation_date , vl.created_by , vl.last_update_login from pa_project_role_types_vl vl WHERE vl.role_party_class = 'PERSON'

View Text - HTML Formatted

SELECT VL.ROW_ID
, VL.PROJECT_ROLE_TYPE
, VL.QUERY_LABOR_COST_FLAG
, VL.START_DATE_ACTIVE
, VL.END_DATE_ACTIVE
, VL.ATTRIBUTE_CATEGORY
, VL.ATTRIBUTE1
, VL.ATTRIBUTE2
, VL.ATTRIBUTE3
, VL.ATTRIBUTE4
, VL.ATTRIBUTE5
, VL.ATTRIBUTE6
, VL.ATTRIBUTE7
, VL.ATTRIBUTE8
, VL.ATTRIBUTE9
, VL.ATTRIBUTE10
, VL.ATTRIBUTE11
, VL.ATTRIBUTE12
, VL.ATTRIBUTE13
, VL.ATTRIBUTE14
, VL.ATTRIBUTE15
, VL.PROJECT_ROLE_ID
, VL.MENU_ID
, VL.DEFAULT_JOB_ID
, VL.DEFAULT_MIN_JOB_LEVEL
, VL.DEFAULT_MAX_JOB_LEVEL
, VL.RECORD_VERSION_NUMBER
, VL.FREEZE_RULES_FLAG
, VL.DEFAULT_ACCESS_LEVEL
, VL.ROLE_PARTY_CLASS
, VL.LANGUAGE
, VL.SOURCE_LANG
, VL.MEANING
, VL.DESCRIPTION
, VL.LAST_UPDATE_DATE
, VL.LAST_UPDATED_BY
, VL.CREATION_DATE
, VL.CREATED_BY
, VL.LAST_UPDATE_LOGIN
FROM PA_PROJECT_ROLE_TYPES_VL VL
WHERE VL.ROLE_PARTY_CLASS = 'PERSON'