Product: | PSP - Labor Distribution |
---|---|
Description: | Based on the PSP_MATRIX_DRIVER3 table |
Implementation/DBA Data: | APPS.PSP_MATRIX_DRIVER3_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.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_DRIVER3 A
, PSP_MATRIX_DRIVER3 B
, PSP_MATRIX_DRIVER3 C
, PSP_MATRIX_DRIVER3 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_DRIVER3_PKG.GET_START_PERIOD(0)
AND A.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND B.PERIOD(+) = PSP_MATRIX_DRIVER3_PKG.GET_START_PERIOD(-1)
AND B.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND C.PERIOD(+) = PSP_MATRIX_DRIVER3_PKG.GET_START_PERIOD(-2)
AND C.SCHEDULE_LINE_ID(+) = LIN.SCHEDULE_LINE_ID
AND D.PERIOD(+) = PSP_MATRIX_DRIVER3_PKG.GET_START_PERIOD(-3)
AND D.SCHEDULE_LINE_ID (+)= LIN.SCHEDULE_LINE_ID