View: PA_FCST_PROJ_ERR_V

Product:	PA - Projects
Description:	PA_PROJ_FCST_ERR_V is a view that shows project forecasting error information
Implementation/DBA Data:	APPS.PA_FCST_PROJ_ERR_V

View Text

SELECT PROJECT_ID
, ASSIGNMENT_NAME
, RESOURCE_NAME
, PERIOD_NAME
, PERIOD_START_DATE
, ERROR_MESSAGE
FROM ( SELECT PRJ_ASGN.PROJECT_ID PROJECT_ID
, PRJ_ASGN.ASSIGNMENT_NAME ASSIGNMENT_NAME
, DECODE(PRJ_ASGN.RESOURCE_ID
, NULL
, ''
, RES.NAME) RESOURCE_NAME
, BUD.PERIOD_NAME PERIOD_NAME
, BUD.START_DATE PERIOD_START_DATE
, FND_MESSAGE.GET_STRING('PA'
, RES_ASGN.PLAN_ERROR_CODE) ERROR_MESSAGE
FROM PA_RESOURCE_ASSIGNMENTS RES_ASGN
, PA_PROJECT_ASSIGNMENTS PRJ_ASGN
, PA_RESOURCES RES
, PA_BUDGET_LINES BUD
, PA_BUDGET_VERSIONS BV
, (SELECT PA_FCST_GLOBAL.GETPROJECTID PROJECTID
FROM DUAL) FILTERBY
WHERE BV.PROJECT_ID = FILTERBY.PROJECTID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RES_ASGN.BUDGET_VERSION_ID
AND PRJ_ASGN.ASSIGNMENT_ID(+) = RES_ASGN.PROJECT_ASSIGNMENT_ID
AND NVL(PRJ_ASGN.RESOURCE_ID
, 0) = RES.RESOURCE_ID(+)
AND BUD.RESOURCE_ASSIGNMENT_ID = RES_ASGN.RESOURCE_ASSIGNMENT_ID
AND RES_ASGN.PLAN_ERROR_CODE IS NOT NULL
AND RES_ASGN.PLAN_ERROR_CODE <> 'PA_FCST_NO_DISP_ERR' UNION ALL SELECT PRJ_ASGN.PROJECT_ID
, PRJ_ASGN.ASSIGNMENT_NAME
, DECODE(PRJ_ASGN.RESOURCE_ID
, NULL
, ''
, RES.NAME) RESOURCE_NAME
, BUD.PERIOD_NAME PERIOD_NAME
, BUD.START_DATE PERIOD_START_DATE
, FND_MESSAGE.GET_STRING('PA'
, BUD.REVENUE_REJECTION_CODE) ERROR_MESSAGE
FROM PA_RESOURCE_ASSIGNMENTS RES_ASGN
, PA_PROJECT_ASSIGNMENTS PRJ_ASGN
, PA_RESOURCES RES
, PA_BUDGET_LINES BUD
, PA_BUDGET_VERSIONS BV
, (SELECT PA_FCST_GLOBAL.GETPROJECTID PROJECTID
FROM DUAL) FILTERBY
WHERE BV.PROJECT_ID = FILTERBY.PROJECTID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RES_ASGN.BUDGET_VERSION_ID
AND PRJ_ASGN.ASSIGNMENT_ID = RES_ASGN.PROJECT_ASSIGNMENT_ID
AND NVL(PRJ_ASGN.RESOURCE_ID
, 0) = RES.RESOURCE_ID(+)
AND BUD.RESOURCE_ASSIGNMENT_ID = RES_ASGN.RESOURCE_ASSIGNMENT_ID
AND BUD.REVENUE_REJECTION_CODE IS NOT NULL UNION ALL SELECT PRJ_ASGN.PROJECT_ID PROJECT_ID
, PRJ_ASGN.ASSIGNMENT_NAME ASSIGNMENT_NAME
, DECODE(PRJ_ASGN.RESOURCE_ID
, NULL
, ''
, RES.NAME) RESOURCE_NAME
, BUD.PERIOD_NAME PERIOD_NAME
, BUD.START_DATE PERIOD_START_DATE
, FND_MESSAGE.GET_STRING('PA'
, BUD.COST_REJECTION_CODE) ERROR_MESSAGE
FROM PA_RESOURCE_ASSIGNMENTS RES_ASGN
, PA_PROJECT_ASSIGNMENTS PRJ_ASGN
, PA_RESOURCES RES
, PA_BUDGET_LINES BUD
, PA_BUDGET_VERSIONS BV
, (SELECT PA_FCST_GLOBAL.GETPROJECTID PROJECTID
FROM DUAL) FILTERBY
WHERE BV.PROJECT_ID = FILTERBY.PROJECTID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RES_ASGN.BUDGET_VERSION_ID
AND PRJ_ASGN.ASSIGNMENT_ID = RES_ASGN.PROJECT_ASSIGNMENT_ID
AND NVL(PRJ_ASGN.RESOURCE_ID
, 0) = RES.RESOURCE_ID(+)
AND BUD.RESOURCE_ASSIGNMENT_ID = RES_ASGN.RESOURCE_ASSIGNMENT_ID
AND BUD.COST_REJECTION_CODE IS NOT NULL UNION ALL SELECT PRJ_ASGN.PROJECT_ID PROJECT_ID
, PRJ_ASGN.ASSIGNMENT_NAME ASSIGNMENT_NAME
, DECODE(PRJ_ASGN.RESOURCE_ID
, NULL
, ''
, RES.NAME) RESOURCE_NAME
, BUD.PERIOD_NAME PERIOD_NAME
, BUD.START_DATE PERIOD_START_DATE
, FND_MESSAGE.GET_STRING('PA'
, BUD.BURDEN_REJECTION_CODE) ERROR_MESSAGE
FROM PA_RESOURCE_ASSIGNMENTS RES_ASGN
, PA_PROJECT_ASSIGNMENTS PRJ_ASGN
, PA_RESOURCES RES
, PA_BUDGET_LINES BUD
, PA_BUDGET_VERSIONS BV
, (SELECT PA_FCST_GLOBAL.GETPROJECTID PROJECTID
FROM DUAL) FILTERBY
WHERE BV.PROJECT_ID = FILTERBY.PROJECTID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RES_ASGN.BUDGET_VERSION_ID
AND PRJ_ASGN.ASSIGNMENT_ID = RES_ASGN.PROJECT_ASSIGNMENT_ID
AND PRJ_ASGN.PROJECT_ID = FILTERBY.PROJECTID
AND NVL(PRJ_ASGN.RESOURCE_ID
, 0) = RES.RESOURCE_ID(+)
AND BUD.RESOURCE_ASSIGNMENT_ID = RES_ASGN.RESOURCE_ASSIGNMENT_ID
AND BUD.BURDEN_REJECTION_CODE IS NOT NULL UNION ALL SELECT PRJ_ASGN.PROJECT_ID PROJECT_ID
, PRJ_ASGN.ASSIGNMENT_NAME ASSIGNMENT_NAME
, DECODE(PRJ_ASGN.RESOURCE_ID
, NULL
, ''
, RES.NAME) RESOURCE_NAME
, BUD.PERIOD_NAME PERIOD_NAME
, BUD.START_DATE PERIOD_START_DATE
, FND_MESSAGE.GET_STRING('PA'
, BUD.OTHER_REJECTION_CODE) ERROR_MESSAGE
FROM PA_RESOURCE_ASSIGNMENTS RES_ASGN
, PA_PROJECT_ASSIGNMENTS PRJ_ASGN
, PA_RESOURCES RES
, PA_BUDGET_LINES BUD
, PA_BUDGET_VERSIONS BV
, (SELECT PA_FCST_GLOBAL.GETPROJECTID PROJECTID
FROM DUAL) FILTERBY
WHERE BV.PROJECT_ID = FILTERBY.PROJECTID
AND BV.BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE'
AND BV.BUDGET_VERSION_ID = RES_ASGN.BUDGET_VERSION_ID
AND PRJ_ASGN.ASSIGNMENT_ID = RES_ASGN.PROJECT_ASSIGNMENT_ID
AND PRJ_ASGN.PROJECT_ID = FILTERBY.PROJECTID
AND NVL(PRJ_ASGN.RESOURCE_ID
, 0) = RES.RESOURCE_ID(+)
AND BUD.RESOURCE_ASSIGNMENT_ID = RES_ASGN.RESOURCE_ASSIGNMENT_ID
AND BUD.OTHER_REJECTION_CODE IS NOT NULL ) ORDER BY ASSIGNMENT_NAME
, RESOURCE_NAME
, PERIOD_START_DATE

Columns