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.HR_GRADE_JPG_LOV_V

Source

View Text - Preformatted


SELECT grt.name , grd.grade_id , pvg.date_from , pvg.date_to , grd.business_group_id , pos1.position_id , pos1.job_id , lkj.meaning valid_for_job , lkp.meaning valid_for_pos from hr_lookups lkj , hr_lookups lkp , per_valid_grades pvg , per_grades_tl grt , per_grades grd , per_all_positions pos1 WHERE grd.grade_id=pvg.grade_id and pvg.date_from between grd.date_from and nvl(grd.date_to, pvg.date_from+1) and lkj.lookup_type='YES_NO' and lkj.lookup_code='N' and lkp.lookup_type='YES_NO' and lkp.lookup_code='Y' and grt.grade_id = grd.grade_id and grt.language = userenv('LANG') and pvg.position_id=pos1.position_id and pos1.date_effective < nvl(grd.date_to, pos1.date_effective+1) and nvl(pos1.date_end,grd.date_from+1) > grd.date_from and not exists (select null from per_valid_grades pvg2 where pvg2.job_id =pos1.job_id and pvg2.grade_id=pvg.grade_id and pvg2.date_from between grd.date_from and nvl(grd.date_to, pvg2.date_from+1)) UNION select grt.name, grd.grade_id , pvg.date_from, pvg.date_to , grd.business_group_id, pos1.position_id , pos1.job_id, lkj.meaning valid_for_job , lkp.meaning valid_for_pos from hr_lookups lkj , hr_lookups lkp , per_valid_grades pvg , per_grades_tl grt , per_grades grd , per_all_positions pos1 where grd.grade_id=pvg.grade_id and pvg.date_from between grd.date_from and nvl(grd.date_to, pvg.date_from+1) and lkj.lookup_type='YES_NO' and lkj.lookup_code='Y' and lkp.lookup_type='YES_NO' and lkp.lookup_code='N' and grt.grade_id = grd.grade_id and grt.language = userenv('LANG') and pvg.job_id =pos1.job_id and pos1.date_effective < nvl(grd.date_to, pos1.date_effective+1) and nvl(pos1.date_end,grd.date_from+1) > grd.date_from and not exists (select null from per_valid_grades pvg2 where pvg2.position_id =pos1.position_id and pvg2.grade_id=pvg.grade_id and pvg2.date_from between grd.date_from and nvl(grd.date_to, pvg2.date_from+1)) UNION select grt.name, grd.grade_id , pvg.date_from, pvg.date_to , grd.business_group_id, pos1.position_id , pos1.job_id, lkj.meaning valid_for_job , lkp.meaning valid_for_pos from hr_lookups lkj , hr_lookups lkp , per_valid_grades pvg , per_grades_tl grt , per_grades grd , per_all_positions pos1 where grd.grade_id=pvg.grade_id and pvg.date_from between grd.date_from and nvl(grd.date_to, pvg.date_from+1) and lkj.lookup_type='YES_NO' and lkj.lookup_code='Y' and lkp.lookup_type='YES_NO' and lkp.lookup_code='Y' and pvg.job_id=pos1.job_id and grt.grade_id = grd.grade_id and grt.language = userenv('LANG') and pvg.position_id=pos1.position_id and pos1.date_effective < nvl(grd.date_to, pos1.date_effective+1) and nvl(pos1.date_end,grd.date_from+1) > grd.date_from UNION select grt.name , grd.grade_id , grd.date_from , grd.date_to , grd.business_group_id , pos1.position_id , pos1.job_id , lkj.meaning valid_for_job , lkp.meaning valid_for_pos from hr_lookups lkj , hr_lookups lkp , per_grades_tl grt , per_grades grd , per_all_positions pos1 where lkj.lookup_type='YES_NO' and lkj.lookup_code='N' and lkp.lookup_type='YES_NO' and lkp.lookup_code='N' and grt.grade_id = grd.grade_id and grt.language = userenv('LANG') and pos1.date_effective < nvl(grd.date_to, pos1.date_effective+1) and nvl(pos1.date_end,grd.date_from+1) > grd.date_from and not exists (select null from per_valid_grades pvg2 where pvg2.position_id=pos1.position_id and pvg2.grade_id=grd.grade_id and pvg2.date_from between grd.date_from and nvl(grd.date_to, pvg2.date_from+1)) and not exists (select null from per_valid_grades pvg3 where pvg3.job_id=pos1.job_id and pvg3.grade_id=grd.grade_id and pvg3.date_from between grd.date_from and nvl(grd.date_to,pvg3.date_from+1))

View Text - HTML Formatted

SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS1.POSITION_ID
, POS1.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS1
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='N'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='Y'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.POSITION_ID=POS1.POSITION_ID
AND POS1.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS1.DATE_EFFECTIVE+1)
AND NVL(POS1.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.JOB_ID =POS1.JOB_ID
AND PVG2.GRADE_ID=PVG.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1)) UNION SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS1.POSITION_ID
, POS1.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS1
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='Y'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='N'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.JOB_ID =POS1.JOB_ID
AND POS1.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS1.DATE_EFFECTIVE+1)
AND NVL(POS1.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.POSITION_ID =POS1.POSITION_ID
AND PVG2.GRADE_ID=PVG.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1)) UNION SELECT GRT.NAME
, GRD.GRADE_ID
, PVG.DATE_FROM
, PVG.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS1.POSITION_ID
, POS1.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_VALID_GRADES PVG
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS1
WHERE GRD.GRADE_ID=PVG.GRADE_ID
AND PVG.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG.DATE_FROM+1)
AND LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='Y'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='Y'
AND PVG.JOB_ID=POS1.JOB_ID
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND PVG.POSITION_ID=POS1.POSITION_ID
AND POS1.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS1.DATE_EFFECTIVE+1)
AND NVL(POS1.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM UNION SELECT GRT.NAME
, GRD.GRADE_ID
, GRD.DATE_FROM
, GRD.DATE_TO
, GRD.BUSINESS_GROUP_ID
, POS1.POSITION_ID
, POS1.JOB_ID
, LKJ.MEANING VALID_FOR_JOB
, LKP.MEANING VALID_FOR_POS
FROM HR_LOOKUPS LKJ
, HR_LOOKUPS LKP
, PER_GRADES_TL GRT
, PER_GRADES GRD
, PER_ALL_POSITIONS POS1
WHERE LKJ.LOOKUP_TYPE='YES_NO'
AND LKJ.LOOKUP_CODE='N'
AND LKP.LOOKUP_TYPE='YES_NO'
AND LKP.LOOKUP_CODE='N'
AND GRT.GRADE_ID = GRD.GRADE_ID
AND GRT.LANGUAGE = USERENV('LANG')
AND POS1.DATE_EFFECTIVE < NVL(GRD.DATE_TO
, POS1.DATE_EFFECTIVE+1)
AND NVL(POS1.DATE_END
, GRD.DATE_FROM+1) > GRD.DATE_FROM
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG2
WHERE PVG2.POSITION_ID=POS1.POSITION_ID
AND PVG2.GRADE_ID=GRD.GRADE_ID
AND PVG2.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG2.DATE_FROM+1))
AND NOT EXISTS (SELECT NULL
FROM PER_VALID_GRADES PVG3
WHERE PVG3.JOB_ID=POS1.JOB_ID
AND PVG3.GRADE_ID=GRD.GRADE_ID
AND PVG3.DATE_FROM BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, PVG3.DATE_FROM+1))