[Home] [Help] [Dependency Information]
Object Name: | CST_RCV_ACQ_COSTS_EFC |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_RCV_ACQ_COSTS_EFC |
Subobject Name: | |
Status: | VALID |
CST_RCV_ACQ_COSTS_EFC is used exclusively as an archive table
for the "Euro as a functional currency" project. It mirrors the table
CST_RCV_ACQ_COSTS prior to conversion to the euro currency.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_AT_PO_PRICE | NUMBER | Amount At PO Price | ||
PO_UNIT_PRICE | NUMBER | PO Unit Price | ||
ACQUISITION_COST | NUMBER | Acquisition Cost | ||
REC_EXCHG_RATE | NUMBER | Currency Conversion rate. | ||
TOTAL_INVOICE_AMOUNT | NUMBER | Total Invoice Amount | ||
HEADER_ID | NUMBER | Yes | Header Identifier | |
TOTAL_AMOUNT | NUMBER | Total Amount | ||
SET_OF_BOOKS_ID | NUMBER | Set Of Books Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_AT_PO_PRICE
, PO_UNIT_PRICE
, ACQUISITION_COST
, REC_EXCHG_RATE
, TOTAL_INVOICE_AMOUNT
, HEADER_ID
, TOTAL_AMOUNT
, SET_OF_BOOKS_ID
FROM BOM.CST_RCV_ACQ_COSTS_EFC;
BOM.CST_RCV_ACQ_COSTS_EFC does not reference any database object
BOM.CST_RCV_ACQ_COSTS_EFC is referenced by following:
|
|
|