VIEW: APPS.HXC_RESOURCE_ELIG_PREF_V

Source

View Text - Preformatted

SELECT resource_id ,rule_evaluation_order ,rule_name ,business_group_id ,legislation_code ,preference_id ,preference_code ,preference_name ,edit_allowed ,displayed ,hierarchy_name ,attribute_category ,attribute1 ,attribute2 ,attribute3 ,attribute4 ,attribute5 ,attribute6 ,attribute7 ,attribute8 ,attribute9 ,attribute10 ,attribute11 ,attribute12 ,attribute13 ,attribute14 ,attribute15 ,attribute16 ,attribute17 ,attribute18 ,attribute19 ,attribute20 ,attribute21 ,attribute22 ,attribute23 ,attribute24 ,attribute25 ,attribute26 ,attribute27 ,attribute28 ,attribute29 ,attribute30 from hxc_resource_all_elig_pref_v v1 WHERE v1.rule_evaluation_order = (select max(v2.rule_evaluation_order) from hxc_resource_all_elig_pref_v v2 where v1.resource_id = v2.resource_id and v1.preference_code = v2.preference_code)

View Text - HTML Formatted

SELECT RESOURCE_ID
, RULE_EVALUATION_ORDER
, RULE_NAME
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, PREFERENCE_ID
, PREFERENCE_CODE
, PREFERENCE_NAME
, EDIT_ALLOWED
, DISPLAYED
, HIERARCHY_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM HXC_RESOURCE_ALL_ELIG_PREF_V V1
WHERE V1.RULE_EVALUATION_ORDER = (SELECT MAX(V2.RULE_EVALUATION_ORDER)
FROM HXC_RESOURCE_ALL_ELIG_PREF_V V2
WHERE V1.RESOURCE_ID = V2.RESOURCE_ID
AND V1.PREFERENCE_CODE = V2.PREFERENCE_CODE)