VIEW: APPS.FUN_RULE_OBJECTS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')