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_TXN_INTERFACE_ALL

Object Details

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

PA_MC_TXN_INTERFACE_ALL is an MRC sub table of
PA_TRANSACTION_INTERFACE_ALL. It stores currency related information
about transaction interface for each reporting set of books associated
with the parent record on PA_TRANSACTION_INTERFACE_ALL. The primary
key on this table is: SET_OF_BOOKS_ID, TXN_INTERFACE_ID.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_TXN_INTERFACE_ALL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	SET_OF_BOOKS_ID TXN_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The reporting set of books unique identifier
TXN_INTERFACE_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the imported transaction
RAW_COST	NUMBER			The total raw cost of the imported transaction in reporting currency
RAW_COST_RATE	NUMBER			The raw cost rate of the imported transaction in reporting currency
BURDENED_COST	NUMBER			The burdened cost of the imported transaction in reporting currency
BURDENED_COST_RATE	NUMBER			The burdened cost rate of the imported transaction in reporting currency
CURRENCY_CODE	VARCHAR2	(30)		The currency code associated to the reporting set of books
EXCHANGE_RATE	NUMBER			The exchange rate used to convert to the currency of the reporting set of books
CONVERSION_DATE	DATE			The date used to convert to the currency of the reporting set of books
RATE_TYPE	VARCHAR2	(30)		The rate type used to convert to the currency of the reporting set of books

Query Text

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


SELECT SET_OF_BOOKS_ID
,      TXN_INTERFACE_ID
,      RAW_COST
,      RAW_COST_RATE
,      BURDENED_COST
,      BURDENED_COST_RATE
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      CONVERSION_DATE
,      RATE_TYPE
FROM PA.PA_MC_TXN_INTERFACE_ALL;

Dependencies

[top of page]

PA.PA_MC_TXN_INTERFACE_ALL does not reference any database object

PA.PA_MC_TXN_INTERFACE_ALL is referenced by following:

PA: PA_MC_TXN_INTERFACE_ALL#