[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_SUM_PROJECT_FUNDINGS2_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_SUM_PROJECT_FUNDINGS2_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 | (30) | - Project functional currency code | |
| PROJFUNC_UNBASELINED_AMOUNT | NUMBER | Yes | - Total unbaselined amount allocated from the agreement to the project or task in project functional currency | |
| PROJFUNC_BASELINED_AMOUNT | NUMBER | - 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 | - Total amount accrued against the baselined funding in project functional currency | ||
| PROJFUNC_REVENUE | NUMBER | - Total revenue in project functional currency | ||
| PROJFUNC_BILLED_AMOUNT | NUMBER | - 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. |
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
FROM APPS.PA_SUM_PROJECT_FUNDINGS2_V;
APPS
HZ_CUST_ACCOUNTS
HZ_PARTIES
PA_AGREEMENTS_ALL
PA_LOOKUPS
PA_MC_SUM_PROJ_FUNDINGS
PA_PROJECTS_ALL
PA_SECURITY
- show dependent code
PA_SUMMARY_PROJECT_FUNDINGS
PA_TASKS
APPS.PA_SUM_PROJECT_FUNDINGS2_V is not referenced by any database object
|
|
|
|