VIEW: APPS.PER_SALARY_SURVEY_LINES_V

Source

View Text - Preformatted

SELECT SSL.ROWID ROW_ID , SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID , SSL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , SSL.SALARY_SURVEY_ID SALARY_SURVEY_ID , SSL.SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE , SSL.SURVEY_REGION_CODE SURVEY_REGION_CODE , SSL.SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE , SSL.COMPANY_SIZE_CODE COMPANY_SIZE_CODE , SSL.INDUSTRY_CODE INDUSTRY_CODE , SSL.SURVEY_AGE_CODE SURVEY_AGE_CODE , SSL.CURRENCY_CODE CURRENCY_CODE , HL1.MEANING MEANING , HL2.MEANING MEANING , HL3.MEANING MEANING , HL4.MEANING MEANING , HL5.MEANING MEANING , HL6.MEANING MEANING , FCV.NAME NAME , SSL.START_DATE START_DATE , SSL.END_DATE END_DATE , SSL.DIFFERENTIAL DIFFERENTIAL , 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 COMPNSTN_FIRST_QUARTILE , SSL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE , SSL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE , SSL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE , SSL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , SSL.ATTRIBUTE1 ATTRIBUTE1 , SSL.ATTRIBUTE2 ATTRIBUTE2 , SSL.ATTRIBUTE3 ATTRIBUTE3 , SSL.ATTRIBUTE4 ATTRIBUTE4 , SSL.ATTRIBUTE5 ATTRIBUTE5 , SSL.ATTRIBUTE6 ATTRIBUTE6 , SSL.ATTRIBUTE7 ATTRIBUTE7 , SSL.ATTRIBUTE8 ATTRIBUTE8 , SSL.ATTRIBUTE9 ATTRIBUTE9 , SSL.ATTRIBUTE10 ATTRIBUTE10 , SSL.ATTRIBUTE11 ATTRIBUTE11 , SSL.ATTRIBUTE12 ATTRIBUTE12 , SSL.ATTRIBUTE13 ATTRIBUTE13 , SSL.ATTRIBUTE14 ATTRIBUTE14 , SSL.ATTRIBUTE15 ATTRIBUTE15 , SSL.ATTRIBUTE16 ATTRIBUTE16 , SSL.ATTRIBUTE17 ATTRIBUTE17 , SSL.ATTRIBUTE18 ATTRIBUTE18 , SSL.ATTRIBUTE19 ATTRIBUTE19 , SSL.ATTRIBUTE20 ATTRIBUTE20 , SSL.LAST_UPDATE_DATE LAST_UPDATE_DATE , SSL.LAST_UPDATED_BY LAST_UPDATED_BY , SSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , SSL.CREATED_BY CREATED_BY , SSL.CREATION_DATE CREATION_DATE , SSL.ATTRIBUTE21 ATTRIBUTE21 , SSL.ATTRIBUTE22 ATTRIBUTE22 , SSL.ATTRIBUTE23 ATTRIBUTE23 , SSL.ATTRIBUTE24 ATTRIBUTE24 , SSL.ATTRIBUTE25 ATTRIBUTE25 , SSL.ATTRIBUTE26 ATTRIBUTE26 , SSL.ATTRIBUTE27 ATTRIBUTE27 , SSL.ATTRIBUTE28 ATTRIBUTE28 , SSL.ATTRIBUTE29 ATTRIBUTE29 , SSL.ATTRIBUTE30 ATTRIBUTE30 , SSL.TENTH_PERCENTILE TENTH_PERCENTILE, SSL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE , SSL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE , SSL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE , SSL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE , SSL.MINIMUM_BONUS MINIMUM_BONUS , SSL.MEAN_BONUS MEAN_BONUS , SSL.MAXIMUM_BONUS MAXIMUM_BONUS , SSL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE , SSL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE , SSL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE , SSL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION , SSL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION , SSL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION , HL7.MEANING STOCK_DISPLAY_TYPE , SSL.MINIMUM_STOCK MINIMUM_STOCK , SSL.MEAN_STOCK MEAN_STOCK , SSL.MAXIMUM_STOCK MAXIMUM_STOCK , SSL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE_CODE FROM PER_SALARY_SURVEY_LINES SSL ,HR_LOOKUPS HL1 ,HR_LOOKUPS HL2 ,HR_LOOKUPS HL3 ,HR_LOOKUPS HL4 ,HR_LOOKUPS HL5 ,HR_LOOKUPS HL6 ,HR_LOOKUPS HL7 ,FND_CURRENCIES_VL FCV WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_JOB_NAME' AND HL1.LOOKUP_CODE (+) = SSL.SURVEY_JOB_NAME_CODE AND HL2.LOOKUP_TYPE(+) = 'SURVEY_REGION' AND HL2.LOOKUP_CODE(+) = SSL.SURVEY_REGION_CODE AND HL3.LOOKUP_TYPE(+) ='SURVEY_SENIORITY' AND HL3.LOOKUP_CODE(+)= SSL.SURVEY_SENIORITY_CODE AND HL4.LOOKUP_TYPE(+) = 'COMPANY_SIZE' AND HL4.LOOKUP_CODE(+) = SSL.COMPANY_SIZE_CODE AND HL5.LOOKUP_TYPE(+) ='INDUSTRY' AND HL5.LOOKUP_CODE(+)= SSL.INDUSTRY_CODE AND HL6.LOOKUP_TYPE(+) ='SURVEY_AGE' AND HL6.LOOKUP_CODE(+)= SSL.SURVEY_AGE_CODE AND HL7.LOOKUP_TYPE(+) ='STOCK_DISPLAY_TYPE' AND HL7.LOOKUP_CODE(+)= SSL.STOCK_DISPLAY_TYPE AND FCV.CURRENCY_CODE(+)= SSL.CURRENCY_CODE

