eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FCST_PROJ_ERR_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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