VIEW: PA.PA_SUMMARY_PROJECT_FUNDINGS#

Source

View Text - Preformatted

select AGREEMENT_ID AGREEMENT_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TOTAL_UNBASELINED_AMOUNT TOTAL_UNBASELINED_AMOUNT, TOTAL_BASELINED_AMOUNT TOTAL_BASELINED_AMOUNT, TOTAL_ACCRUED_AMOUNT TOTAL_ACCRUED_AMOUNT, TOTAL_BILLED_AMOUNT TOTAL_BILLED_AMOUNT, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_UNBASELINED_AMOUNT PROJECT_UNBASELINED_AMOUNT, PROJECT_BASELINED_AMOUNT PROJECT_BASELINED_AMOUNT, PROJECT_ACCRUED_AMOUNT PROJECT_ACCRUED_AMOUNT, PROJECT_BILLED_AMOUNT PROJECT_BILLED_AMOUNT, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_UNBASELINED_AMOUNT PROJFUNC_UNBASELINED_AMOUNT, PROJFUNC_BASELINED_AMOUNT PROJFUNC_BASELINED_AMOUNT, PROJFUNC_ACCRUED_AMOUNT PROJFUNC_ACCRUED_AMOUNT, PROJFUNC_BILLED_AMOUNT PROJFUNC_BILLED_AMOUNT, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, INVPROC_UNBASELINED_AMOUNT INVPROC_UNBASELINED_AMOUNT, INVPROC_BASELINED_AMOUNT INVPROC_BASELINED_AMOUNT, INVPROC_BILLED_AMOUNT INVPROC_BILLED_AMOUNT, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, REVPROC_UNBASELINED_AMOUNT REVPROC_UNBASELINED_AMOUNT, REVPROC_BASELINED_AMOUNT REVPROC_BASELINED_AMOUNT, REVPROC_ACCRUED_AMOUNT REVPROC_ACCRUED_AMOUNT, PROJFUNC_REALIZED_GAINS_AMT PROJFUNC_REALIZED_GAINS_AMT, PROJFUNC_REALIZED_LOSSES_AMT PROJFUNC_REALIZED_LOSSES_AMT, REVAL_REJECTION_CODE REVAL_REJECTION_CODE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30 from "PA"."PA_SUMMARY_PROJECT_FUNDINGS"

View Text - HTML Formatted

SELECT AGREEMENT_ID AGREEMENT_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TOTAL_UNBASELINED_AMOUNT TOTAL_UNBASELINED_AMOUNT
, TOTAL_BASELINED_AMOUNT TOTAL_BASELINED_AMOUNT
, TOTAL_ACCRUED_AMOUNT TOTAL_ACCRUED_AMOUNT
, TOTAL_BILLED_AMOUNT TOTAL_BILLED_AMOUNT
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_UNBASELINED_AMOUNT PROJECT_UNBASELINED_AMOUNT
, PROJECT_BASELINED_AMOUNT PROJECT_BASELINED_AMOUNT
, PROJECT_ACCRUED_AMOUNT PROJECT_ACCRUED_AMOUNT
, PROJECT_BILLED_AMOUNT PROJECT_BILLED_AMOUNT
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_UNBASELINED_AMOUNT PROJFUNC_UNBASELINED_AMOUNT
, PROJFUNC_BASELINED_AMOUNT PROJFUNC_BASELINED_AMOUNT
, PROJFUNC_ACCRUED_AMOUNT PROJFUNC_ACCRUED_AMOUNT
, PROJFUNC_BILLED_AMOUNT PROJFUNC_BILLED_AMOUNT
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, INVPROC_UNBASELINED_AMOUNT INVPROC_UNBASELINED_AMOUNT
, INVPROC_BASELINED_AMOUNT INVPROC_BASELINED_AMOUNT
, INVPROC_BILLED_AMOUNT INVPROC_BILLED_AMOUNT
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, REVPROC_UNBASELINED_AMOUNT REVPROC_UNBASELINED_AMOUNT
, REVPROC_BASELINED_AMOUNT REVPROC_BASELINED_AMOUNT
, REVPROC_ACCRUED_AMOUNT REVPROC_ACCRUED_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT PROJFUNC_REALIZED_LOSSES_AMT
, REVAL_REJECTION_CODE REVAL_REJECTION_CODE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30
FROM "PA"."PA_SUMMARY_PROJECT_FUNDINGS"