eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HXC_RESOURCE_ALL_ELIG_PREF_V

Source

View Text - Preformatted


SELECT pa.person_id ,hrr.rule_evaluation_order ,hrr.name ,hrr.business_group_id ,hrr.legislation_code ,hpd.pref_definition_id ,hpd.code ,df.descriptive_flex_context_name preference_name ,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_descr_flex_contexts_vl df ,hxc_pref_hierarchies hph ,hxc_pref_definitions hpd ,hxc_resource_rules hrr ,per_assignments_f pa WHERE df.application_id =809 AND df.descriptive_flexfield_name ='OTC PREFERENCES' AND df.descriptive_flex_context_code = hpd.code and trunc(sysdate) between pa.effective_start_date and pa.effective_end_date and pa.primary_flag = 'Y' 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 hrr.resource_type = 'PERSON' and (((hrr.eligibility_criteria_type = 'ALL_PEOPLE' and (hrr.business_group_id is null or (hrr.business_group_id = hph.business_group_id and hrr.business_group_id = (select business_group_id from per_people_f pp where pp.person_id = pa.person_id and trunc(sysdate) between pp.effective_start_date and pp.effective_end_date)) )) or (hrr.eligibility_criteria_id = TO_CHAR( pa.person_id) and hrr.eligibility_criteria_type = 'PERSON') or (hrr.eligibility_criteria_id = TO_CHAR( pa.assignment_id) and hrr.eligibility_criteria_type = 'ASSIGNMENT') or (hrr.eligibility_criteria_id = TO_CHAR( pa.location_id) and hrr.eligibility_criteria_type = 'LOCATION') or (hrr.eligibility_criteria_id = pa.employee_category and hrr.eligibility_criteria_type = 'EMP_CATEGORY') or (hrr.eligibility_criteria_id = pa.employment_category and hrr.eligibility_criteria_type = 'ASGN_CATEGORY') or (hrr.eligibility_criteria_id = TO_CHAR( pa.job_id) and hrr.eligibility_criteria_type = 'JOB') or (hrr.eligibility_criteria_id = TO_CHAR( pa.organization_id) and hrr.eligibility_criteria_type = 'ORGANIZATION') or (hrr.eligibility_criteria_id = TO_CHAR( pa.payroll_id) and hrr.eligibility_criteria_type = 'PAYROLL') or (hrr.eligibility_criteria_id = TO_CHAR( pa.people_group_id) and hrr.eligibility_criteria_type = 'PEOPLE_GROUP') or (hrr.eligibility_criteria_id = TO_CHAR(pa.position_id) and hrr.eligibility_criteria_type = 'POSITION')) or (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 3 ), 'SCL', DECODE ( pa.soft_coding_keyflex_id, NULL, -1, hxc_resource_rules_utils.chk_flex_valid ( 'SCL', pa.soft_coding_keyflex_id, SUBSTR( hrr.eligibility_criteria_type, 5 ), hrr.eligibility_criteria_id )), -1 ) = 1 ) OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 6 ), 'PEOPLE', DECODE ( pa.people_group_id, NULL, -1, hxc_resource_rules_utils.chk_flex_valid ( 'PEOPLE', pa.people_group_id, SUBSTR( hrr.eligibility_criteria_type, 8 ), hrr.eligibility_criteria_id )), -1 ) = 1 ) OR (DECODE ( SUBSTR( hrr.eligibility_criteria_type, 1, 5 ), 'GRADE', DECODE ( pa.grade_id, NULL, -1, hxc_resource_rules_utils.chk_flex_valid ( 'GRADE', pa.grade_id, SUBSTR( hrr.eligibility_criteria_type, 7 ), hrr.eligibility_criteria_id )), -1 ) = 1 ))

View Text - HTML Formatted

SELECT PA.PERSON_ID
, HRR.RULE_EVALUATION_ORDER
, HRR.NAME
, HRR.BUSINESS_GROUP_ID
, HRR.LEGISLATION_CODE
, HPD.PREF_DEFINITION_ID
, HPD.CODE
, DF.DESCRIPTIVE_FLEX_CONTEXT_NAME PREFERENCE_NAME
, 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_DESCR_FLEX_CONTEXTS_VL DF
, HXC_PREF_HIERARCHIES HPH
, HXC_PREF_DEFINITIONS HPD
, HXC_RESOURCE_RULES HRR
, PER_ASSIGNMENTS_F PA
WHERE DF.APPLICATION_ID =809
AND DF.DESCRIPTIVE_FLEXFIELD_NAME ='OTC PREFERENCES'
AND DF.DESCRIPTIVE_FLEX_CONTEXT_CODE = HPD.CODE
AND TRUNC(SYSDATE) BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND PA.PRIMARY_FLAG = 'Y'
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 HRR.RESOURCE_TYPE = 'PERSON'
AND (((HRR.ELIGIBILITY_CRITERIA_TYPE = 'ALL_PEOPLE'
AND (HRR.BUSINESS_GROUP_ID IS NULL OR (HRR.BUSINESS_GROUP_ID = HPH.BUSINESS_GROUP_ID
AND HRR.BUSINESS_GROUP_ID = (SELECT BUSINESS_GROUP_ID
FROM PER_PEOPLE_F PP
WHERE PP.PERSON_ID = PA.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE)) )) OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PERSON_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PERSON') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.ASSIGNMENT_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ASSIGNMENT') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.LOCATION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'LOCATION') OR (HRR.ELIGIBILITY_CRITERIA_ID = PA.EMPLOYEE_CATEGORY
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'EMP_CATEGORY') OR (HRR.ELIGIBILITY_CRITERIA_ID = PA.EMPLOYMENT_CATEGORY
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ASGN_CATEGORY') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.JOB_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'JOB') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.ORGANIZATION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ORGANIZATION') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PAYROLL_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PAYROLL') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PEOPLE_GROUP_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PEOPLE_GROUP') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR(PA.POSITION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'POSITION')) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 3 )
, 'SCL'
, DECODE ( PA.SOFT_CODING_KEYFLEX_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'SCL'
, PA.SOFT_CODING_KEYFLEX_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 5 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 6 )
, 'PEOPLE'
, DECODE ( PA.PEOPLE_GROUP_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'PEOPLE'
, PA.PEOPLE_GROUP_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 8 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 5 )
, 'GRADE'
, DECODE ( PA.GRADE_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'GRADE'
, PA.GRADE_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 7 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ))