VIEW: APPS.CN_SCA_RULE_ATTRIBUTES_ALL_VL

Source

View Text - Preformatted

SELECT B.SCA_RULE_ATTRIBUTE_ID,B.TRANSACTION_SOURCE,B.SRC_COLUMN_NAME,B.DATATYPE,B.VALUE_SET_ID,B.TRX_SRC_COLUMN_NAME,B.ENABLED_FLAG,B.ATTRIBUTE_CATEGORY,B.ATTRIBUTE1,B.ATTRIBUTE2,B.ATTRIBUTE3,B.ATTRIBUTE4,B.ATTRIBUTE5,B.ATTRIBUTE6,B.ATTRIBUTE7,B.ATTRIBUTE8,B.ATTRIBUTE9,B.ATTRIBUTE10,B.ATTRIBUTE11,B.ATTRIBUTE12,B.ATTRIBUTE13,B.ATTRIBUTE14,B.ATTRIBUTE15,B.OBJECT_VERSION_NUMBER,B.CREATED_BY,B.CREATION_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATE_LOGIN,B.SECURITY_GROUP_ID,B.ORG_ID,T.USER_COLUMN_NAME FROM CN_SCA_RULE_ATTRIBUTES_ALL_TL T,CN_SCA_RULE_ATTRIBUTES_ALL_B B WHERE B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID AND NVL(B.ORG_ID, -99) = NVL(T.ORG_ID, -99) AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.SCA_RULE_ATTRIBUTE_ID
, B.TRANSACTION_SOURCE
, B.SRC_COLUMN_NAME
, B.DATATYPE
, B.VALUE_SET_ID
, B.TRX_SRC_COLUMN_NAME
, B.ENABLED_FLAG
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.SECURITY_GROUP_ID
, B.ORG_ID
, T.USER_COLUMN_NAME
FROM CN_SCA_RULE_ATTRIBUTES_ALL_TL T
, CN_SCA_RULE_ATTRIBUTES_ALL_B B
WHERE B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
AND NVL(B.ORG_ID
, -99) = NVL(T.ORG_ID
, -99)
AND T.LANGUAGE = USERENV('LANG')