HRT_QUALIFIERS_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
QUALIFIER_ID BUSINESS_GROUP_ID DESCRIPTION QUALIFIER_SET_ID QUALIFIER_CODE QUALIFIER_SEQ_NUMBER EMP_VIEW_FLAG EMP_DEF_FLAG MGR_VIEW_FLAG MGR_DEF_FLAG SEARCH_FLAG MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT Q.QUALIFIER_ID, Q.BUSINESS_GROUP_ID, QTL.DESCRIPTION, Q.QUALIFIER_SET_ID, Q.QUALIFIER_CODE, Q.QUALIFIER_SEQ_NUMBER, Q.EMP_VIEW_FLAG, Q.EMP_DEF_FLAG, Q.MGR_VIEW_FLAG, Q.MGR_DEF_FLAG, Q.SEARCH_FLAG, Q.MODULE_ID, Q.OBJECT_VERSION_NUMBER, Q.CREATED_BY, Q.CREATION_DATE, Q.LAST_UPDATED_BY, Q.LAST_UPDATE_DATE, Q.LAST_UPDATE_LOGIN FROM HRT_QUALIFIERS_B Q, HRT_QUALIFIERS_TL QTL WHERE Q.QUALIFIER_ID = QTL.QUALIFIER_ID AND Q.BUSINESS_GROUP_ID = QTL.BUSINESS_GROUP_ID AND QTL.LANGUAGE = USERENV('LANG')