View: PA_FCST_PERIODIC_SUM_V

Product:	PA - Projects
Description:	PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting
Implementation/DBA Data:	APPS.PA_FCST_PERIODIC_SUM_V

View Text

SELECT PR.PROJECT_CURRENCY_CODE
, BL.PERIOD_NAME
, BL.START_DATE
, DECODE(PA_FCST_GLOBAL.GETPROJFCSTSHOWAMOUNT
, 'REVENUE'
, ROUND(SUM(BL.REVENUE * DECODE (PA_FCST_GLOBAL.GETPROBABILITYPERFLAG
, 'N'
, 1
, DECODE(NVL(PR.PROBABILITY_PERCENTAGE
, 1)
, 1
, 1
, PR.PROBABILITY_PERCENTAGE/100)))
, 2)
, 'COST'
, ROUND(SUM(BL.BURDENED_COST * DECODE (PA_FCST_GLOBAL.GETPROBABILITYPERFLAG
, 'N'
, 1
, DECODE(NVL(PR.PROBABILITY_PERCENTAGE
, 1)
, 1
, 1
, PR.PROBABILITY_PERCENTAGE/100)))
, 2)
, 'LABOR_HOURS'
, ROUND(SUM(BL.QUANTITY * DECODE (PA_FCST_GLOBAL.GETPROBABILITYPERFLAG
, 'N'
, 1
, DECODE(NVL(PR.PROBABILITY_PERCENTAGE
, 1)
, 1
, 1
, PR.PROBABILITY_PERCENTAGE/100)))
, 2)
, 'MARGIN'
, ROUND(SUM((NVL(BL.REVENUE
, 0) - NVL(BL.BURDENED_COST
, 0)) * DECODE (PA_FCST_GLOBAL.GETPROBABILITYPERFLAG
, 'N'
, 1
, DECODE(NVL(PR.PROBABILITY_PERCENTAGE
, 1)
, 1
, 1
, PR.PROBABILITY_PERCENTAGE/100)))
, 2)
, 'MARGIN_PERCENTAGE'
, ROUND(SUM(DECODE(NVL(BL.REVENUE
, 0)
, 0
, 0
, (((NVL(BL.REVENUE
, 0) - NVL(BL.BURDENED_COST
, 0))*100)/ NVL(BL.REVENUE
, 0))) * DECODE (PA_FCST_GLOBAL.GETPROBABILITYPERFLAG
, 'N'
, 1
, DECODE(NVL(PR.PROBABILITY_PERCENTAGE
, 1)
, 1
, 1
, PR.PROBABILITY_PERCENTAGE/100)))
, 2)) VALUE
FROM PA_FCST_PROJECT_LIST_V PR
, PA_BUDGET_LINES BL
, PA_BUDGET_VERSIONS BV
, PA_RESOURCE_ASSIGNMENTS RA
, (SELECT PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE STARTDATE
, PA_FCST_GLOBAL.GETPROJFCSTENDDATE ENDDATE
FROM DUAL) FILTERBY
WHERE BL.RESOURCE_ASSIGNMENT_ID = RA.RESOURCE_ASSIGNMENT_ID
AND BV.BUDGET_VERSION_ID = RA.BUDGET_VERSION_ID
AND BV.BUDGET_TYPE_CODE ='FORECASTING_BUDGET_TYPE'
AND PR.PROJECT_ID =BV.PROJECT_ID
AND BV.CURRENT_ORIGINAL_FLAG ='X'
AND BV.RESOURCE_ACCUMULATED_FLAG ='X'
AND RA.RESOURCE_LIST_MEMBER_ID = 103
AND ((BL.START_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE) OR (BL.END_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE)) GROUP BY PR.PROJECT_CURRENCY_CODE
, BL.PERIOD_NAME
, BL.START_DATE

Columns