Product: | PSP - Labor Distribution |
---|---|
Description: | Shows the schedule lines in matrix block in the Schedule Lines window |
Implementation/DBA Data: | APPS.PSP_MATRIX_DRIVER_V |
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