[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_SUMMARY_PROJECT_FUNDINGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_SUMMARY_PROJECT_FUNDINGS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| PROJECT_ID | NUMBER | (15) | Yes | |
| PROJECT_NUMBER | VARCHAR2 | (25) | ||
| PROJECT_NAME | VARCHAR2 | (30) | ||
| TASK_ID | NUMBER | (15) | ||
| TASK_NUMBER | VARCHAR2 | (25) | ||
| TASK_NAME | VARCHAR2 | (20) | ||
| AGREEMENT_ID | NUMBER | (15) | Yes | |
| AGREEMENT_NUM | VARCHAR2 | (50) | Yes | |
| CUSTOMER_ID | NUMBER | (15) | Yes | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | |
| CUSTOMER_NAME | VARCHAR2 | (360) | Yes | |
| TOTAL_UNBASELINED_AMOUNT | NUMBER | (22) | Yes | - Total unbaselined amount allocated from the agreement to the project or task in funding currency. This amount should always equal the sum of the unbaselined detailed project funding amounts for the agreement, project, and task |
| TOTAL_BASELINED_AMOUNT | NUMBER | (22) | - Total baselined amount allocated from the agreement to the project or task in funding currency. This amount is maintained after the project is baselined and should always equal the sum of the baselined detailed project funding amounts | |
| TOTAL_ALLOCATED | NUMBER | - Amount of funding allocated to the project or top task in funding currency | ||
| TOTAL_ACCRUED_AMOUNT | NUMBER | (22) | - Total amount accrued against the baselined funding in funding currency | |
| REVENUE_WRITEOFF | NUMBER | |||
| TOTAL_REVENUE | NUMBER | (22) | - Total revenue in funding currency | |
| TOTAL_BILLED_AMOUNT | NUMBER | (22) | - Total amount billed against the baselined funding in funding currency | |
| 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_ALLOCATED | NUMBER | - Amount of funding allocated to the project or top task in the project currency | ||
| PROJECT_ACCRUED_AMOUNT | NUMBER | (22) | - Total amount accrued against the baselined funding in project currency | |
| PROJECT_REVENUE | NUMBER | (22) | - Total revenue 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_ALLOCATED | NUMBER | - Amount of funding allocated to the project or top task in the project functional currency | ||
| PROJFUNC_ACCRUED_AMOUNT | NUMBER | (22) | - Total amount accrued against the baselined funding in project functional currency | |
| PROJFUNC_REVENUE | NUMBER | (22) | - Total revenue 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_ALLOCATED | NUMBER | - Amount of funding allocated to the project or top task in the 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_ALLOCATED | NUMBER | - Amount of funding allocated to the project or top task in the revenue processing currency | ||
| REVPROC_ACCRUED_AMOUNT | NUMBER | (22) | - Total amount accrued against the baselined funding in revenue processing currency | |
| REVPROC_REVENUE | NUMBER | (22) | - Total revenue in revenue processing currency | |
| OWNING_ORGANIZATION_NAME | VARCHAR2 | (0) | - Agreement owning operating unit name | |
| OWNING_ORGANIZATION_ID | NUMBER | (15) | - Identifier for Agreement owning operating unit. | |
| BILLING_SEQUENCE | NUMBER | (2) | - Agreement Billing sequence. | |
| EXPIRATION_DATE | DATE | - Agreement End Date. | ||
| START_DATE | DATE | - Agreement Start Date. | ||
| 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 ROW_ID
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, AGREEMENT_ID
, AGREEMENT_NUM
, CUSTOMER_ID
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, TOTAL_UNBASELINED_AMOUNT
, TOTAL_BASELINED_AMOUNT
, TOTAL_ALLOCATED
, TOTAL_ACCRUED_AMOUNT
, REVENUE_WRITEOFF
, TOTAL_REVENUE
, TOTAL_BILLED_AMOUNT
, FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJECT_UNBASELINED_AMOUNT
, PROJECT_BASELINED_AMOUNT
, PROJECT_ALLOCATED
, PROJECT_ACCRUED_AMOUNT
, PROJECT_REVENUE
, PROJECT_BILLED_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_UNBASELINED_AMOUNT
, PROJFUNC_BASELINED_AMOUNT
, PROJFUNC_ALLOCATED
, PROJFUNC_ACCRUED_AMOUNT
, PROJFUNC_REVENUE
, PROJFUNC_BILLED_AMOUNT
, INVPROC_CURRENCY_CODE
, INVPROC_UNBASELINED_AMOUNT
, INVPROC_BASELINED_AMOUNT
, INVPROC_ALLOCATED
, INVPROC_BILLED_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_UNBASELINED_AMOUNT
, REVPROC_BASELINED_AMOUNT
, REVPROC_ALLOCATED
, REVPROC_ACCRUED_AMOUNT
, REVPROC_REVENUE
, OWNING_ORGANIZATION_NAME
, OWNING_ORGANIZATION_ID
, BILLING_SEQUENCE
, EXPIRATION_DATE
, START_DATE
, 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 APPS.PA_SUMMARY_PROJECT_FUNDINGS_V;
APPS
HZ_CUST_ACCOUNTS
HZ_PARTIES
PA_AGREEMENTS_ALL
PA_LOOKUPS
PA_PROJECTS_ALL
PA_SECURITY
- show dependent code
PA_SUMMARY_PROJECT_FUNDINGS
PA_TASKS
APPS.PA_SUMMARY_PROJECT_FUNDINGS_V is not referenced by any database object
|
|
|
|