View: HXC_RESOURCE_PERSONAL_PREF_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_RESOURCE_PERSONAL_PREF_V

View Text

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

Columns