DBA Data[Home] [Help]

VIEW: GMS.GMS_SUMMARY_PROJECT_FUNDINGS#

Source

View Text - Preformatted

select INSTALLMENT_ID INSTALLMENT_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, TOTAL_FUNDING_AMOUNT TOTAL_FUNDING_AMOUNT, TOTAL_BILLED_AMOUNT TOTAL_BILLED_AMOUNT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, TOTAL_REVENUE_AMOUNT TOTAL_REVENUE_AMOUNT from "GMS"."GMS_SUMMARY_PROJECT_FUNDINGS"
View Text - HTML Formatted

SELECT INSTALLMENT_ID INSTALLMENT_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, TOTAL_FUNDING_AMOUNT TOTAL_FUNDING_AMOUNT
, TOTAL_BILLED_AMOUNT TOTAL_BILLED_AMOUNT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, TOTAL_REVENUE_AMOUNT TOTAL_REVENUE_AMOUNT
FROM "GMS"."GMS_SUMMARY_PROJECT_FUNDINGS"