View: GMS_RXI_BURDEN_VARIANCE_SUM_V

View Text

SELECT AWARD_NUMBER
, PROJECT_NUMBER
, TASK_NUMBER
, PROJECT_ID
, TASK_ID
, AWARD_ID
, STATUS
, DECODE(STATUS
, 'CLOSED'
, 'N'
, 'Y') STATUS_FLAG
, END_DATE_ACTIVE
, DECODE(NVL(DIFF_AMOUNT
, 0)
, 0
, 'N'
, 'Y') REP_VARIANCE
, BTC_TOTAL
, ADJ_AMOUNT
, DIFF_AMOUNT
, BURDEN_SHOULD_BE
FROM (SELECT A.AWARD_NUMBER AWARD_NUMBER
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_NUMBER TASK_NUMBER
, P.PROJECT_ID
, T.TASK_ID
, A.AWARD_ID
, A.STATUS
, A.END_DATE_ACTIVE
, SUM(VAR.BTC_TOTAL) BTC_TOTAL
, SUM(VAR.ADJ_AMOUNT) ADJ_AMOUNT
, SUM(VAR.BURDEN_TOTAL) BURDEN_SHOULD_BE
, SUM(VAR.DIFF_AMOUNT ) DIFF_AMOUNT
FROM GMS_RXI_BURDEN_VARIANCE VAR
, PA_PROJECTS_ALL P
, GMS_AWARDS_ALL A
, PA_TASKS T
WHERE VAR.AWARD_ID = A.AWARD_ID
AND VAR.PROJECT_ID = P.PROJECT_ID
AND VAR.TASK_ID = T.TASK_ID GROUP BY A.AWARD_ID
, A.AWARD_NUMBER
, P.PROJECT_ID
, P.SEGMENT1
, T.TASK_ID
, T.TASK_NUMBER
, A.STATUS
, A.END_DATE_ACTIVE )
WHERE 1 = 1

Columns