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_PROJECT_FUNDINGS

Object Details

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

The PA_MC_PROJECT_FUNDINGS table stores project funding lines for all the reporting set of books associated with functional set of books. The funding amounts are converted to the respective reporting currencies.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_PROJECT_FUNDINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID PROJECT_FUNDING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The reporting set of books unique identifier
PROJECT_FUNDING_ID	NUMBER	(15)	Yes	The identifier of the funding lines.
ALLOCATED_AMOUNT	NUMBER		Yes	The amount of funding allocated to the project or the top task in reporting currency.
CURRENCY_CODE	VARCHAR2	(30)		The currency code associated to the reporting set of books.
RATE_TYPE	VARCHAR2	(30)		Rate used to covert the allocated amount to the reporting set of books currency.
CONVERSION_DATE	DATE			The conversion date used to convert to the reporting set of books currency.
EXCHANGE_RATE	NUMBER			The exchange rate used to covert to the reporting set of books currency on the conversion.
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. This column will be populated by funding revaluation process
REALIZED_LOSSES_AMT	NUMBER			Realized losses amount in reporting currency. This column will be populated by funding revaluation process
INV_APPLIED_AMOUNT	NUMBER			Invoice applied amount in reporting currency. This column will be populated by funding revaluation process
INV_DUE_AMOUNT	NUMBER			Invoice due amount in reporting currency. This column will be populated by funding revaluation process
BACKLOG_AMOUNT	NUMBER			Backlog amount in reporting currency . This column will be populated by funding revaluation process
REVAL_AMOUNT	NUMBER			Total baselined funding amount in reporting currency. This column will be populated by funding revaluation process.
REVALUED_AMOUNT	NUMBER			Revalued amount in reporting currency. This column will be populated by funding revaluation process

Query Text

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


SELECT SET_OF_BOOKS_ID
,      PROJECT_FUNDING_ID
,      ALLOCATED_AMOUNT
,      CURRENCY_CODE
,      RATE_TYPE
,      CONVERSION_DATE
,      EXCHANGE_RATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REALIZED_GAINS_AMT
,      REALIZED_LOSSES_AMT
,      INV_APPLIED_AMOUNT
,      INV_DUE_AMOUNT
,      BACKLOG_AMOUNT
,      REVAL_AMOUNT
,      REVALUED_AMOUNT
FROM PA.PA_MC_PROJECT_FUNDINGS;

Dependencies

[top of page]

PA.PA_MC_PROJECT_FUNDINGS does not reference any database object

PA.PA_MC_PROJECT_FUNDINGS is referenced by following:

APPS: PA_MC_PROJECT_FUNDINGS