VIEW: APPS.PSP_MATRIX_DRIVER2_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.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_DRIVER2 A, PSP_MATRIX_DRIVER2 B, PSP_MATRIX_DRIVER2 C, PSP_MATRIX_DRIVER2 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.PERIOD(+) = psp_matrix_driver2_pkg.GET_START_PERIOD(0) AND A.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID AND B.PERIOD(+) = psp_matrix_driver2_pkg.GET_START_PERIOD(-1) AND B.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID AND C.PERIOD(+) = psp_matrix_driver2_pkg.GET_START_PERIOD(-2) AND C.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID AND D.PERIOD(+) = psp_matrix_driver2_pkg.GET_START_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.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_DRIVER2 A
, PSP_MATRIX_DRIVER2 B
, PSP_MATRIX_DRIVER2 C
, PSP_MATRIX_DRIVER2 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.PERIOD(+) = PSP_MATRIX_DRIVER2_PKG.GET_START_PERIOD(0)
AND A.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND B.PERIOD(+) = PSP_MATRIX_DRIVER2_PKG.GET_START_PERIOD(-1)
AND B.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND C.PERIOD(+) = PSP_MATRIX_DRIVER2_PKG.GET_START_PERIOD(-2)
AND C.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND D.PERIOD(+) = PSP_MATRIX_DRIVER2_PKG.GET_START_PERIOD(-3)
AND D.SCHEDULE_LINE_ID (+)= LIN.SCHEDULE_LINE_ID