eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PA_SUM_PROJECT_FUNDINGS2_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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.
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.

Query Text

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
,      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_SUM_PROJECT_FUNDINGS2_V;

Dependencies

[top of page]

APPS.PA_SUM_PROJECT_FUNDINGS2_V references the following:

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