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]

TABLE: PA.PA_MC_SUM_PROJ_FUNDINGS

Object Details

Object Name:	PA_MC_SUM_PROJ_FUNDINGS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_MC_SUM_PROJ_FUNDINGS
Subobject Name:
Status:	VALID

The PA_MC_SUM_PROJ_FUNDINGS table maintains the total baselined, total unbaselined, total accrued and total billed amount for each agreement and project or top-level task depending on the funding level for all the reporting set of books associated with functional set of books.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_SUM_PROJ_FUNDINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID PROJECT_ID AGREEMENT_ID TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The reporting set of books unique identifier
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.
TOTAL_UNBASELINED_AMOUNT	NUMBER		Yes	Total unbaselined amount allocated from agreement to the project or task in reporting currency. This amount should always equal the sum of the unbaselined detailed project fundings amount for the agreement, project, and task in reporting currency.
TOTAL_BASELINED_AMOUNT	NUMBER			Total baselined amount allocated from agreement to the project or task n reporting currency. This amount is maintained upon baseline of the project and should always equal the sum of the baselined detailed project fundings amounts in reporting currency.
TOTAL_ACCRUED_AMOUNT	NUMBER			Total amount accrued against the baselined funding in reporting currency.
TOTAL_BILLED_AMOUNT	NUMBER			Total amount billed against the baselined funding in reporting currency.
CURRENCY_CODE	VARCHAR2	(30)		The currency code associated to the reporting set of books.
REQUEST_ID	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REALIZED_GAINS_AMT	NUMBER			Realized gains amount in reporting currency.
REALIZED_LOSSES_AMT	NUMBER			Realized losses amount in reporting currency.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      AGREEMENT_ID
,      PROJECT_ID
,      TASK_ID
,      TOTAL_UNBASELINED_AMOUNT
,      TOTAL_BASELINED_AMOUNT
,      TOTAL_ACCRUED_AMOUNT
,      TOTAL_BILLED_AMOUNT
,      CURRENCY_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REALIZED_GAINS_AMT
,      REALIZED_LOSSES_AMT
FROM PA.PA_MC_SUM_PROJ_FUNDINGS;

Dependencies

[top of page]

PA.PA_MC_SUM_PROJ_FUNDINGS does not reference any database object

PA.PA_MC_SUM_PROJ_FUNDINGS is referenced by following:

PA: PA_MC_SUM_PROJ_FUNDINGS#