VIEW: APPS.PA_PROJECT_FUNDINGS_AMG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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