[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_SUMMARY_PROJECT_FUNDINGS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_SUMMARY_PROJECT_FUNDINGS
|
| Subobject Name: | |
| Status: | VALID |
PA_SUMMARY_PROJECT_FUNDINGS stores summary funding
amounts allocated from agreements to projects and
tasks. These amounts are the summary amounts of the
detailed project funding records entered by users.
These amounts are maintained upon entry and baseline
of the funding. The revenue and invoice activity
using the funding is recorded by the Generate Draft
Revenue and Generate Draft Invoice processes.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_SUMMARY_PROJECT_FUNDINGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PROJECT_ID
AGREEMENT_ID
TASK_ID
REVPROC_BASELINED_AMOUNT
|
| PA_SUMMARY_PROJECT_FUNDINGS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AGREEMENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AGREEMENT_ID | NUMBER | (15) | Yes | The identifier of the agreement that is allocated funds to the project or task |
| PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project to which funds are allocated |
| TASK_ID | NUMBER | (15) | The identifier of the task to which funds are allocated | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who Column | |
| TOTAL_UNBASELINED_AMOUNT | NUMBER | (22) | Yes | Total unbaselined amount allocated from the agreement to the project or task. This amount should always equal the sum of the unbaselined detailed project fundings amounts for the agreement, project, and task |
| TOTAL_BASELINED_AMOUNT | NUMBER | (22) | Total baselined amount allocated from the agreement to the project or task. This amount is maintained upon baseline of the project and should always equal the sum of the baselined detailed project funding amounts | |
| TOTAL_ACCRUED_AMOUNT | NUMBER | (22) | Total amount accrued against the baselined funding | |
| TOTAL_BILLED_AMOUNT | NUMBER | (22) | Total amount billed against the baselined funding | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
| REQUEST_ID | NUMBER | (15) | Standard Who Column | |
| FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | Funding currency code | |
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
| PROJECT_UNBASELINED_AMOUNT | NUMBER | (22) | Total unbaselined amount allocated from the agreement to the project or task in project currency | |
| PROJECT_BASELINED_AMOUNT | NUMBER | (22) | Total baselined amount allocated from the agreement to the project or task in project currency | |
| PROJECT_ACCRUED_AMOUNT | NUMBER | (22) | Total amount accrued against the baselined funding in project currency | |
| PROJECT_BILLED_AMOUNT | NUMBER | (22) | Total amount billed against the baselined funding in project currency | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code | |
| PROJFUNC_UNBASELINED_AMOUNT | NUMBER | (22) | Total unbaselined amount allocated from the agreement to the project or task in project functional currency | |
| PROJFUNC_BASELINED_AMOUNT | NUMBER | (22) | Total baselined amount allocated from the agreement to the project or task in project functional currency | |
| PROJFUNC_ACCRUED_AMOUNT | NUMBER | (22) | Total amount accrued against the baselined funding in project functional currency | |
| PROJFUNC_BILLED_AMOUNT | NUMBER | (22) | Total amount billed against the baselined funding in project functional currency | |
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Invoice processing currency code | |
| INVPROC_UNBASELINED_AMOUNT | NUMBER | (22) | Total unbaselined amount allocated from the agreement to the project or task in invoice processing currency | |
| INVPROC_BASELINED_AMOUNT | NUMBER | (22) | Total baselined amount allocated from the agreement to the project or task in invoice processing currency | |
| INVPROC_BILLED_AMOUNT | NUMBER | (22) | Total amount billed against the baselined funding in invoice processing currency | |
| REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Revenue processing currency code | |
| REVPROC_UNBASELINED_AMOUNT | NUMBER | (22) | Total unbaselined amount allocated from the agreement to the project or task in revenue processing currency | |
| REVPROC_BASELINED_AMOUNT | NUMBER | (22) | Total baselined amount allocated from the agreement to the project or task in revenue processing currency | |
| REVPROC_ACCRUED_AMOUNT | NUMBER | (22) | Total amount accrued against the baselined funding in revenue processing currency | |
| PROJFUNC_REALIZED_GAINS_AMT | NUMBER | Realized gains amount in project functional currency. | ||
| PROJFUNC_REALIZED_LOSSES_AMT | NUMBER | Realized losses amount in project functional currency. | ||
| REVAL_REJECTION_CODE | VARCHAR2 | (30) | Revaluation process rejection reason | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. | |
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | (240) | Global Descriptive Flexfield for storing Federal Financial codes. |
Cut, paste (and edit) the following text to query this object:
SELECT AGREEMENT_ID
, PROJECT_ID
, TASK_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TOTAL_UNBASELINED_AMOUNT
, TOTAL_BASELINED_AMOUNT
, TOTAL_ACCRUED_AMOUNT
, TOTAL_BILLED_AMOUNT
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJECT_UNBASELINED_AMOUNT
, PROJECT_BASELINED_AMOUNT
, PROJECT_ACCRUED_AMOUNT
, PROJECT_BILLED_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_UNBASELINED_AMOUNT
, PROJFUNC_BASELINED_AMOUNT
, PROJFUNC_ACCRUED_AMOUNT
, PROJFUNC_BILLED_AMOUNT
, INVPROC_CURRENCY_CODE
, INVPROC_UNBASELINED_AMOUNT
, INVPROC_BASELINED_AMOUNT
, INVPROC_BILLED_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_UNBASELINED_AMOUNT
, REVPROC_BASELINED_AMOUNT
, REVPROC_ACCRUED_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT
, REVAL_REJECTION_CODE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30
FROM PA.PA_SUMMARY_PROJECT_FUNDINGS;
PA.PA_SUMMARY_PROJECT_FUNDINGS does not reference any database object
PA.PA_SUMMARY_PROJECT_FUNDINGS is referenced by following:
PA
PA_SUMMARY_PROJECT_FUNDINGS#
|
|
|
|