HNS_CONFIG_VL

Details

• Schema: FUSION

• Object owner: HNS

• Object type: VIEW

Columns

Name

CONFIG_ID CONFIG_TYPE CONFIG_CODE CONFIG_VALUE MODULE_ID DELETED_FLAG BUSINESS_GROUP_ID CONFIG_NAME CONFIG_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CONFIG_FLAG CONFIG_EMAIL DISPLAY_SEQUENCE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 DISPLAY_ORDER

Query

SQL_Statement

SELECT B.CONFIG_ID CONFIG_ID, B.CONFIG_TYPE CONFIG_TYPE, B.CONFIG_CODE CONFIG_CODE, B.CONFIG_VALUE CONFIG_VALUE, B.MODULE_ID MODULE_ID, B.DELETED_FLAG DELETED_FLAG, B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, T.CONFIG_NAME CONFIG_NAME, T.CONFIG_DESCRIPTION CONFIG_DESCRIPTION, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CONFIG_FLAG AS CONFIG_FLAG, B.CONFIG_EMAIL AS CONFIG_EMAIL, B.DISPLAY_SEQUENCE AS DISPLAY_SEQUENCE, B.ATTRIBUTE_CATEGORY AS ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 AS ATTRIBUTE1, B.ATTRIBUTE2 AS ATTRIBUTE2, B.ATTRIBUTE3 AS ATTRIBUTE3, B.ATTRIBUTE4 AS ATTRIBUTE4, B.ATTRIBUTE5 AS ATTRIBUTE5, B.ATTRIBUTE6 AS ATTRIBUTE6, B.ATTRIBUTE7 AS ATTRIBUTE7, B.ATTRIBUTE8 AS ATTRIBUTE8, B.ATTRIBUTE9 AS ATTRIBUTE9, B.ATTRIBUTE10 AS ATTRIBUTE10, B.ATTRIBUTE11 AS ATTRIBUTE11, B.ATTRIBUTE12 AS ATTRIBUTE12, B.ATTRIBUTE13 AS ATTRIBUTE13, B.ATTRIBUTE14 AS ATTRIBUTE14, B.ATTRIBUTE15 AS ATTRIBUTE15, B.ATTRIBUTE_NUMBER1 AS ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2 AS ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3 AS ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4 AS ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5 AS ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6 AS ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7 AS ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8 AS ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9 AS ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10 AS ATTRIBUTE_NUMBER10, B.ATTRIBUTE_TIMESTAMP1 AS ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2 AS ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3 AS ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4 AS ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5 AS ATTRIBUTE_TIMESTAMP5, B.ATTRIBUTE_DATE1 AS ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2 AS ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3 AS ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4 AS ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5 AS ATTRIBUTE_DATE5, B.DISPLAY_ORDER AS DISPLAY_ORDER FROM HNS_CONFIG_B B INNER JOIN HNS_CONFIG_TL T ON B.CONFIG_ID = T.CONFIG_ID WHERE T.LANGUAGE = USERENV('LANG')