HRT_PROFILE_TP_SC_PRP_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
SECTION_PROP_ID BUSINESS_GROUP_ID SECTION_ID FIELD_NAME ATTRIBUTE_LABEL VIEW_ATTRB_NAME COLUMN_NAME VALUE_SET_NAME PROPERTY_SOURCE MODULE_ID SOURCE_CODE REQUIRED_FLAG DEFAULT_VALUE DISPLAY_FLAG DISPLAY_ORDER SEARCH_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SGUID ATTRIBUTE_LABEL_KEY INPUT_FIELD_TYPE_CODE CUSTOM_LABEL

Query

SQL_Statement

SELECT PTSP.SECTION_PROP_ID, PTSP.BUSINESS_GROUP_ID, PTSP.SECTION_ID, PTSP.FIELD_NAME, PTSPL.ATTRIBUTE_LABEL, PTSP.VIEW_ATTRB_NAME, PTSP.COLUMN_NAME, PTSP.VALUE_SET_NAME, PTSP.PROPERTY_SOURCE, PTSP.MODULE_ID, PTSP.SOURCE_CODE, PTSP.REQUIRED_FLAG, PTSP.DEFAULT_VALUE, PTSP.DISPLAY_FLAG, PTSP.DISPLAY_ORDER, PTSP.SEARCH_FLAG, PTSP.OBJECT_VERSION_NUMBER, PTSP.CREATED_BY, PTSP.CREATION_DATE, PTSP.LAST_UPDATED_BY, PTSP.LAST_UPDATE_DATE, PTSP.LAST_UPDATE_LOGIN, PTSP.SGUID SGUID, PTSP.ATTRIBUTE_LABEL_KEY, PTSP.INPUT_FIELD_TYPE_CODE, PTSPL.CUSTOM_LABEL FROM HRT_PROFILE_TP_SC_PRP_B PTSP, HRT_PROFILE_TP_SC_PRP_TL PTSPL WHERE PTSP.SECTION_PROP_ID = PTSPL.SECTION_PROP_ID AND PTSP.BUSINESS_GROUP_ID = PTSPL.BUSINESS_GROUP_ID AND PTSPL.LANGUAGE = USERENV('LANG')