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_BUDGET_VERSIONS_OLAP_TMP2

Object Details

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

This temporary table stores budget versions and all the currency codes the project uses

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BUDGET_VER_OLAP_TMP2_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
PA_BUDGET_VER_OLAP_TMP2_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID

Columns

Name	Datatype	Length	Comments
CURR_TYPE	VARCHAR2	(4)	Stores ALL if project currency and project functional currencies are the same. Stores PC for project currency record. Stores PFC for project functional currency record
PROJECT_ID	NUMBER
BUDGET_VERSION_ID	NUMBER		Identifier of the Budget Version
CURRENCY_CODE	VARCHAR2	(15)	Currency Code

Query Text

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


SELECT CURR_TYPE
,      PROJECT_ID
,      BUDGET_VERSION_ID
,      CURRENCY_CODE
FROM PA.PA_BUDGET_VERSIONS_OLAP_TMP2;

Dependencies

[top of page]

PA.PA_BUDGET_VERSIONS_OLAP_TMP2 does not reference any database object

PA.PA_BUDGET_VERSIONS_OLAP_TMP2 is referenced by following:

PA: PA_BUDGET_VERSIONS_OLAP_TMP2#