View: AR_TA_RULE_SET_LN_V

View Text

SELECT RSL.ROWID
, RSL.LAST_UPDATE_DATE
, RSL.LAST_UPDATED_BY
, RSL.LAST_UPDATE_LOGIN
, RSL.CREATION_DATE
, RSL.CREATED_BY
, RSL.RULE_SET_LINE_ID
, RSL.RULE_SET_ID
, RSL.SEQUENCE_NUMBER
, RSL.RULE_ID
, RL.SHORT_NAME
, RL.DESCRIPTION
, RL.ACTIVE_FLAG
, RSL.ATTRIBUTE_CATEGORY
, RSL.ATTRIBUTE1
, RSL.ATTRIBUTE2
, RSL.ATTRIBUTE3
, RSL.ATTRIBUTE4
, RSL.ATTRIBUTE5
, RSL.ATTRIBUTE6
, RSL.ATTRIBUTE7
, RSL.ATTRIBUTE8
, RSL.ATTRIBUTE9
, RSL.ATTRIBUTE10
, RSL.ATTRIBUTE11
, RSL.ATTRIBUTE12
, RSL.ATTRIBUTE13
, RSL.ATTRIBUTE14
, RSL.ATTRIBUTE15
, RSL.ORG_ID
FROM AR_TA_RULE_SET_LN_ALL RSL
, AR_TA_RULES_ALL RL
WHERE NVL(RSL.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND NVL(RSL.ORG_ID
, -99) = NVL(RL.ORG_ID
, -99)
AND RSL.RULE_ID = RL.RULE_ID

Columns