Product: | CSD - Depot Repair |
---|---|
Description: | View that displays all rules |
Implementation/DBA Data: | APPS.CSD_RULES_V |
SELECT RULB.ROWID
, RULB.RULE_ID
, RULTL.NAME
, RULTL.DESCRIPTION
, RULB.RULE_TYPE_CODE
, RTYPE_FND.MEANING
, RULB.PRECEDENCE
, RULB.ENTITY_ATTRIBUTE_CODE
, ATTR_FND.MEANING
, RULB.ENTITY_ATTRIBUTE_TYPE
, ENT_FND.MEANING
, RULB.VALUE_TYPE_CODE
, VAL_FND.MEANING
, 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
, FND_LOOKUPS ENT_FND
, FND_LOOKUPS RTYPE_FND
, FND_LOOKUPS ATTR_FND
, FND_LOOKUPS VAL_FND
WHERE RULB.RULE_ID = RULTL.RULE_ID
AND RULTL.LANGUAGE = USERENV('LANG')
AND ENT_FND.LOOKUP_TYPE(+) = 'CSD_DEFAULTING_ENTITIES'
AND ENT_FND.LOOKUP_CODE(+) = RULB.ENTITY_ATTRIBUTE_TYPE
AND ATTR_FND.LOOKUP_TYPE(+) = RULB.ENTITY_ATTRIBUTE_TYPE
AND ATTR_FND.LOOKUP_CODE(+) = RULB.ENTITY_ATTRIBUTE_CODE
AND RTYPE_FND.LOOKUP_TYPE = 'CSD_RULE_TYPES'
AND RTYPE_FND.LOOKUP_CODE = RULB.RULE_TYPE_CODE
AND VAL_FND.LOOKUP_TYPE(+) = 'CSD_DEFAULTING_VALUE_TYPES'
AND VAL_FND.LOOKUP_CODE(+) = RULB.VALUE_TYPE_CODE