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

Source

View Text - Preformatted


SELECT PSM.ROWID ROW_ID, PSM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PSM.SALARY_SURVEY_MAPPING_ID SALARY_SURVEY_MAPPING_ID, PSM.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PSM.PARENT_ID PARENT_ID, PSM.PARENT_TABLE_NAME PARENT_TABLE_NAME, PSM.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID, PSM.LOCATION_ID LOCATION_ID, LOCTL.LOCATION_CODE LOCATION, PSM.GRADE_ID GRADE_ID, GDT.NAME GRADE, PSM.COMPANY_AGE_CODE COMPANY_AGE_CODE, L8.MEANING COMPANY_AGE, PSM.COMPANY_ORGANIZATION_ID COMPANY_ORGANIZATION_ID, AOUTL.NAME COMPANY_ORGANIZATION, L1.MEANING SURVEY_COMPANY_NAME, SS.SURVEY_NAME SURVEY_NAME, L2.MEANING SURVEY_JOB_NAME, L3.MEANING SURVEY_REGION, L4.MEANING SURVEY_SENIORITY, L5.MEANING COMPANY_SIZE, L9.MEANING SURVEY_AGE, L6.MEANING INDUSTRY, FC.NAME CURRENCY, L7.MEANING SURVEY_TYPE, SS.BASE_REGION BASE_REGION, SL.START_DATE START_DATE, SL.END_DATE END_DATE, SL.DIFFERENTIAL DIFFERENTIAL, SL.MINIMUM_PAY MINIMUM_PAY, SL.MEAN_PAY MEAN_PAY, SL.MAXIMUM_PAY MAXIMUM_PAY, SL.GRADUATE_PAY GRADUATE_PAY, SL.STARTING_PAY STARTING_PAY, SL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE, SL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE, SL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE, SL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE, SL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE, SL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION, SL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION, SL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION, SL.COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE, SL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE, SL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE, SL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE, PSM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PSM.ATTRIBUTE1 ATTRIBUTE1, PSM.ATTRIBUTE2 ATTRIBUTE2, PSM.ATTRIBUTE3 ATTRIBUTE3, PSM.ATTRIBUTE4 ATTRIBUTE4, PSM.ATTRIBUTE5 ATTRIBUTE5, PSM.ATTRIBUTE6 ATTRIBUTE6, PSM.ATTRIBUTE7 ATTRIBUTE7, PSM.ATTRIBUTE8 ATTRIBUTE8, PSM.ATTRIBUTE9 ATTRIBUTE9, PSM.ATTRIBUTE10 ATTRIBUTE10, PSM.ATTRIBUTE11 ATTRIBUTE11, PSM.ATTRIBUTE12 ATTRIBUTE12, PSM.ATTRIBUTE13 ATTRIBUTE13, PSM.ATTRIBUTE14 ATTRIBUTE14, PSM.ATTRIBUTE15 ATTRIBUTE15, PSM.ATTRIBUTE16 ATTRIBUTE16, PSM.ATTRIBUTE17 ATTRIBUTE17, PSM.ATTRIBUTE18 ATTRIBUTE18, PSM.ATTRIBUTE19 ATTRIBUTE19, PSM.ATTRIBUTE20 ATTRIBUTE20, PSM.LAST_UPDATE_DATE LAST_UPDATE_DATE, PSM.LAST_UPDATED_BY LAST_UPDATED_BY, PSM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PSM.CREATED_BY CREATED_BY, PSM.CREATION_DATE CREATION_DATE, SL.TENTH_PERCENTILE TENTH_PERCENTILE , SL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE , SL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE , SL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE , SL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE , SL.MINIMUM_BONUS MINIMUM_BONUS , SL.MEAN_BONUS MEAN_BONUS , SL.MAXIMUM_BONUS MAXIMUM_BONUS , SL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE , SL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE , SL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE , SL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION , SL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION , SL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION , SL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE , SL.MINIMUM_STOCK MINIMUM_STOCK , SL.MEAN_STOCK MEAN_STOCK , SL.MAXIMUM_STOCK MAXIMUM_STOCK FROM PER_SALARY_SURVEYS SS, PER_SALARY_SURVEY_LINES SL, PER_SALARY_SURVEY_MAPPINGS PSM, FND_CURRENCIES_VL FC, HR_LOOKUPS L1, HR_LOOKUPS L2, HR_LOOKUPS L3, HR_LOOKUPS L4, HR_LOOKUPS L5, HR_LOOKUPS L6, HR_LOOKUPS L7, HR_LOOKUPS L8, HR_LOOKUPS L9, HR_ALL_ORGANIZATION_UNITS_TL AOUTL, HR_ALL_ORGANIZATION_UNITS AOU, HR_LOCATIONS_ALL_TL LOCTL, HR_LOCATIONS_NO_JOIN LOC, PER_GRADES_TL GDT WHERE SS.SALARY_SURVEY_ID=SL.SALARY_SURVEY_ID AND SL.SALARY_SURVEY_LINE_ID=PSM.SALARY_SURVEY_LINE_ID AND FC.CURRENCY_CODE=Sl.CURRENCY_CODE AND L1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY' AND L1.LOOKUP_CODE (+) = SS.SURVEY_COMPANY_CODE AND L2.LOOKUP_TYPE(+) = 'SURVEY_JOB_NAME' AND L2.LOOKUP_CODE(+) = SL.SURVEY_JOB_NAME_CODE AND L3.LOOKUP_TYPE(+) = 'SURVEY_REGION' AND L3.LOOKUP_CODE(+)= SL.SURVEY_REGION_CODE AND L4.LOOKUP_TYPE(+) = 'SURVEY_SENIORITY' AND L4.LOOKUP_CODE(+) = SL.SURVEY_SENIORITY_CODE AND L5.LOOKUP_TYPE(+) ='COMPANY_SIZE' AND L5.LOOKUP_CODE(+)= SL.COMPANY_SIZE_CODE AND L6.LOOKUP_TYPE(+) = 'INDUSTRY' AND L6.LOOKUP_CODE(+) = SL.INDUSTRY_CODE AND L7.LOOKUP_TYPE(+) = 'PQH_SURVEY_PAY_BASIS' AND L7.LOOKUP_CODE(+) = SS.SURVEY_TYPE_CODE AND L8.LOOKUP_TYPE(+) = 'COMPANY_AGE' AND L8.LOOKUP_CODE(+) = PSM.COMPANY_AGE_CODE AND L9.LOOKUP_TYPE(+) = 'SURVEY_AGE' AND L9.LOOKUP_CODE(+) = SL.SURVEY_AGE_CODE AND AOU.ORGANIZATION_ID (+) = PSM.COMPANY_ORGANIZATION_ID AND AOU.BUSINESS_GROUP_ID (+) = PSM.BUSINESS_GROUP_ID AND GDT.GRADE_ID (+) = PSM.GRADE_ID AND GDT.LANGUAGE(+) = userenv('LANG') AND LOC.LOCATION_ID (+) = PSM.LOCATION_ID AND LOC.LOCATION_ID = LOCTL.LOCATION_ID (+) AND AOU.ORGANIZATION_ID = AOUTL.ORGANIZATION_ID (+) AND DECODE(loctl.location_id,null,'1',loctl.language) = DECODE(loctl.location_id,null,'1',userenv('LANG')) AND DECODE(aoutl.organization_id,null,'1',aoutl.language) = DECODE(aoutl.organization_id,null,'1',userenv('LANG'))

