VIEW: APPS.PQH_CORPS_CAREER_PATHS_V

Source

View Text - Preformatted

SELECT cpd_from.name from_corps_name, cpd_from.corps_definition_id from_corps_id, pqh_corps_copy.get_grade_name(nod.entity_id) from_grade, pqh_corps_copy.get_grade_id(nod.entity_id) from_grade_id, pqh_corps_copy.get_step_name(nod.entity_id) from_step, nod.entity_id starting_grade_step_id, nod.information5 from_seniority, hr_general.decode_lookup('FREQUENCY',nod.information6) from_seniority_desc, nod.information6 from_seniority_uom, cpd_to.name to_corps_name, cpd_to.corps_definition_id to_corps_id, nod.information7 to_seniority, nod.information8 to_seniority_uom, hr_general.decode_lookup('FREQUENCY',nod.information8) to_seniority_desc, pqh_corps_copy.get_grade_name(nod.information3) to_grade, pqh_corps_copy.get_step_name(nod.information3) to_step, pqh_corps_copy.get_grade_id(nod.information3) to_grade_id, nod.information3 ending_grade_step_id, nod.hierarchy_node_id node_id, nod.object_version_number object_version_number from per_gen_hierarchy_nodes nod, pqh_corps_definitions cpd_from, pqh_corps_definitions cpd_to where nod.node_type = 'CAREER_NODE' and nod.information4 = cpd_from.corps_definition_id and nod.information9 = cpd_to.corps_definition_id

View Text - HTML Formatted

SELECT CPD_FROM.NAME FROM_CORPS_NAME
, CPD_FROM.CORPS_DEFINITION_ID FROM_CORPS_ID
, PQH_CORPS_COPY.GET_GRADE_NAME(NOD.ENTITY_ID) FROM_GRADE
, PQH_CORPS_COPY.GET_GRADE_ID(NOD.ENTITY_ID) FROM_GRADE_ID
, PQH_CORPS_COPY.GET_STEP_NAME(NOD.ENTITY_ID) FROM_STEP
, NOD.ENTITY_ID STARTING_GRADE_STEP_ID
, NOD.INFORMATION5 FROM_SENIORITY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, NOD.INFORMATION6) FROM_SENIORITY_DESC
, NOD.INFORMATION6 FROM_SENIORITY_UOM
, CPD_TO.NAME TO_CORPS_NAME
, CPD_TO.CORPS_DEFINITION_ID TO_CORPS_ID
, NOD.INFORMATION7 TO_SENIORITY
, NOD.INFORMATION8 TO_SENIORITY_UOM
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, NOD.INFORMATION8) TO_SENIORITY_DESC
, PQH_CORPS_COPY.GET_GRADE_NAME(NOD.INFORMATION3) TO_GRADE
, PQH_CORPS_COPY.GET_STEP_NAME(NOD.INFORMATION3) TO_STEP
, PQH_CORPS_COPY.GET_GRADE_ID(NOD.INFORMATION3) TO_GRADE_ID
, NOD.INFORMATION3 ENDING_GRADE_STEP_ID
, NOD.HIERARCHY_NODE_ID NODE_ID
, NOD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM PER_GEN_HIERARCHY_NODES NOD
, PQH_CORPS_DEFINITIONS CPD_FROM
, PQH_CORPS_DEFINITIONS CPD_TO
WHERE NOD.NODE_TYPE = 'CAREER_NODE'
AND NOD.INFORMATION4 = CPD_FROM.CORPS_DEFINITION_ID
AND NOD.INFORMATION9 = CPD_TO.CORPS_DEFINITION_ID