HRC_DL_LAYOUT_INSTRS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
INSTRUCTION_ID LAYOUT_CODE INSTRUCTION_HEADING INSTRUCTION_CONTENT INSTRUCTION_TYPE SEQUENCE_NUMBER STATUS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBSOLETE_FLAG MODULE_ID SGUID

Query

SQL_Statement

SELECT B.INSTRUCTION_ID, B.LAYOUT_CODE, TL.INSTRUCTION_HEADING, TL.INSTRUCTION_CONTENT, B.INSTRUCTION_TYPE, B.SEQUENCE_NUMBER, B.STATUS, 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, B.MODULE_ID, B.SGUID FROM HRC_DL_LAYOUT_INSTRS_B B, HRC_DL_LAYOUT_INSTRS_TL TL WHERE B.INSTRUCTION_ID = TL.INSTRUCTION_ID AND TL.LANGUAGE = USERENV('LANG')