VIEW: APPS.PSP_MATRIX_DRIVER_V

Source

View Text - Preformatted

SELECT lin.rowid , lin.schedule_hierarchy_id, lin.schedule_line_id, lin.gl_code_combination_id, lin.project_id, p.segment1, lin.expenditure_organization_id, org.name, lin.expenditure_type, ta.task_id, ta.task_number, lin.award_id, nvl(aw.AWARD_NUMBER, decode(lin.award_id, psp_organization_accounts_pkg.return_default_award_id, psp_organization_accounts_pkg.return_default_award_number)) award_number, lin.schedule_begin_date, lin.schedule_end_date, lin.schedule_percent, a.period_schedule_percent, b.period_schedule_percent, c.period_schedule_percent, d.period_schedule_percent, lin.LAST_UPDATE_DATE, lin.LAST_UPDATED_BY, lin.LAST_UPDATE_LOGIN, lin.CREATED_BY, lin.CREATION_DATE, lin.business_group_id, lin.set_of_books_id ,LIN.ATTRIBUTE_CATEGORY ,LIN.ATTRIBUTE1 ,LIN.ATTRIBUTE2 ,LIN.ATTRIBUTE3 ,LIN.ATTRIBUTE4 ,LIN.ATTRIBUTE5 ,LIN.ATTRIBUTE6 ,LIN.ATTRIBUTE7 ,LIN.ATTRIBUTE8 ,LIN.ATTRIBUTE9 ,LIN.ATTRIBUTE10 from pa_projects_all p, hr_all_organization_units org, pa_tasks_expend_v ta, gms_awards aw, psp_matrix_driver a, psp_matrix_driver b, psp_matrix_driver c, psp_matrix_driver d, psp_schedule_lines lin where ta.task_id(+) = lin.task_id and p.project_id(+) = lin.project_id and org.organization_id(+) = lin.expenditure_organization_id and aw.award_id(+) = lin.award_id and a.run_id(+) = psp_matrix_driver_pkg.get_run_id and b.run_id(+) = psp_matrix_driver_pkg.get_run_id and c.run_id(+) = psp_matrix_driver_pkg.get_run_id and d.run_id(+) = psp_matrix_driver_pkg.get_run_id and a.period_start_date(+) = psp_matrix_driver_pkg.get_start_period(0) and a.period_end_date(+) = psp_matrix_driver_pkg.get_end_period(0) and a.schedule_line_id(+) = lin.schedule_line_id and b.period_start_date(+) = psp_matrix_driver_pkg.get_start_period(-1) and b.period_end_date(+) = psp_matrix_driver_pkg.get_end_period(-1) and b.schedule_line_id(+) = lin.schedule_line_id and c.period_start_date(+) = psp_matrix_driver_pkg.get_start_period(-2) and c.period_end_date(+) = psp_matrix_driver_pkg.get_end_period(-2) and c.schedule_line_id(+) = lin.schedule_line_id and d.period_start_date(+) = psp_matrix_driver_pkg.get_start_period(-3) and d.period_end_date(+) = psp_matrix_driver_pkg.get_end_period(-3) and d.schedule_line_id (+)= lin.schedule_line_id

View Text - HTML Formatted

SELECT LIN.ROWID
, LIN.SCHEDULE_HIERARCHY_ID
, LIN.SCHEDULE_LINE_ID
, LIN.GL_CODE_COMBINATION_ID
, LIN.PROJECT_ID
, P.SEGMENT1
, LIN.EXPENDITURE_ORGANIZATION_ID
, ORG.NAME
, LIN.EXPENDITURE_TYPE
, TA.TASK_ID
, TA.TASK_NUMBER
, LIN.AWARD_ID
, NVL(AW.AWARD_NUMBER
, DECODE(LIN.AWARD_ID
, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_ID
, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_NUMBER)) AWARD_NUMBER
, LIN.SCHEDULE_BEGIN_DATE
, LIN.SCHEDULE_END_DATE
, LIN.SCHEDULE_PERCENT
, A.PERIOD_SCHEDULE_PERCENT
, B.PERIOD_SCHEDULE_PERCENT
, C.PERIOD_SCHEDULE_PERCENT
, D.PERIOD_SCHEDULE_PERCENT
, LIN.LAST_UPDATE_DATE
, LIN.LAST_UPDATED_BY
, LIN.LAST_UPDATE_LOGIN
, LIN.CREATED_BY
, LIN.CREATION_DATE
, LIN.BUSINESS_GROUP_ID
, LIN.SET_OF_BOOKS_ID
, LIN.ATTRIBUTE_CATEGORY
, LIN.ATTRIBUTE1
, LIN.ATTRIBUTE2
, LIN.ATTRIBUTE3
, LIN.ATTRIBUTE4
, LIN.ATTRIBUTE5
, LIN.ATTRIBUTE6
, LIN.ATTRIBUTE7
, LIN.ATTRIBUTE8
, LIN.ATTRIBUTE9
, LIN.ATTRIBUTE10
FROM PA_PROJECTS_ALL P
, HR_ALL_ORGANIZATION_UNITS ORG
, PA_TASKS_EXPEND_V TA
, GMS_AWARDS AW
, PSP_MATRIX_DRIVER A
, PSP_MATRIX_DRIVER B
, PSP_MATRIX_DRIVER C
, PSP_MATRIX_DRIVER D
, PSP_SCHEDULE_LINES LIN
WHERE TA.TASK_ID(+) = LIN.TASK_ID
AND P.PROJECT_ID(+) = LIN.PROJECT_ID
AND ORG.ORGANIZATION_ID(+) = LIN.EXPENDITURE_ORGANIZATION_ID
AND AW.AWARD_ID(+) = LIN.AWARD_ID
AND A.RUN_ID(+) = PSP_MATRIX_DRIVER_PKG.GET_RUN_ID
AND B.RUN_ID(+) = PSP_MATRIX_DRIVER_PKG.GET_RUN_ID
AND C.RUN_ID(+) = PSP_MATRIX_DRIVER_PKG.GET_RUN_ID
AND D.RUN_ID(+) = PSP_MATRIX_DRIVER_PKG.GET_RUN_ID
AND A.PERIOD_START_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_START_PERIOD(0)
AND A.PERIOD_END_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_END_PERIOD(0)
AND A.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND B.PERIOD_START_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_START_PERIOD(-1)
AND B.PERIOD_END_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_END_PERIOD(-1)
AND B.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND C.PERIOD_START_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_START_PERIOD(-2)
AND C.PERIOD_END_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_END_PERIOD(-2)
AND C.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND D.PERIOD_START_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_START_PERIOD(-3)
AND D.PERIOD_END_DATE(+) = PSP_MATRIX_DRIVER_PKG.GET_END_PERIOD(-3)
AND D.SCHEDULE_LINE_ID (+)= LIN.SCHEDULE_LINE_ID