View Text - HTML Formatted

SELECT PSM.ROWID ROW_ID
, PSM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PSM.SALARY_SURVEY_MAPPING_ID SALARY_SURVEY_MAPPING_ID
, PSM.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PSM.PARENT_ID PARENT_ID
, PSM.PARENT_TABLE_NAME PARENT_TABLE_NAME
, PSM.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, PSM.LOCATION_ID LOCATION_ID
, LOCTL.LOCATION_CODE LOCATION
, PSM.GRADE_ID GRADE_ID
, GDT.NAME GRADE
, PSM.COMPANY_AGE_CODE COMPANY_AGE_CODE
, L8.MEANING COMPANY_AGE
, PSM.COMPANY_ORGANIZATION_ID COMPANY_ORGANIZATION_ID
, AOUTL.NAME COMPANY_ORGANIZATION
, L1.MEANING SURVEY_COMPANY_NAME
, SS.SURVEY_NAME SURVEY_NAME
, L2.MEANING SURVEY_JOB_NAME
, L3.MEANING SURVEY_REGION
, L4.MEANING SURVEY_SENIORITY
, L5.MEANING COMPANY_SIZE
, L9.MEANING SURVEY_AGE
, L6.MEANING INDUSTRY
, FC.NAME CURRENCY
, L7.MEANING SURVEY_TYPE
, SS.BASE_REGION BASE_REGION
, SL.START_DATE START_DATE
, SL.END_DATE END_DATE
, SL.DIFFERENTIAL DIFFERENTIAL
, SL.MINIMUM_PAY MINIMUM_PAY
, SL.MEAN_PAY MEAN_PAY
, SL.MAXIMUM_PAY MAXIMUM_PAY
, SL.GRADUATE_PAY GRADUATE_PAY
, SL.STARTING_PAY STARTING_PAY
, SL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, SL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE
, SL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE
, SL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE
, SL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE
, SL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION
, SL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION
, SL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION
, SL.COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE
, SL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE
, SL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE
, SL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE
, PSM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PSM.ATTRIBUTE1 ATTRIBUTE1
, PSM.ATTRIBUTE2 ATTRIBUTE2
, PSM.ATTRIBUTE3 ATTRIBUTE3
, PSM.ATTRIBUTE4 ATTRIBUTE4
, PSM.ATTRIBUTE5 ATTRIBUTE5
, PSM.ATTRIBUTE6 ATTRIBUTE6
, PSM.ATTRIBUTE7 ATTRIBUTE7
, PSM.ATTRIBUTE8 ATTRIBUTE8
, PSM.ATTRIBUTE9 ATTRIBUTE9
, PSM.ATTRIBUTE10 ATTRIBUTE10
, PSM.ATTRIBUTE11 ATTRIBUTE11
, PSM.ATTRIBUTE12 ATTRIBUTE12
, PSM.ATTRIBUTE13 ATTRIBUTE13
, PSM.ATTRIBUTE14 ATTRIBUTE14
, PSM.ATTRIBUTE15 ATTRIBUTE15
, PSM.ATTRIBUTE16 ATTRIBUTE16
, PSM.ATTRIBUTE17 ATTRIBUTE17
, PSM.ATTRIBUTE18 ATTRIBUTE18
, PSM.ATTRIBUTE19 ATTRIBUTE19
, PSM.ATTRIBUTE20 ATTRIBUTE20
, PSM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSM.LAST_UPDATED_BY LAST_UPDATED_BY
, PSM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PSM.CREATED_BY CREATED_BY
, PSM.CREATION_DATE CREATION_DATE
, SL.TENTH_PERCENTILE TENTH_PERCENTILE
, SL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE
, SL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE
, SL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE
, SL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE
, SL.MINIMUM_BONUS MINIMUM_BONUS
, SL.MEAN_BONUS MEAN_BONUS
, SL.MAXIMUM_BONUS MAXIMUM_BONUS
, SL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE
, SL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE
, SL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE
, SL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION
, SL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION
, SL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION
, SL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE
, SL.MINIMUM_STOCK MINIMUM_STOCK
, SL.MEAN_STOCK MEAN_STOCK
, SL.MAXIMUM_STOCK MAXIMUM_STOCK
FROM PER_SALARY_SURVEYS SS
, PER_SALARY_SURVEY_LINES SL
, PER_SALARY_SURVEY_MAPPINGS PSM
, FND_CURRENCIES_VL FC
, HR_LOOKUPS L1
, HR_LOOKUPS L2
, HR_LOOKUPS L3
, HR_LOOKUPS L4
, HR_LOOKUPS L5
, HR_LOOKUPS L6
, HR_LOOKUPS L7
, HR_LOOKUPS L8
, HR_LOOKUPS L9
, HR_ALL_ORGANIZATION_UNITS_TL AOUTL
, HR_ALL_ORGANIZATION_UNITS AOU
, HR_LOCATIONS_ALL_TL LOCTL
, HR_LOCATIONS_NO_JOIN LOC
, PER_GRADES_TL GDT
WHERE SS.SALARY_SURVEY_ID=SL.SALARY_SURVEY_ID
AND SL.SALARY_SURVEY_LINE_ID=PSM.SALARY_SURVEY_LINE_ID
AND FC.CURRENCY_CODE=SL.CURRENCY_CODE
AND L1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY'
AND L1.LOOKUP_CODE (+) = SS.SURVEY_COMPANY_CODE
AND L2.LOOKUP_TYPE(+) = 'SURVEY_JOB_NAME'
AND L2.LOOKUP_CODE(+) = SL.SURVEY_JOB_NAME_CODE
AND L3.LOOKUP_TYPE(+) = 'SURVEY_REGION'
AND L3.LOOKUP_CODE(+)= SL.SURVEY_REGION_CODE
AND L4.LOOKUP_TYPE(+) = 'SURVEY_SENIORITY'
AND L4.LOOKUP_CODE(+) = SL.SURVEY_SENIORITY_CODE
AND L5.LOOKUP_TYPE(+) ='COMPANY_SIZE'
AND L5.LOOKUP_CODE(+)= SL.COMPANY_SIZE_CODE
AND L6.LOOKUP_TYPE(+) = 'INDUSTRY'
AND L6.LOOKUP_CODE(+) = SL.INDUSTRY_CODE
AND L7.LOOKUP_TYPE(+) = 'PQH_SURVEY_PAY_BASIS'
AND L7.LOOKUP_CODE(+) = SS.SURVEY_TYPE_CODE
AND L8.LOOKUP_TYPE(+) = 'COMPANY_AGE'
AND L8.LOOKUP_CODE(+) = PSM.COMPANY_AGE_CODE
AND L9.LOOKUP_TYPE(+) = 'SURVEY_AGE'
AND L9.LOOKUP_CODE(+) = SL.SURVEY_AGE_CODE
AND AOU.ORGANIZATION_ID (+) = PSM.COMPANY_ORGANIZATION_ID
AND AOU.BUSINESS_GROUP_ID (+) = PSM.BUSINESS_GROUP_ID
AND GDT.GRADE_ID (+) = PSM.GRADE_ID
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND LOC.LOCATION_ID (+) = PSM.LOCATION_ID
AND LOC.LOCATION_ID = LOCTL.LOCATION_ID (+)
AND AOU.ORGANIZATION_ID = AOUTL.ORGANIZATION_ID (+)
AND DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, LOCTL.LANGUAGE) = DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE(AOUTL.ORGANIZATION_ID
, NULL
, '1'
, AOUTL.LANGUAGE) = DECODE(AOUTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))