APPS.PA_PROJECT_FUNDINGS_AMG_V
[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | This view based on pa_project_fundings table, stores incremental allocations of agreement funds to projects or top tasks. Funding is required for a contract project before that project can accrue revenue and generate invoices. Indirect or |
| Implementation/DBA Data: |
APPS.PA_PROJECT_FUNDINGS_AMG_V
|
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