eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PQH_ORGANIZATION_BUDGETS_V

Source

View Text - Preformatted


SELECT hr_general.DECODE_ORGANIZATION(bdt.organization_id) organization_name, bdt.organization_id organization_id, 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_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bgt.budget_id = bvr.budget_id AND bdt.budget_unit1_value is not null AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION' GROUP BY hr_general.DECODE_ORGANIZATION(bdt.organization_id), bdt.organization_id, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id), bdt.position_id , bgt.BUDGET_UNIT1, bgt.budget_unit1_id UNION SELECT hr_general.DECODE_ORGANIZATION(bdt.organization_id) organization_name, bdt.organization_id organization_id, 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_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bgt.budget_id= bvr.budget_id AND bdt.budget_unit2_value is not null AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION' GROUP BY hr_general.DECODE_ORGANIZATION(bdt.organization_id), bdt.organization_id, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id), bdt.position_id , bgt.BUDGET_UNIT2, bgt.budget_unit2_id UNION SELECT hr_general.DECODE_ORGANIZATION(bdt.organization_id) organization_name, bdt.organization_id organization_id, 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_budgets_v bgt, pqh_budget_versions bvr, pqh_budget_details bdt WHERE bgt.business_group_id = NVL(hr_general.get_business_group_id,bgt.business_group_id ) AND hr_general.effective_date between bvr.date_from and bvr.date_to AND bgt.budget_id = bvr.budget_id AND bdt.budget_unit3_value is not null AND bvr.budget_version_id = bdt.budget_version_id AND bdt.position_id is not null AND bgt.budgeted_entity_cd='POSITION' GROUP BY hr_general.DECODE_ORGANIZATION(bdt.organization_id), bdt.organization_id, hr_general.DECODE_POSITION_LATEST_NAME(bdt.position_id), bdt.position_id , bgt.BUDGET_UNIT3, bgt.budget_unit3_id

View Text - HTML Formatted

SELECT HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID) ORGANIZATION_NAME
, BDT.ORGANIZATION_ID ORGANIZATION_ID
, 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_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BDT.BUDGET_UNIT1_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION' GROUP BY HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID)
, BDT.ORGANIZATION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT1
, BGT.BUDGET_UNIT1_ID UNION SELECT HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID) ORGANIZATION_NAME
, BDT.ORGANIZATION_ID ORGANIZATION_ID
, 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_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID= BVR.BUDGET_ID
AND BDT.BUDGET_UNIT2_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION' GROUP BY HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID)
, BDT.ORGANIZATION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT2
, BGT.BUDGET_UNIT2_ID UNION SELECT HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID) ORGANIZATION_NAME
, BDT.ORGANIZATION_ID ORGANIZATION_ID
, 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_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BDT.BUDGET_UNIT3_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION' GROUP BY HR_GENERAL.DECODE_ORGANIZATION(BDT.ORGANIZATION_ID)
, BDT.ORGANIZATION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT3
, BGT.BUDGET_UNIT3_ID