HRT_PROFILE_TYPES_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

PROFILE_TYPE_ID BUSINESS_GROUP_ID DESCRIPTION SUMMARY PROFILE_TYPE_CODE PROFILE_STATUS_CODE PROFILE_USAGE_CODE DATE_FROM DATE_TO SYNC_FLEXFIELD_FLAG PROFILE_SYNC_FLAG SYNC_CRITICALITY_FLAG SYNC_DESCRIPTION_FLAG SYNC_QUALIFICATION_FLAG SYNC_RESPONSIBILITY_FLAG SYNC_RISK_FLAG OVERWRITE_SYNC_ITEM_FLAG SYNC_ATTACHMENT_FLAG PID_APPROVAL_FLAG MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN AUTO_CREATE_FLAG SHOW_DESCRIPTION_FLAG SHOW_RESPONSIBILITY_FLAG SHOW_QUALIFICATION_FLAG SHOW_CRITICALITY_FLAG

Query

SQL_Statement

SELECT PT.PROFILE_TYPE_ID, PT.BUSINESS_GROUP_ID, PTL.DESCRIPTION, PTL.SUMMARY, PT.PROFILE_TYPE_CODE, PT.PROFILE_STATUS_CODE, PT.PROFILE_USAGE_CODE, PT.DATE_FROM, PT.DATE_TO, PT.SYNC_FLEXFIELD_FLAG, PT.PROFILE_SYNC_FLAG, PT.SYNC_CRITICALITY_FLAG, PT.SYNC_DESCRIPTION_FLAG, PT.SYNC_QUALIFICATION_FLAG, PT.SYNC_RESPONSIBILITY_FLAG, PT.SYNC_RISK_FLAG, PT.OVERWRITE_SYNC_ITEM_FLAG, PT.SYNC_ATTACHMENT_FLAG, PT.PID_APPROVAL_FLAG, PT.MODULE_ID, PT.OBJECT_VERSION_NUMBER, PT.CREATED_BY, PT.CREATION_DATE, PT.LAST_UPDATED_BY, PT.LAST_UPDATE_DATE, PT.LAST_UPDATE_LOGIN, PT.AUTO_CREATE_FLAG, PT.SHOW_DESCRIPTION_FLAG, PT.SHOW_RESPONSIBILITY_FLAG, PT.SHOW_QUALIFICATION_FLAG, PT.SHOW_CRITICALITY_FLAG FROM HRT_PROFILE_TYPES_B PT, HRT_PROFILE_TYPES_TL PTL WHERE PT.PROFILE_TYPE_ID = PTL.PROFILE_TYPE_ID AND PT.BUSINESS_GROUP_ID = PTL.BUSINESS_GROUP_ID AND PTL.LANGUAGE = USERENV('LANG')