VIEW: APPS.HXC_RESOURCE_PERSONAL_PREF_V

Source

View Text - Preformatted

SELECT pa.person_id ,hrr.rule_evaluation_order ,hrr.name ,hpd.pref_definition_id ,hpd.code ,hph.edit_allowed ,hph.displayed ,hph.name ,hph.attribute_category ,hph.attribute1 ,hph.attribute2 ,hph.attribute3 ,hph.attribute4 ,hph.attribute5 ,hph.attribute6 ,hph.attribute7 ,hph.attribute8 ,hph.attribute9 ,hph.attribute10 ,hph.attribute11 ,hph.attribute12 ,hph.attribute13 ,hph.attribute14 ,hph.attribute15 ,hph.attribute16 ,hph.attribute17 ,hph.attribute18 ,hph.attribute19 ,hph.attribute20 ,hph.attribute21 ,hph.attribute22 ,hph.attribute23 ,hph.attribute24 ,hph.attribute25 ,hph.attribute26 ,hph.attribute27 ,hph.attribute28 ,hph.attribute29 ,hph.attribute30 from fnd_user fu ,hxc_pref_hierarchies hph ,hxc_pref_definitions hpd ,hxc_resource_rules hrr ,per_assignments_f pa WHERE hrr.resource_type = 'PERSON' and (hrr.eligibility_criteria_id = fu.user_id and hrr.eligibility_criteria_type = 'LOGIN') and hph.pref_hierarchy_id in (select hph2.pref_hierarchy_id from hxc_pref_hierarchies hph2 start with hph2.pref_hierarchy_id = hrr.pref_hierarchy_id connect by prior hph2.pref_hierarchy_id = hph2.parent_pref_hierarchy_id) and hph.pref_definition_id = hpd.pref_definition_id and fu.employee_id = pa.person_id order by hpd.code

View Text - HTML Formatted

SELECT PA.PERSON_ID
, HRR.RULE_EVALUATION_ORDER
, HRR.NAME
, HPD.PREF_DEFINITION_ID
, HPD.CODE
, HPH.EDIT_ALLOWED
, HPH.DISPLAYED
, HPH.NAME
, HPH.ATTRIBUTE_CATEGORY
, HPH.ATTRIBUTE1
, HPH.ATTRIBUTE2
, HPH.ATTRIBUTE3
, HPH.ATTRIBUTE4
, HPH.ATTRIBUTE5
, HPH.ATTRIBUTE6
, HPH.ATTRIBUTE7
, HPH.ATTRIBUTE8
, HPH.ATTRIBUTE9
, HPH.ATTRIBUTE10
, HPH.ATTRIBUTE11
, HPH.ATTRIBUTE12
, HPH.ATTRIBUTE13
, HPH.ATTRIBUTE14
, HPH.ATTRIBUTE15
, HPH.ATTRIBUTE16
, HPH.ATTRIBUTE17
, HPH.ATTRIBUTE18
, HPH.ATTRIBUTE19
, HPH.ATTRIBUTE20
, HPH.ATTRIBUTE21
, HPH.ATTRIBUTE22
, HPH.ATTRIBUTE23
, HPH.ATTRIBUTE24
, HPH.ATTRIBUTE25
, HPH.ATTRIBUTE26
, HPH.ATTRIBUTE27
, HPH.ATTRIBUTE28
, HPH.ATTRIBUTE29
, HPH.ATTRIBUTE30
FROM FND_USER FU
, HXC_PREF_HIERARCHIES HPH
, HXC_PREF_DEFINITIONS HPD
, HXC_RESOURCE_RULES HRR
, PER_ASSIGNMENTS_F PA
WHERE HRR.RESOURCE_TYPE = 'PERSON'
AND (HRR.ELIGIBILITY_CRITERIA_ID = FU.USER_ID
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'LOGIN')
AND HPH.PREF_HIERARCHY_ID IN (SELECT HPH2.PREF_HIERARCHY_ID
FROM HXC_PREF_HIERARCHIES HPH2 START WITH HPH2.PREF_HIERARCHY_ID = HRR.PREF_HIERARCHY_ID CONNECT BY PRIOR HPH2.PREF_HIERARCHY_ID = HPH2.PARENT_PREF_HIERARCHY_ID)
AND HPH.PREF_DEFINITION_ID = HPD.PREF_DEFINITION_ID
AND FU.EMPLOYEE_ID = PA.PERSON_ID ORDER BY HPD.CODE