GMS_AWARD_PROJECT_FUNDINGS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID BUDGET_PERIOD_ID START_DATE END_DATE PROJECT_ID PTD_LC_FUND_AMOUNT ITD_LC_FUND_AMOUNT PTD_FUND_AMOUNT ITD_FUND_AMOUNT

Query

SQL_Statement

SELECT T.AWARD_ID, T.ID AS BUDGET_PERIOD_ID, T.START_DATE, T.END_DATE, G.PROJECT_ID, NVL(G.PTD_LC_FUNDING_AMOUNT, 0) AS PTD_LC_FUND_AMOUNT, SUM(NVL(G.PTD_LC_FUNDING_AMOUNT, 0)) OVER (PARTITION BY G.AWARD_ID, G.PROJECT_ID ORDER BY T.START_DATE ROWS UNBOUNDED PRECEDING) AS ITD_LC_FUND_AMOUNT, NVL(G.PTD_FUNDING_AMOUNT, 0) AS PTD_FUND_AMOUNT, SUM(NVL(G.PTD_FUNDING_AMOUNT, 0)) OVER (PARTITION BY G.AWARD_ID, G.PROJECT_ID ORDER BY T.START_DATE ROWS UNBOUNDED PRECEDING) AS ITD_FUND_AMOUNT FROM (SELECT B2.AWARD_ID, B2.PROJECT_ID, B2.BUDGET_PERIOD_ID, B2.START_DATE, B2.END_DATE, SUM(A2.LC_FUNDING_AMOUNT) AS PTD_LC_FUNDING_AMOUNT, SUM(A2.FUNDING_AMOUNT) AS PTD_FUNDING_AMOUNT FROM GMS_PROJECT_PERIOD_FUNDINGS_V A2, GMS_PROJECT_BUDGET_PERIODS_V B2 WHERE A2.LINKAGE_ID(+) = B2.LINKAGE_ID AND A2.AWARD_ID(+) = B2.AWARD_ID AND A2.BUDGET_PERIOD_ID(+) = B2.BUDGET_PERIOD_ID GROUP BY B2.AWARD_ID, B2.PROJECT_ID, B2.BUDGET_PERIOD_ID, B2.START_DATE, B2.END_DATE) G, GMS_AWARD_BUDGET_PERIODS T WHERE G.BUDGET_PERIOD_ID = T.ID AND G.AWARD_ID = T.AWARD_ID ORDER BY T.AWARD_ID, G.PROJECT_ID, T.START_DATE