ACD_RESOURCE_MONTH_V

Details

• Schema: FUSION

• Object owner: ACD

• Object type: VIEW

Columns

Name
RESOURCE_ID RN PRODUCT_PROPOSAL_ID RESOURCE_POOL RESOURCE_STATUS START_DATE END_DATE RESOURCE_CATEGORY HEAD_COUNT_MONTH HEAD_COUNT_QUARTER HEAD_COUNT_YEAR MONTH CAL_MONTH

Query

SQL_Statement

SELECT RES.RESOURCE_ID, RN, 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, ROUND (RES.RESOURCE_HEADCOUNT / 3, 4) HEAD_COUNT_QUARTER, ROUND (RES.RESOURCE_HEADCOUNT / 12, 4) HEAD_COUNT_YEAR, ADD_MONTHS (TRUNC (RES.START_DATE,'MM'), RN) MONTH, TO_NUMBER (TO_CHAR (ADD_MONTHS(TRUNC(RES.START_DATE,'MM'), RN),'YYYYQMM')) CAL_MONTH FROM ACD_RESOURCE RES, (SELECT ROWNUM-1 RN FROM FND_LOOKUP_VALUES WHERE ROWNUM <= (SELECT MAX (ROUND (MONTHS_BETWEEN(TRUNC(ADD_MONTHS(RES1.END_DATE,1), 'MM'), TRUNC(RES1.START_DATE)),0)) FROM ACD_RESOURCE RES1 ) ) WHERE MONTHS_BETWEEN(TRUNC(ADD_MONTHS(RES.END_DATE, 1),'MM'), TRUNC(RES.START_DATE,'MM')) > RN