VIEW: APPS.AMS_IBA_RULESETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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