ACE_RESOURCE_UTIL_MONTH_V

Details

• Schema: FUSION

• Object owner: ACE

• Object type: VIEW

Columns

Name
RESOURCE_ID CAL_MONTH_CODE CAL_MONTH CAL_MONTH_START_DATE CAL_MONTH_END_DATE PRODUCT_PROPOSAL_ID RESOURCE_POOL RESOURCE_STATUS START_DATE END_DATE RESOURCE_CATEGORY HEAD_COUNT_MONTH HEAD_COUNT_QUARTER HEAD_COUNT_YEAR SOURCE

Query

SQL_Statement

SELECT RES.RESOURCE_ID, MONTH.CAL_MONTH_CODE, MONTH.CAL_MONTH, MONTH.CAL_MONTH_START_DATE, MONTH.CAL_MONTH_END_DATE, RES.PRODUCT_PROPOSAL_ID, RES.RESOURCE_POOL, RES.RESOURCE_STATUS, RES.START_DATE, RES.END_DATE, RES.RESOURCE_CATEGORY, RES.RESOURCE_HEADCOUNT HEAD_COUNT_MONTH, RES.RESOURCE_HEADCOUNT HEAD_COUNT_QUARTER, RES.RESOURCE_HEADCOUNT HEAD_COUNT_YEAR, RES.SOURCE FROM ACD_RESOURCE RES, FND_CAL_MONTH MONTH WHERE MONTH.CAL_MONTH_START_DATE>=TRUNC(RES.START_DATE,'MM') AND MONTH.CAL_MONTH_END_DATE<=LAST_DAY(RES.END_DATE) ORDER BY MONTH.CAL_MONTH