[Home] [Help]
MATERIALIZED VIEW: APPS.HRI_MDP_BDGTS_HDCNT_ORG_MV
Source
SELECT /* 12.0: bug#4526784 */ orgmgr_id ORGMGR_ID
,effective_start_date EFFECTIVE_START_DATE
,effective_end_date EFFECTIVE_END_DATE
,organization_id ORGANIZATION_ID
,budget_aggregate BUDGET_AGGREGATE
,sum(headcount_value) HEADCOUNT_VALUE
FROM hri_mdp_bdgts_hdcnt_orgmgr_ct
GROUP BY orgmgr_id
,effective_start_date
,effective_end_date
,organization_id
,budget_aggregate