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_FP_TXN_CURRENCIES

Object Details

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

This table stores the plannable transaction currencies for a project. The plannable currencies defined at a project level default to every plan type added to the project. The plannable currencies defined for a plan type on a project default to every plan version created with that plan type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FP_TXN_CURRENCIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FP_TXN_CURRENCY_ID
PA_FP_TXN_CURRENCIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJ_FP_OPTIONS_ID TXN_CURRENCY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
FP_TXN_CURRENCY_ID	NUMBER	(15)	Yes	System generated unique identifier that identifies the transaction currency.
PROJ_FP_OPTIONS_ID	NUMBER	(15)	Yes	The identifier of the planning option to which the currency belongs to.
PROJECT_ID	NUMBER	(15)	Yes	Unique identifier of the project
FIN_PLAN_TYPE_ID	NUMBER	(15)		Unique identifier of the plan type
FIN_PLAN_VERSION_ID	NUMBER	(15)		Unique identifier of the plan version
TXN_CURRENCY_CODE	VARCHAR2	(15)	Yes	Unique identifier of the currency
DEFAULT_REV_CURR_FLAG	VARCHAR2	(1)		Indicates whether this currency should be used as the default currency when entering revenue amounts in a financial plan.
DEFAULT_COST_CURR_FLAG	VARCHAR2	(1)		Indicates whether this currency should be used as the default currency when entering cost amounts in a financial plan.
DEFAULT_ALL_CURR_FLAG	VARCHAR2	(1)		Indicates whether this currency should be used as the default currency when entering amounts in a financial plan. Applicable only if cost and revenue amounts are entered in the same financial plan version.
PROJECT_CURRENCY_FLAG	VARCHAR2	(1)		Indicates if the currency is project currency.
PROJFUNC_CURRENCY_FLAG	VARCHAR2	(1)		Indicates if the currency is project functional currency
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
PROJECT_COST_EXCHANGE_RATE	NUMBER			The cost exchange rate for project currency.
PROJECT_REV_EXCHANGE_RATE	NUMBER			The revenue exchange rate for project currency.
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			The cost exchange rate for project functional currency
PROJFUNC_REV_EXCHANGE_RATE	NUMBER			The revenue exchange rate for project functional currency.

Query Text

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


SELECT FP_TXN_CURRENCY_ID
,      PROJ_FP_OPTIONS_ID
,      PROJECT_ID
,      FIN_PLAN_TYPE_ID
,      FIN_PLAN_VERSION_ID
,      TXN_CURRENCY_CODE
,      DEFAULT_REV_CURR_FLAG
,      DEFAULT_COST_CURR_FLAG
,      DEFAULT_ALL_CURR_FLAG
,      PROJECT_CURRENCY_FLAG
,      PROJFUNC_CURRENCY_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_REV_EXCHANGE_RATE
FROM PA.PA_FP_TXN_CURRENCIES;

Dependencies

[top of page]

PA.PA_FP_TXN_CURRENCIES does not reference any database object

PA.PA_FP_TXN_CURRENCIES is referenced by following:

APPS: PA_FP_TXN_CURRENCIES