[Home] [Help]
View: FUN_RULE_OBJECTS_VL
View Text
SELECT
B.ROWID ROW_ID
,
B.RULE_OBJECT_ID
,
B.APPLICATION_ID
,
B.RULE_OBJECT_NAME
,
B.RESULT_TYPE
,
B.REQUIRED_FLAG
,
B.USE_DEFAULT_VALUE_FLAG
,
A.DEFAULT_APPLICATION_ID
,
A.DEFAULT_VALUE
,
B.FLEX_VALUE_SET_ID
,
B.FLEXFIELD_NAME
,
B.FLEXFIELD_APP_SHORT_NAME
,
B.MULTI_RULE_RESULT_FLAG
,
B.OBJECT_VERSION_NUMBER
,
B.CREATED_BY_MODULE
,
B.CREATION_DATE
,
B.CREATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_LOGIN
,
B.USE_INSTANCE_FLAG
,
B.INSTANCE_LABEL
,
B.PARENT_RULE_OBJECT_ID
,
B.ORG_ID
,
T.USER_RULE_OBJECT_NAME
,
T.DESCRIPTION
FROM FUN_RULE_OBJECTS_TL T
, FUN_RULE_OBJECTS_B B
, FUN_RULE_OBJ_ATTRIBUTES A
WHERE B.RULE_OBJECT_ID = T.RULE_OBJECT_ID
AND B.RULE_OBJECT_ID = A.RULE_OBJECT_ID
AND T.LANGUAGE = USERENV('LANG')