ACE_RESOURCE_CAPACITY_MONTH_V

Details

• Schema: FUSION

• Object owner: ACE

• Object type: VIEW

Columns

Name
RESOURCE_CAPACITY_ID PORTFOLIO_ID UNIT_ID RESOURCE_POOL HEADCOUNT_PPU HEADCOUNT_MONTH HEADCOUNT_QUARTER HEADCOUNT_YEAR PERIOD_START_DATE PERIOD_END_DATE CAL_MONTH CAL_MONTH_START_DATE CAL_MONTH_END_DATE CAL_MONTH_CODE PARENT_QUARTER DURATION

Query

SQL_Statement

SELECT RES.RESOURCE_CAPACITY_ID, RES.PORTFOLIO_ID, PPU.UNIT_ID, RES.RESOURCE_POOL, RES.HEADCOUNT HEADCOUNT_PPU, RES.HEADCOUNT HEADCOUNT_MONTH, RES.HEADCOUNT HEADCOUNT_QUARTER, RES.HEADCOUNT HEADCOUNT_YEAR, PPU.START_DATE PERIOD_START_DATE, PPU.END_DATE PERIOD_END_DATE, MONTH.CAL_MONTH, MONTH.CAL_MONTH_START_DATE, MONTH.CAL_MONTH_END_DATE, MONTH.CAL_MONTH_CODE, MONTH.PARENT_QUARTER, PPU.DURATION FROM ACE_RESOURCE_CAPACITY RES, ACE_PLAN_PERIOD_UNITS_B PPU, FND_CAL_MONTH MONTH WHERE RES.PLAN_PERIOD_UNIT_ID=PPU.UNIT_ID AND MONTH.CAL_MONTH_START_DATE>=TRUNC(PPU.START_DATE,'MM') AND MONTH.CAL_MONTH_END_DATE<=LAST_DAY(PPU.END_DATE) ORDER BY PORTFOLIO_ID, UNIT_ID