HRC_DL_LAYOUTS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

LAYOUT_ID LAYOUT_CODE LAYOUT_NAME LAYOUT_DESCRIPTION LAYOUT_TYPE LAYOUT_CATEGORY_CODE TOP_BUSINESS_OBJECT_ID STATUS HASH_VALUE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBSOLETE_FLAG MODULE_ID LAYOUT_MODE LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID KEY_PREFERENCE VALIDATION_STATUS LAYOUT_DETAILS LAYOUT_INFO1 LAYOUT_INFO2 SGUID RUN_MODE

Query

SQL_Statement

SELECT B.LAYOUT_ID, B.LAYOUT_CODE, TL.LAYOUT_NAME, TL.LAYOUT_DESCRIPTION, B.LAYOUT_TYPE, B.LAYOUT_CATEGORY_CODE, B.TOP_BUSINESS_OBJECT_ID, B.STATUS, B.HASH_VALUE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ENTERPRISE_ID, B.OBSOLETE_FLAG OBSOLETE_FLAG, B.MODULE_ID , B.LAYOUT_MODE, B.LEGISLATION_CODE, B.LEGISLATIVE_DATA_GROUP_ID, B.KEY_PREFERENCE, B.VALIDATION_STATUS, B.LAYOUT_DETAILS, B.LAYOUT_INFO1, B.LAYOUT_INFO2, B.SGUID, B.RUN_MODE FROM HRC_DL_LAYOUTS_B B, HRC_DL_LAYOUTS_TL TL WHERE B.LAYOUT_ID = TL.LAYOUT_ID AND TL.LANGUAGE = USERENV('LANG')