GMS_FUNDING_BY_PERIOD_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
BUDGET_PERIOD_ID AWARD_ID BUDGET_PERIOD START_DATE END_DATE LC_DIRECT_FUNDING_AMOUNT LC_INDIRECT_FUNDING_AMOUNT DIRECT_FUNDING_AMOUNT INDIRECT_FUNDING_AMOUNT FUNDING_ID

Query

SQL_Statement

SELECT A.ID AS BUDGET_PERIOD_ID, A.AWARD_ID, A.BUDGET_PERIOD, A.START_DATE, A.END_DATE, NVL(B.LC_DIRECT_FUNDING_AMOUNT, 0) AS LC_DIRECT_FUNDING_AMOUNT, NVL(B.LC_INDIRECT_FUNDING_AMOUNT, 0) AS LC_INDIRECT_FUNDING_AMOUNT, NVL(B.DIRECT_FUNDING_AMOUNT, 0) AS DIRECT_FUNDING_AMOUNT, NVL(B.INDIRECT_FUNDING_AMOUNT, 0) AS INDIRECT_FUNDING_AMOUNT, NVL(B.ID, 0) AS FUNDING_ID FROM GMS_AWARD_BUDGET_PERIODS A, GMS_AWARD_FUNDINGS_VL B WHERE A.AWARD_ID = B.AWARD_ID(+) AND A.ID = B.BUDGET_PERIOD_ID(+)