select
B.ROWID ROW_ID,
B.CRITERIA_PARAM_ID,
B.RULE_OBJECT_ID,
B.PARAM_NAME,
B.DATA_TYPE,
B.FLEX_VALUE_SET_ID,
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,
T.USER_PARAM_NAME,
T.DESCRIPTION,
T.TIP_TEXT,
B.PARAMETER_TYPE,
B.DISABLED_FLAG,
B.COLUMN_NAME
from FUN_RULE_CRIT_PARAMS_TL T, FUN_RULE_CRIT_PARAMS_B B
where B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID
and T.LANGUAGE = userenv('LANG')
SELECT
B.ROWID ROW_ID
,
B.CRITERIA_PARAM_ID
,
B.RULE_OBJECT_ID
,
B.PARAM_NAME
,
B.DATA_TYPE
,
B.FLEX_VALUE_SET_ID
,
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
,
T.USER_PARAM_NAME
,
T.DESCRIPTION
,
T.TIP_TEXT
,
B.PARAMETER_TYPE
,
B.DISABLED_FLAG
,
B.COLUMN_NAME
FROM FUN_RULE_CRIT_PARAMS_TL T
, FUN_RULE_CRIT_PARAMS_B B
WHERE B.CRITERIA_PARAM_ID = T.CRITERIA_PARAM_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|