eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_PROJECT_FUNDINGS#

Source

View Text - Preformatted


select PA_PROJECT_FUNDINGS_PROJECT_ID PA_PROJECT_FUNDINGS_PROJECT_ID, PROJECT_FUNDING_ID PROJECT_FUNDING_ID, 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, AGREEMENT_ID AGREEMENT_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, BUDGET_TYPE_CODE BUDGET_TYPE_CODE, ALLOCATED_AMOUNT ALLOCATED_AMOUNT, DATE_ALLOCATED DATE_ALLOCATED, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, PM_FUNDING_REFERENCE PM_FUNDING_REFERENCE, PM_PRODUCT_CODE PM_PRODUCT_CODE, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, PROJECT_ALLOCATED_AMOUNT PROJECT_ALLOCATED_AMOUNT, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE, PROJFUNC_ALLOCATED_AMOUNT PROJFUNC_ALLOCATED_AMOUNT, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, INVPROC_RATE_TYPE INVPROC_RATE_TYPE, INVPROC_RATE_DATE INVPROC_RATE_DATE, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE, INVPROC_ALLOCATED_AMOUNT INVPROC_ALLOCATED_AMOUNT, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, REVPROC_RATE_TYPE REVPROC_RATE_TYPE, REVPROC_RATE_DATE REVPROC_RATE_DATE, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE, REVPROC_ALLOCATED_AMOUNT REVPROC_ALLOCATED_AMOUNT, FUNDING_CATEGORY FUNDING_CATEGORY, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, REVALUATION_THROUGH_DATE REVALUATION_THROUGH_DATE, REVALUATION_RATE_DATE REVALUATION_RATE_DATE, REVALUATION_PROJFUNC_RATE_TYPE REVALUATION_PROJFUNC_RATE_TYPE, REVALUATION_PROJFUNC_RATE REVALUATION_PROJFUNC_RATE, REVALUATION_INVPROC_RATE_TYPE REVALUATION_INVPROC_RATE_TYPE, REVALUATION_INVPROC_RATE REVALUATION_INVPROC_RATE, FUNDING_INV_APPLIED_AMOUNT FUNDING_INV_APPLIED_AMOUNT, FUNDING_INV_DUE_AMOUNT FUNDING_INV_DUE_AMOUNT, FUNDING_BACKLOG_AMOUNT FUNDING_BACKLOG_AMOUNT, PROJFUNC_REALIZED_GAINS_AMT PROJFUNC_REALIZED_GAINS_AMT, PROJFUNC_REALIZED_LOSSES_AMT PROJFUNC_REALIZED_LOSSES_AMT, PROJFUNC_INV_APPLIED_AMOUNT PROJFUNC_INV_APPLIED_AMOUNT, PROJFUNC_INV_DUE_AMOUNT PROJFUNC_INV_DUE_AMOUNT, PROJFUNC_BACKLOG_AMOUNT PROJFUNC_BACKLOG_AMOUNT, NON_UPDATEABLE_FLAG NON_UPDATEABLE_FLAG, INVPROC_BACKLOG_AMOUNT INVPROC_BACKLOG_AMOUNT, FUNDING_REVAL_AMOUNT FUNDING_REVAL_AMOUNT, PROJFUNC_REVAL_AMOUNT PROJFUNC_REVAL_AMOUNT, PROJFUNC_REVALUED_AMOUNT PROJFUNC_REVALUED_AMOUNT, INVPROC_REVAL_AMOUNT INVPROC_REVAL_AMOUNT, INVPROC_REVALUED_AMOUNT INVPROC_REVALUED_AMOUNT, FUNDING_REVALUATION_FACTOR FUNDING_REVALUATION_FACTOR, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CI_ID CI_ID, SUBMIT_BASELINE_FLAG SUBMIT_BASELINE_FLAG from "PA"."PA_PROJECT_FUNDINGS"

View Text - HTML Formatted

SELECT PA_PROJECT_FUNDINGS_PROJECT_ID PA_PROJECT_FUNDINGS_PROJECT_ID
, PROJECT_FUNDING_ID PROJECT_FUNDING_ID
, 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
, AGREEMENT_ID AGREEMENT_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, BUDGET_TYPE_CODE BUDGET_TYPE_CODE
, ALLOCATED_AMOUNT ALLOCATED_AMOUNT
, DATE_ALLOCATED DATE_ALLOCATED
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, PM_FUNDING_REFERENCE PM_FUNDING_REFERENCE
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, PROJECT_ALLOCATED_AMOUNT PROJECT_ALLOCATED_AMOUNT
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE PROJFUNC_EXCHANGE_RATE
, PROJFUNC_ALLOCATED_AMOUNT PROJFUNC_ALLOCATED_AMOUNT
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE INVPROC_RATE_TYPE
, INVPROC_RATE_DATE INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE
, INVPROC_ALLOCATED_AMOUNT INVPROC_ALLOCATED_AMOUNT
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE REVPROC_RATE_TYPE
, REVPROC_RATE_DATE REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE
, REVPROC_ALLOCATED_AMOUNT REVPROC_ALLOCATED_AMOUNT
, FUNDING_CATEGORY FUNDING_CATEGORY
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, REVALUATION_THROUGH_DATE REVALUATION_THROUGH_DATE
, REVALUATION_RATE_DATE REVALUATION_RATE_DATE
, REVALUATION_PROJFUNC_RATE_TYPE REVALUATION_PROJFUNC_RATE_TYPE
, REVALUATION_PROJFUNC_RATE REVALUATION_PROJFUNC_RATE
, REVALUATION_INVPROC_RATE_TYPE REVALUATION_INVPROC_RATE_TYPE
, REVALUATION_INVPROC_RATE REVALUATION_INVPROC_RATE
, FUNDING_INV_APPLIED_AMOUNT FUNDING_INV_APPLIED_AMOUNT
, FUNDING_INV_DUE_AMOUNT FUNDING_INV_DUE_AMOUNT
, FUNDING_BACKLOG_AMOUNT FUNDING_BACKLOG_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT PROJFUNC_REALIZED_LOSSES_AMT
, PROJFUNC_INV_APPLIED_AMOUNT PROJFUNC_INV_APPLIED_AMOUNT
, PROJFUNC_INV_DUE_AMOUNT PROJFUNC_INV_DUE_AMOUNT
, PROJFUNC_BACKLOG_AMOUNT PROJFUNC_BACKLOG_AMOUNT
, NON_UPDATEABLE_FLAG NON_UPDATEABLE_FLAG
, INVPROC_BACKLOG_AMOUNT INVPROC_BACKLOG_AMOUNT
, FUNDING_REVAL_AMOUNT FUNDING_REVAL_AMOUNT
, PROJFUNC_REVAL_AMOUNT PROJFUNC_REVAL_AMOUNT
, PROJFUNC_REVALUED_AMOUNT PROJFUNC_REVALUED_AMOUNT
, INVPROC_REVAL_AMOUNT INVPROC_REVAL_AMOUNT
, INVPROC_REVALUED_AMOUNT INVPROC_REVALUED_AMOUNT
, FUNDING_REVALUATION_FACTOR FUNDING_REVALUATION_FACTOR
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CI_ID CI_ID
, SUBMIT_BASELINE_FLAG SUBMIT_BASELINE_FLAG
FROM "PA"."PA_PROJECT_FUNDINGS"