View: PQH_ORGANIZATION_BUDGETS_V

Product:	PQH - Public Sector HR
Description:	Organization Budget View
Implementation/DBA Data:	APPS.PQH_ORGANIZATION_BUDGETS_V

View Text

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

Columns