ZSF_FCST_COMMON_ATTR_VL

Details

• Schema: FUSION

• Object owner: ZSF

• Object type: VIEW

Columns

Name
FCST_COMMON_ATTR_ID NAME TABLE_NAME COLUMN_NAME ATTR_TYPE_CODE DEFAULT_DISPCLMN_FLAG CRITERIA_FLAG DISPCLMN_FLAG ATTR_UI_TYPE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONFLICT_ID OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE FIELD_OPERATOR_TYPE LOOKUP_NAME

Query

SQL_Statement

SELECT B.FCST_COMMON_ATTR_ID, T.NAME, B.TABLE_NAME, B.COLUMN_NAME, B.ATTR_TYPE_CODE, B.DEFAULT_DISPCLMN_FLAG, B.CRITERIA_FLAG, B.DISPCLMN_FLAG, B.ATTR_UI_TYPE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CONFLICT_ID, B.OBJECT_VERSION_NUMBER, B.USER_LAST_UPDATE_DATE, B.FIELD_OPERATOR_TYPE, B.LOOKUP_NAME FROM ZSF_FCST_COMMON_ATTR_B B, ZSF_FCST_COMMON_ATTR_TL T WHERE B.FCST_COMMON_ATTR_ID = T.FCST_COMMON_ATTR_ID AND T.LANGUAGE = USERENV('LANG')