VIEW: APPS.PQH_PC_ORG_SUMMARY_V

Source

View Text - Preformatted

SELECT pch.row_num row_num, pch.hierarchy_level hierarchy_level, pch.business_group_name business_group_name, pch.business_group_id business_group_id, pch.organization_name organization_name, pch.organization_id organization_id, pch.pc_enabled_flag pc_enabled_flag, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id) position_name, bdt.position_id position_id, bgt.BUDGET_UNIT1 BUDGET_MEASUREMENT_TYPE, bgt.budget_unit1_id budget_unit_id FROM pqh_posn_ctl_hierarchy_v pch, pqh_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.budget_id = bvr.budget_id AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bvr.budget_version_id = bdt.budget_version_id AND bdt.organization_id = pch.organization_id AND bdt.budget_unit1_value is not null AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION' UNION SELECT pch.row_num, pch.hierarchy_level, pch.business_group_name, pch.business_group_id, pch.organization_name, pch.organization_id, pch.pc_enabled_flag, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id) position_name, bdt.position_id position_id, bgt.BUDGET_UNIT2 BUDGET_MEASUREMENT_TYPE, bgt.budget_unit2_id budget_unit_id FROM pqh_posn_ctl_hierarchy_v pch, pqh_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.budget_id = bvr.budget_id AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bvr.budget_version_id = bdt.budget_version_id AND bdt.organization_id = pch.organization_id AND bdt.budget_unit2_value is not null AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION' UNION SELECT pch.row_num, pch.hierarchy_level, pch.business_group_name, pch.business_group_id, pch.organization_name, pch.organization_id, pch.pc_enabled_flag, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id) position_name, bdt.position_id position_id, bgt.BUDGET_UNIT3 BUDGET_MEASUREMENT_TYPE, bgt.budget_unit3_id budget_unit_id FROM pqh_posn_ctl_hierarchy_v pch, pqh_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.budget_id = bvr.budget_id AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bvr.budget_version_id = bdt.budget_version_id AND bdt.organization_id = pch.organization_id AND bdt.budget_unit3_value is not null AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION'

View Text - HTML Formatted

SELECT PCH.ROW_NUM ROW_NUM
, PCH.HIERARCHY_LEVEL HIERARCHY_LEVEL
, PCH.BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PCH.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PCH.ORGANIZATION_NAME ORGANIZATION_NAME
, PCH.ORGANIZATION_ID ORGANIZATION_ID
, PCH.PC_ENABLED_FLAG PC_ENABLED_FLAG
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT1 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT_ID
FROM PQH_POSN_CTL_HIERARCHY_V PCH
, PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.ORGANIZATION_ID = PCH.ORGANIZATION_ID
AND BDT.BUDGET_UNIT1_VALUE IS NOT NULL
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION' UNION SELECT PCH.ROW_NUM
, PCH.HIERARCHY_LEVEL
, PCH.BUSINESS_GROUP_NAME
, PCH.BUSINESS_GROUP_ID
, PCH.ORGANIZATION_NAME
, PCH.ORGANIZATION_ID
, PCH.PC_ENABLED_FLAG
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT2 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT_ID
FROM PQH_POSN_CTL_HIERARCHY_V PCH
, PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.ORGANIZATION_ID = PCH.ORGANIZATION_ID
AND BDT.BUDGET_UNIT2_VALUE IS NOT NULL
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION' UNION SELECT PCH.ROW_NUM
, PCH.HIERARCHY_LEVEL
, PCH.BUSINESS_GROUP_NAME
, PCH.BUSINESS_GROUP_ID
, PCH.ORGANIZATION_NAME
, PCH.ORGANIZATION_ID
, PCH.PC_ENABLED_FLAG
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT3 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT_ID
FROM PQH_POSN_CTL_HIERARCHY_V PCH
, PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.ORGANIZATION_ID = PCH.ORGANIZATION_ID
AND BDT.BUDGET_UNIT3_VALUE IS NOT NULL
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION'