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: AP.AP_MC_INVOICES

Object Details

Object Name:	AP_MC_INVOICES
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_MC_INVOICES
Subobject Name:
Status:	VALID

AP_MC_INVOICES is a Multiple Reporting Currencies table that stores
reporting currency information for each invoice in Oracle Payables.
There is an optional one to many relationship between AP_INVOICES_ALL
and this table. For each invoice in the AP_INVOICES_ALL table, there
can be several invoices in the AP_MC_INVOICES table with the same
INVOICE_ID value, but different values for SET_OF_BOOKS_ID. The
number of invoices stored in the AP_MC_INVOICES table having the same
INVOICE_ID will correspond with the number of Reporting Sets of Books
that have been defined.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_MC_INVOICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
BASE_AMOUNT	NUMBER			Invoice amount in functional currency, only used for foreign currency invoices
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type to convert transaction currency amounts into reporting currency amounts
EXCHANGE_DATE	DATE			Date which determines currency conversion rate to convert transaction currency amounts into reporting currency amounts

Query Text

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


SELECT INVOICE_ID
,      SET_OF_BOOKS_ID
,      BASE_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
FROM AP.AP_MC_INVOICES;

Dependencies

[top of page]

AP.AP_MC_INVOICES does not reference any database object

AP.AP_MC_INVOICES is referenced by following:

APPS: AP_MC_INVOICES