Product: | CSD - Depot Repair |
---|---|
Description: | View that joins CSD_RULES_B with TL table |
Implementation/DBA Data: | APPS.CSD_RULES_VL |
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')