VIEW: APPS.PQH_CORPS_TRAININGS_V

Source

View Text - Preformatted

SELECT corps_definition_id corps_definition_id, cei.corps_extra_info_id corps_extra_info_id, cei.object_version_number object_version_number, cei.information_type information_type, qtt.name qualification, cei.information3 qualification_id, org.name institution_name, cei.information4 institution_id, cei.information5 training_duration, cei.information6 training_duration_uom, hr_general.decode_lookup('FREQUENCY',cei.information6) uom_desc, hr_general.decode_lookup('PQH_CORPS_WAYS',cei.information7) joining_way, cei.information7 joining_way_cd, cei.information8 mandatory_flag from pqh_corps_extra_info cei , hr_organization_units org , per_qualification_types_tl qtt WHERE qtt.qualification_type_id = cei.information3 and qtt.language = userenv('LANG') and org.organization_id = cei.information4 and cei.information_type ='TRAINING'

View Text - HTML Formatted

SELECT CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CEI.CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, CEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CEI.INFORMATION_TYPE INFORMATION_TYPE
, QTT.NAME QUALIFICATION
, CEI.INFORMATION3 QUALIFICATION_ID
, ORG.NAME INSTITUTION_NAME
, CEI.INFORMATION4 INSTITUTION_ID
, CEI.INFORMATION5 TRAINING_DURATION
, CEI.INFORMATION6 TRAINING_DURATION_UOM
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, CEI.INFORMATION6) UOM_DESC
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_WAYS'
, CEI.INFORMATION7) JOINING_WAY
, CEI.INFORMATION7 JOINING_WAY_CD
, CEI.INFORMATION8 MANDATORY_FLAG
FROM PQH_CORPS_EXTRA_INFO CEI
, HR_ORGANIZATION_UNITS ORG
, PER_QUALIFICATION_TYPES_TL QTT
WHERE QTT.QUALIFICATION_TYPE_ID = CEI.INFORMATION3
AND QTT.LANGUAGE = USERENV('LANG')
AND ORG.ORGANIZATION_ID = CEI.INFORMATION4
AND CEI.INFORMATION_TYPE ='TRAINING'