[Home] [Help]
View: AMS_IBA_RULESETS_V
View Text
SELECT ROWNUM ROW_NUM
, RSB.RULESET_ID RULESET_ID
, RSB.OBJECT_VERSION_NUMBER CR_OBJECT_VERSION_NUMBER
, RSTL.NAME NAME
, RSTL.DESCRIPTION DESCRIPTION
, DECODE( RSB.IBA_SORT_ORDER
, 0
, 'DESCENDING'
, 1
, 'ASCENDING'
, 2
, 'RANDOM' ) SORT_ORDER
, RSB.IBA_SORT_BY_CODE SORT_CODE
, RSB.STATUS STATUS
, RSB.CREATION_DATE CREATION_DATE
, RSB.START_DATE START_DATE
, RSB.END_DATE END_DATE
FROM JTF_R_RULESETS_B RSB
, JTF_R_RULESETS_TL RSTL
WHERE RSB.RULESET_ID = RSTL.RULESET_ID
AND RSTL.LANGUAGE(+) = USERENV('LANG') ORDER BY RULESET_ID
Columns
Name |
ROW_NUM |
RULESET_ID |
CR_OBJECT_VERSION_NUMBER |
NAME |
DESCRIPTION |
SORT_ORDER |
SORT_CODE |
STATUS |
CREATION_DATE |
START_DATE |
END_DATE |