PSC_TS_MOB_OFFLN_CNTL_FLD_VL

Details

• Schema: FUSION

• Object owner: PSC_TS

• Object type: VIEW

Columns

Name
CONFIGURATION_ID MOBILE_APP DESCRIPTION VALUE UNIT ACTIVE MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SEED_DATA_LOCK SEED_DATA_SOURCE DELETED_FLAG

Query

SQL_Statement

SELECT B.CONFIGURATION_ID CONFIGURATION_ID, B.MOBILE_APP MOBILE_APP, TL.DESCRIPTION DESCRIPTION, B.VALUE VALUE, TL.UNIT UNIT, B.ACTIVE ACTIVE, B.MODULE_ID MODULE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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.SEED_DATA_LOCK SEED_DATA_LOCK, B.SEED_DATA_SOURCE SEED_DATA_SOURCE, B.DELETED_FLAG DELETED_FLAG FROM PSC_TS_MOB_OFFLN_CNTL_FLD_B B, PSC_TS_MOB_OFFLN_CNTL_FLD_TL TL WHERE B.CONFIGURATION_ID = TL.CONFIGURATION_ID AND TL.LANGUAGE = USERENV('LANG') AND B.MOBILE_APP = TL.MOBILE_APP