View: AMS_IBA_RULESETS_V

Product:	AMS - Marketing
Description:	view for ruleset
Implementation/DBA Data:	APPS.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