View: PA_FCST_PERIODIC_DTL_V

Product:	PA - Projects
Description:	PA_PROJ_FCST_HDR_V is a view that shows project forecasting
Implementation/DBA Data:	APPS.PA_FCST_PERIODIC_DTL_V

View Text

SELECT FORECAST_EXISTS_FLAG
, PROJECT_ID
, Y1
, Y1_LEFTATTRIBUTE1
, Y1_LEFTATTRIBUTE2
, Y1_LEFTATTRIBUTE3
, DENSE_RANK() OVER (ORDER BY Y1
, PROJECT_ID) AS Y1_SEQ
, X1
, DENSE_RANK() OVER (PARTITION BY PROJECT_ID ORDER BY PERIOD_START_DATE ) AS X1_SEQ
, VALUE
, PERIOD_START_DATE
FROM ( SELECT 'Y' FORECAST_EXISTS_FLAG
, PR.PROJECT_ID PROJECT_ID
, PR.PROJECT_NAME||'('||PR.PROJECT_NUMBER||')' Y1
, PR.PROJECT_ORG_NAME Y1_LEFTATTRIBUTE1
, PR.CUSTOMER_NAME Y1_LEFTATTRIBUTE2
, PR.PROJECT_CURRENCY_CODE Y1_LEFTATTRIBUTE3
, 0 Y1_SEQ
, PR.PERIOD_NAME X1
, 0 X1_SEQ
, PR.VALUE VALUE
, PR.PERIOD_START_DATE PERIOD_START_DATE
FROM PA_FCST_PROJECT_SUM_V PR UNION ALL SELECT 'Y' FORECAST_EXISTS_FLAG
, PR.PROJECT_ID PROJECT_ID
, PR.PROJECT_NAME||'('||PR.PROJECT_NUMBER||')' Y1
, ORG.NAME Y1_LEFTATTRIBUTE1
, PR.CUSTOMER_NAME Y1_LEFTATTRIBUTE2
, PR.PROJECT_CURRENCY_CODE Y1_LEFTATTRIBUTE3
, 0 Y1_SEQ
, PER.PERIOD_NAME X1
, 0 X1_SEQ
, 0 VALUE
, PER.START_DATE PERIOD_START_DATE
FROM PA_FCST_PROJECT_LIST_V PR
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PA_FCST_PERIODS_TMP PER
, (SELECT PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE STARTDATE
, PA_FCST_GLOBAL.GETPROJFCSTENDDATE ENDDATE
FROM DUAL) FILTERBY
WHERE NOT EXISTS(SELECT NULL
FROM PA_BUDGET_VERSIONS BV
, PA_RESOURCE_ASSIGNMENTS RA
, PA_BUDGET_LINES BL
WHERE BV.PROJECT_ID = PR.PROJECT_ID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RA.BUDGET_VERSION_ID
AND RA.RESOURCE_LIST_MEMBER_ID = 103
AND BV.CURRENT_ORIGINAL_FLAG ='X'
AND BV.RESOURCE_ACCUMULATED_FLAG ='X'
AND RA.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND PER.PERIOD_NAME = BL.PERIOD_NAME)
AND ORG.ORGANIZATION_ID = PR.CARRYING_OUT_ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')
AND ((PER.START_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE) OR (PER.END_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE)) UNION ALL SELECT 'N' FORECAST_EXISTS_FLAG
, 0 PROJECT_ID
, NULL Y1
, NULL Y1_LEFTATTRIBUTE1
, NULL Y1_LEFTATTRIBUTE2
, NULL Y1_LEFTATTRIBUTE3
, 0 Y1_SEQ
, PER.PERIOD_NAME X1
, 0 X1_SEQ
, 0 VALUE
, PER.START_DATE PERIOD_START_DATE
FROM PA_FCST_PERIODS_TMP PER
, (SELECT PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE STARTDATE
, PA_FCST_GLOBAL.GETPROJFCSTENDDATE ENDDATE
FROM DUAL) FILTERBY
WHERE ((PER.START_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE) OR (PER.END_DATE BETWEEN FILTERBY.STARTDATE
AND FILTERBY.ENDDATE))) ORDER BY Y1
, PROJECT_ID
, PERIOD_START_DATE

Columns