[Home] [Help]
| Product: | GMS - Grants Accounting |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.AWARD_NUMBER AWARD_NUMBER
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_NUMBER TASK_NUMBER
, A.AWARD_ID
, T.TASK_ID
, P.PROJECT_ID
, A.STATUS
, DECODE(A.STATUS
, 'CLOSED'
, 'N'
, 'Y') STATUS_FLAG
, A.END_DATE_ACTIVE
, O.NAME EXPENDITURE_ORG
, VAR.EXPENDITURE_TYPE
, VAR.REQUEST_ID
, DECODE(VAR.DIFF_AMOUNT
, 0
, 'N'
, 'Y') REP_VARIANCE
, VAR.SOURCE_ID
, VAR.BTC_TOTAL BTC_TOTAL
, VAR.ADJ_AMOUNT ADJ_AMOUNT
, VAR.BURDEN_TOTAL BURDEN_SHOULD_BE
, VAR.DIFF_AMOUNT DIFF_AMOUNT
, VAR.RAW_COST RAW_COST
FROM GMS_RXI_BURDEN_VARIANCE VAR
, PA_PROJECTS_ALL P
, GMS_AWARDS_ALL A
, PA_TASKS T
, HR_ORGANIZATION_UNITS O
WHERE VAR.AWARD_ID = A.AWARD_ID
AND VAR.PROJECT_ID = P.PROJECT_ID
AND VAR.TASK_ID = T.TASK_ID
AND VAR.SOURCE_ID > 0
AND VAR.SOURCE_ORG_ID = O.ORGANIZATION_ID