VIEW: APPS.PA_PROJECT_ROLE_TYPES_VL

Source

View Text - Preformatted

SELECT b.ROWID , b.project_role_type , b.query_labor_cost_flag , b.start_date_active , b.end_date_active , b.attribute_category , b.attribute1 , b.attribute2 , b.attribute3 , b.attribute4 , b.attribute5 , b.attribute6 , b.attribute7 , b.attribute8 , b.attribute9 , b.attribute10 , b.attribute11 , b.attribute12 , b.attribute13 , b.attribute14 , b.attribute15 , b.project_role_id , b.menu_id , pa_role_job_bg_utils.get_job_id(b.project_role_id) job_id, pa_role_job_bg_utils.get_min_job_level(b.project_role_id) min_job_level, pa_role_job_bg_utils.get_max_job_level(b.project_role_id) max_job_level, b.record_version_number , b.freeze_rules_flag , b.default_access_level , b.role_party_class , b.status_level , tl.language , tl.source_lang , tl.meaning , tl.description , b.creation_date , b.created_by , b.last_update_date , b.last_updated_by , b.last_update_login from pa_project_role_types_b b , pa_project_role_types_tl tl WHERE b.project_role_id = tl.project_role_id AND tl.language = userenv('lang')

View Text - HTML Formatted

SELECT B.ROWID
, B.PROJECT_ROLE_TYPE
, B.QUERY_LABOR_COST_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.PROJECT_ROLE_ID
, B.MENU_ID
, PA_ROLE_JOB_BG_UTILS.GET_JOB_ID(B.PROJECT_ROLE_ID) JOB_ID
, PA_ROLE_JOB_BG_UTILS.GET_MIN_JOB_LEVEL(B.PROJECT_ROLE_ID) MIN_JOB_LEVEL
, PA_ROLE_JOB_BG_UTILS.GET_MAX_JOB_LEVEL(B.PROJECT_ROLE_ID) MAX_JOB_LEVEL
, B.RECORD_VERSION_NUMBER
, B.FREEZE_RULES_FLAG
, B.DEFAULT_ACCESS_LEVEL
, B.ROLE_PARTY_CLASS
, B.STATUS_LEVEL
, TL.LANGUAGE
, TL.SOURCE_LANG
, TL.MEANING
, TL.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM PA_PROJECT_ROLE_TYPES_B B
, PA_PROJECT_ROLE_TYPES_TL TL
WHERE B.PROJECT_ROLE_ID = TL.PROJECT_ROLE_ID
AND TL.LANGUAGE = USERENV('LANG')