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

Source

View Text - Preformatted


SELECT bgrT.name business_group_name ,orgT.name organization_name ,DECODE(ssm.parent_table_name,'PER_JOBS',jbt.name,NULL) job_name ,DECODE(ssm.parent_table_name,'PER_POSITIONS',pft.name,NULL) position_name ,gdt.name grade_name ,locT.location_code location_name ,hr_bis.bis_decode_lookup('COMPANY_AGE',ssm.company_age_code) company_age ,sas.survey_name survey_name ,hr_bis.bis_decode_lookup('SURVEY_COMPANY',sas.survey_company_code) survey_company ,sas.identifier survey_identifier ,NULL survey_currency ,hr_bis.bis_decode_lookup('PAY_BASIS',sas.survey_type_code) survey_type ,sas.base_region base_region ,hr_bis.bis_decode_lookup('SURVEY_JOB_NAME',ssl.survey_job_name_code) survey_job_name ,hr_bis.bis_decode_lookup('SURVEY_REGION',ssl.survey_region_code) survey_region ,hr_bis.bis_decode_lookup('SURVEY_SENIORITY',ssl.survey_seniority_code) survey_seniority ,hr_bis.bis_decode_lookup('COMPANY_SIZE',ssl.company_size_code) company_size ,hr_bis.bis_decode_lookup('INDUSTRY',ssl.industry_code) industry ,hr_bis.bis_decode_lookup('SURVEY_AGE',ssl.survey_age_code) survey_age ,ssl.start_date line_start_date ,ssl.end_date line_end_date ,ssl.differential differential ,line_cur.name line_currency ,ssl.minimum_pay minimum_pay ,ssl.mean_pay mean_pay ,ssl.maximum_pay maximum_pay ,ssl.graduate_pay graduate_pay ,ssl.starting_pay starting_pay ,ssl.percentage_change percentage_change ,ssl.job_first_quartile job_first_quartile ,ssl.job_median_quartile job_median_quartile ,ssl.job_third_quartile job_third_quartile ,ssl.job_fourth_quartile job_fourth_quartile ,ssl.minimum_total_compensation minimum_total_compensation ,ssl.mean_total_compensation mean_total_compensation ,ssl.maximum_total_compensation maximum_total_compensation ,ssl.compnstn_first_quartile compensation_first_quartile ,ssl.compnstn_median_quartile compensation_median_quartile ,ssl.compnstn_third_quartile compensation_third_quartile ,ssl.compnstn_fourth_quartile compensation_fourth_quartile ,'_DF:PER:PER_SALARY_SURVEYS:sas' ,'_DF:PER:PER_SALARY_SURVEY_LINES:ssl' ,'_DF:PER:PER_SALARY_SURVEY_MAPPINGS:ssm' ,sas.salary_survey_id salary_survey_id ,ssl.salary_survey_line_id salary_survey_line_id ,ssm.salary_survey_mapping_id salary_survey_mapping_id ,DECODE(ssm.parent_table_name,'PER_JOBS',jbt.job_id,NULL) job_id ,DECODE(ssm.parent_table_name,'PER_POSITIONS',pft.position_id,NULL) position_id ,ssm.business_group_id business_group_id ,ssm.location_id location_id ,ssm.grade_id grade_id ,ssm.company_organization_id organization_id FROM per_salary_surveys sas ,per_salary_survey_lines ssl ,per_salary_survey_mappings ssm ,fnd_currencies_vl line_cur ,hr_all_organization_units_tl bgrT ,hr_all_organization_units_tl orgT ,hr_locations_all_tl locT ,per_grades_tl gdt ,per_jobs_tl jbt ,hr_all_positions_f_tl pft WHERE sas.salary_survey_id = ssl.salary_survey_id AND ssl.salary_survey_line_id = ssm.salary_survey_line_id AND line_cur.currency_code (+) = ssl.currency_code AND jbt.job_id (+) = ssm.parent_id AND jbt.language (+) = userenv('LANG') AND pft.position_id (+) = ssm.parent_id AND pft.language (+) = userenv('LANG') AND ssm.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND ssm.company_organization_id = orgT.organization_id AND orgT.language = userenv('LANG') AND locT.location_id (+) = ssm.location_id AND locT.language (+) = userenv('LANG') AND gdt.grade_id (+) = ssm.grade_id AND gdt.language (+) = userenv('LANG') AND ssm.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ssm.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ORGT.NAME ORGANIZATION_NAME
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_JOBS'
, JBT.NAME
, NULL) JOB_NAME
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_POSITIONS'
, PFT.NAME
, NULL) POSITION_NAME
, GDT.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_AGE'
, SSM.COMPANY_AGE_CODE) COMPANY_AGE
, SAS.SURVEY_NAME SURVEY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_COMPANY'
, SAS.SURVEY_COMPANY_CODE) SURVEY_COMPANY
, SAS.IDENTIFIER SURVEY_IDENTIFIER
, NULL SURVEY_CURRENCY
, HR_BIS.BIS_DECODE_LOOKUP('PAY_BASIS'
, SAS.SURVEY_TYPE_CODE) SURVEY_TYPE
, SAS.BASE_REGION BASE_REGION
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_JOB_NAME'
, SSL.SURVEY_JOB_NAME_CODE) SURVEY_JOB_NAME
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_REGION'
, SSL.SURVEY_REGION_CODE) SURVEY_REGION
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_SENIORITY'
, SSL.SURVEY_SENIORITY_CODE) SURVEY_SENIORITY
, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_SIZE'
, SSL.COMPANY_SIZE_CODE) COMPANY_SIZE
, HR_BIS.BIS_DECODE_LOOKUP('INDUSTRY'
, SSL.INDUSTRY_CODE) INDUSTRY
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_AGE'
, SSL.SURVEY_AGE_CODE) SURVEY_AGE
, SSL.START_DATE LINE_START_DATE
, SSL.END_DATE LINE_END_DATE
, SSL.DIFFERENTIAL DIFFERENTIAL
, LINE_CUR.NAME LINE_CURRENCY
, SSL.MINIMUM_PAY MINIMUM_PAY
, SSL.MEAN_PAY MEAN_PAY
, SSL.MAXIMUM_PAY MAXIMUM_PAY
, SSL.GRADUATE_PAY GRADUATE_PAY
, SSL.STARTING_PAY STARTING_PAY
, SSL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, SSL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE
, SSL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE
, SSL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE
, SSL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE
, SSL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION
, SSL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION
, SSL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION
, SSL.COMPNSTN_FIRST_QUARTILE COMPENSATION_FIRST_QUARTILE
, SSL.COMPNSTN_MEDIAN_QUARTILE COMPENSATION_MEDIAN_QUARTILE
, SSL.COMPNSTN_THIRD_QUARTILE COMPENSATION_THIRD_QUARTILE
, SSL.COMPNSTN_FOURTH_QUARTILE COMPENSATION_FOURTH_QUARTILE
, '_DF:PER:PER_SALARY_SURVEYS:SAS'
, '_DF:PER:PER_SALARY_SURVEY_LINES:SSL'
, '_DF:PER:PER_SALARY_SURVEY_MAPPINGS:SSM'
, SAS.SALARY_SURVEY_ID SALARY_SURVEY_ID
, SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, SSM.SALARY_SURVEY_MAPPING_ID SALARY_SURVEY_MAPPING_ID
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_JOBS'
, JBT.JOB_ID
, NULL) JOB_ID
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_POSITIONS'
, PFT.POSITION_ID
, NULL) POSITION_ID
, SSM.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SSM.LOCATION_ID LOCATION_ID
, SSM.GRADE_ID GRADE_ID
, SSM.COMPANY_ORGANIZATION_ID ORGANIZATION_ID
FROM PER_SALARY_SURVEYS SAS
, PER_SALARY_SURVEY_LINES SSL
, PER_SALARY_SURVEY_MAPPINGS SSM
, FND_CURRENCIES_VL LINE_CUR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_LOCATIONS_ALL_TL LOCT
, PER_GRADES_TL GDT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
WHERE SAS.SALARY_SURVEY_ID = SSL.SALARY_SURVEY_ID
AND SSL.SALARY_SURVEY_LINE_ID = SSM.SALARY_SURVEY_LINE_ID
AND LINE_CUR.CURRENCY_CODE (+) = SSL.CURRENCY_CODE
AND JBT.JOB_ID (+) = SSM.PARENT_ID
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND PFT.POSITION_ID (+) = SSM.PARENT_ID
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND SSM.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND SSM.COMPANY_ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND LOCT.LOCATION_ID (+) = SSM.LOCATION_ID
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND GDT.GRADE_ID (+) = SSM.GRADE_ID
AND GDT.LANGUAGE (+) = USERENV('LANG')
AND SSM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, SSM.BUSINESS_GROUP_ID) WITH READ ONLY