View Text - HTML Formatted

SELECT SSL.ROWID ROW_ID
, SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, SSL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SSL.SALARY_SURVEY_ID SALARY_SURVEY_ID
, SSL.SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE
, SSL.SURVEY_REGION_CODE SURVEY_REGION_CODE
, SSL.SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE
, SSL.COMPANY_SIZE_CODE COMPANY_SIZE_CODE
, SSL.INDUSTRY_CODE INDUSTRY_CODE
, SSL.SURVEY_AGE_CODE SURVEY_AGE_CODE
, SSL.CURRENCY_CODE CURRENCY_CODE
, HL1.MEANING MEANING
, HL2.MEANING MEANING
, HL3.MEANING MEANING
, HL4.MEANING MEANING
, HL5.MEANING MEANING
, HL6.MEANING MEANING
, FCV.NAME NAME
, SSL.START_DATE START_DATE
, SSL.END_DATE END_DATE
, SSL.DIFFERENTIAL DIFFERENTIAL
, 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 COMPNSTN_FIRST_QUARTILE
, SSL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE
, SSL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE
, SSL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE
, SSL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SSL.ATTRIBUTE1 ATTRIBUTE1
, SSL.ATTRIBUTE2 ATTRIBUTE2
, SSL.ATTRIBUTE3 ATTRIBUTE3
, SSL.ATTRIBUTE4 ATTRIBUTE4
, SSL.ATTRIBUTE5 ATTRIBUTE5
, SSL.ATTRIBUTE6 ATTRIBUTE6
, SSL.ATTRIBUTE7 ATTRIBUTE7
, SSL.ATTRIBUTE8 ATTRIBUTE8
, SSL.ATTRIBUTE9 ATTRIBUTE9
, SSL.ATTRIBUTE10 ATTRIBUTE10
, SSL.ATTRIBUTE11 ATTRIBUTE11
, SSL.ATTRIBUTE12 ATTRIBUTE12
, SSL.ATTRIBUTE13 ATTRIBUTE13
, SSL.ATTRIBUTE14 ATTRIBUTE14
, SSL.ATTRIBUTE15 ATTRIBUTE15
, SSL.ATTRIBUTE16 ATTRIBUTE16
, SSL.ATTRIBUTE17 ATTRIBUTE17
, SSL.ATTRIBUTE18 ATTRIBUTE18
, SSL.ATTRIBUTE19 ATTRIBUTE19
, SSL.ATTRIBUTE20 ATTRIBUTE20
, SSL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SSL.LAST_UPDATED_BY LAST_UPDATED_BY
, SSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SSL.CREATED_BY CREATED_BY
, SSL.CREATION_DATE CREATION_DATE
, SSL.ATTRIBUTE21 ATTRIBUTE21
, SSL.ATTRIBUTE22 ATTRIBUTE22
, SSL.ATTRIBUTE23 ATTRIBUTE23
, SSL.ATTRIBUTE24 ATTRIBUTE24
, SSL.ATTRIBUTE25 ATTRIBUTE25
, SSL.ATTRIBUTE26 ATTRIBUTE26
, SSL.ATTRIBUTE27 ATTRIBUTE27
, SSL.ATTRIBUTE28 ATTRIBUTE28
, SSL.ATTRIBUTE29 ATTRIBUTE29
, SSL.ATTRIBUTE30 ATTRIBUTE30
, SSL.TENTH_PERCENTILE TENTH_PERCENTILE
, SSL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE
, SSL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE
, SSL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE
, SSL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE
, SSL.MINIMUM_BONUS MINIMUM_BONUS
, SSL.MEAN_BONUS MEAN_BONUS
, SSL.MAXIMUM_BONUS MAXIMUM_BONUS
, SSL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE
, SSL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE
, SSL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE
, SSL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION
, SSL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION
, SSL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION
, HL7.MEANING STOCK_DISPLAY_TYPE
, SSL.MINIMUM_STOCK MINIMUM_STOCK
, SSL.MEAN_STOCK MEAN_STOCK
, SSL.MAXIMUM_STOCK MAXIMUM_STOCK
, SSL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE_CODE
FROM PER_SALARY_SURVEY_LINES SSL
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, HR_LOOKUPS HL5
, HR_LOOKUPS HL6
, HR_LOOKUPS HL7
, FND_CURRENCIES_VL FCV
WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_JOB_NAME'
AND HL1.LOOKUP_CODE (+) = SSL.SURVEY_JOB_NAME_CODE
AND HL2.LOOKUP_TYPE(+) = 'SURVEY_REGION'
AND HL2.LOOKUP_CODE(+) = SSL.SURVEY_REGION_CODE
AND HL3.LOOKUP_TYPE(+) ='SURVEY_SENIORITY'
AND HL3.LOOKUP_CODE(+)= SSL.SURVEY_SENIORITY_CODE
AND HL4.LOOKUP_TYPE(+) = 'COMPANY_SIZE'
AND HL4.LOOKUP_CODE(+) = SSL.COMPANY_SIZE_CODE
AND HL5.LOOKUP_TYPE(+) ='INDUSTRY'
AND HL5.LOOKUP_CODE(+)= SSL.INDUSTRY_CODE
AND HL6.LOOKUP_TYPE(+) ='SURVEY_AGE'
AND HL6.LOOKUP_CODE(+)= SSL.SURVEY_AGE_CODE
AND HL7.LOOKUP_TYPE(+) ='STOCK_DISPLAY_TYPE'
AND HL7.LOOKUP_CODE(+)= SSL.STOCK_DISPLAY_TYPE
AND FCV.CURRENCY_CODE(+)= SSL.CURRENCY_CODE