FND Design Data [Home] [Help]

View: CSD_RULES_VL

Product: CSD - Depot Repair
Description: View that joins CSD_RULES_B with TL table
Implementation/DBA Data: ViewAPPS.CSD_RULES_VL
View Text

SELECT RULB.ROWID
, RULB.RULE_ID
, RULTL.NAME
, RULTL.DESCRIPTION
, RULB.RULE_TYPE_CODE
, RULB.PRECEDENCE
, RULB.ENTITY_ATTRIBUTE_CODE
, RULB.ENTITY_ATTRIBUTE_TYPE
, RULB.VALUE_TYPE_CODE
, RULB.CREATED_BY
, RULB.CREATION_DATE
, RULB.LAST_UPDATED_BY
, RULB.LAST_UPDATE_DATE
, RULB.LAST_UPDATE_LOGIN
, RULB.OBJECT_VERSION_NUMBER
, RULB.ATTRIBUTE_CATEGORY
, RULB.ATTRIBUTE1
, RULB.ATTRIBUTE2
, RULB.ATTRIBUTE3
, RULB.ATTRIBUTE4
, RULB.ATTRIBUTE5
, RULB.ATTRIBUTE6
, RULB.ATTRIBUTE7
, RULB.ATTRIBUTE8
, RULB.ATTRIBUTE9
, RULB.ATTRIBUTE10
, RULB.ATTRIBUTE11
, RULB.ATTRIBUTE12
, RULB.ATTRIBUTE13
, RULB.ATTRIBUTE14
, RULB.ATTRIBUTE15
FROM CSD_RULES_B RULB
, CSD_RULES_TL RULTL
WHERE RULB.RULE_ID = RULTL.RULE_ID
AND RULTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
RULE_ID
NAME
DESCRIPTION
RULE_TYPE_CODE
PRECEDENCE
ENTITY_ATTRIBUTE_CODE
ENTITY_ATTRIBUTE_TYPE
VALUE_TYPE_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15