View: PQH_PC_ORG_SUMMARY_V

Product:	PQH - Public Sector HR
Description:	Position Control Organization summary view for reports
Implementation/DBA Data:	APPS.PQH_PC_ORG_SUMMARY_V

View Text

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'

Columns