VIEW: APPS.PER_CONTRACTS_D

Source

View Text - Preformatted

SELECT pcf1.CONTRACT_ID, pcf1.EFFECTIVE_START_DATE, pcf1.EFFECTIVE_END_DATE, pcf1.REFERENCE, hr1.meaning, hr2.meaning, hr3.meaning, pcf1.DURATION, hr4.meaning, pcf1.CONTRACTUAL_JOB_TITLE, pcf1.PARTIES, hr5.meaning, hr6.meaning, pcf1.NUMBER_OF_EXTENSIONS, pcf1.EXTENSION_REASON, pcf1.EXTENSION_PERIOD, hr7.meaning, pcf1.LAST_UPDATE_DATE, usr.user_name from per_contracts_f pcf1, fnd_user usr,hr_lookups hr1, hr_lookups hr2, hr_lookups hr3, hr_lookups hr4, hr_lookups hr5, hr_lookups hr6, hr_lookups hr7 WHERE usr.user_id (+) = pcf1.last_updated_by and hr1.lookup_type (+) = 'CONTRACT_TYPE' and hr1.lookup_code = pcf1.TYPE and hr2.lookup_type (+) = 'CONTRACT_STATUS' and hr2.lookup_code (+) = pcf1.STATUS and hr3.lookup_type (+) = 'CONTRACT_STATUS_REASON' and hr3.lookup_code (+) = pcf1.STATUS_REASON and hr4.lookup_type (+) = 'QUALIFYING_UNITS' and hr4.lookup_code (+) = pcf1.DURATION_UNITS and hr5.lookup_type (+) = 'CONTRACT_START_REASON' and hr5.lookup_code (+) = pcf1.START_REASON and hr6.lookup_type (+) = 'CONTRACT_END_REASON' and hr6.lookup_code (+) = pcf1.END_REASON and hr7.lookup_type (+) = 'QUALIFYING_UNITS' and hr7.lookup_code (+) = pcf1.EXTENSION_PERIOD_UNITS

View Text - HTML Formatted

SELECT PCF1.CONTRACT_ID
, PCF1.EFFECTIVE_START_DATE
, PCF1.EFFECTIVE_END_DATE
, PCF1.REFERENCE
, HR1.MEANING
, HR2.MEANING
, HR3.MEANING
, PCF1.DURATION
, HR4.MEANING
, PCF1.CONTRACTUAL_JOB_TITLE
, PCF1.PARTIES
, HR5.MEANING
, HR6.MEANING
, PCF1.NUMBER_OF_EXTENSIONS
, PCF1.EXTENSION_REASON
, PCF1.EXTENSION_PERIOD
, HR7.MEANING
, PCF1.LAST_UPDATE_DATE
, USR.USER_NAME
FROM PER_CONTRACTS_F PCF1
, FND_USER USR
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, HR_LOOKUPS HR5
, HR_LOOKUPS HR6
, HR_LOOKUPS HR7
WHERE USR.USER_ID (+) = PCF1.LAST_UPDATED_BY
AND HR1.LOOKUP_TYPE (+) = 'CONTRACT_TYPE'
AND HR1.LOOKUP_CODE = PCF1.TYPE
AND HR2.LOOKUP_TYPE (+) = 'CONTRACT_STATUS'
AND HR2.LOOKUP_CODE (+) = PCF1.STATUS
AND HR3.LOOKUP_TYPE (+) = 'CONTRACT_STATUS_REASON'
AND HR3.LOOKUP_CODE (+) = PCF1.STATUS_REASON
AND HR4.LOOKUP_TYPE (+) = 'QUALIFYING_UNITS'
AND HR4.LOOKUP_CODE (+) = PCF1.DURATION_UNITS
AND HR5.LOOKUP_TYPE (+) = 'CONTRACT_START_REASON'
AND HR5.LOOKUP_CODE (+) = PCF1.START_REASON
AND HR6.LOOKUP_TYPE (+) = 'CONTRACT_END_REASON'
AND HR6.LOOKUP_CODE (+) = PCF1.END_REASON
AND HR7.LOOKUP_TYPE (+) = 'QUALIFYING_UNITS'
AND HR7.LOOKUP_CODE (+) = PCF1.EXTENSION_PERIOD_UNITS