ZCH_SELECT_CRITERIA_RULES_VL
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: VIEW
Columns
Name |
---|
SELECT_CRITERIA_RULE_ID DATA_SELECT_CRITERIA_ID OBJ_NAME OBJ_DEF OPERATION_CODE RELATION_TYPE_CODE ATTRIBUTE_NAME ATTRIBUTE_VALUE ATTRIBUTE_DATA_TYPE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DESCRIPTION |
Query
SQL_Statement |
---|
SELECT B.SELECT_CRITERIA_RULE_ID SELECT_CRITERIA_RULE_ID, B.DATA_SELECT_CRITERIA_ID DATA_SELECT_CRITERIA_ID, B.OBJ_NAME OBJ_NAME, B.OBJ_DEF OBJ_DEF, B.OPERATION_CODE OPERATION_CODE, B.RELATION_TYPE_CODE RELATION_TYPE_CODE, B.ATTRIBUTE_NAME ATTRIBUTE_NAME, B.ATTRIBUTE_VALUE ATTRIBUTE_VALUE, B.ATTRIBUTE_DATA_TYPE ATTRIBUTE_DATA_TYPE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TL.DESCRIPTION DESCRIPTION FROM ZCH_SELECT_CRITERIA_RULES_B B, ZCH_SELECT_CRITERIA_RULES_TL TL WHERE B.SELECT_CRITERIA_RULE_ID = TL.SELECT_CRITERIA_RULE_ID AND TL.LANGUAGE = USERENV('LANG') |