[Home] [Help] [Dependency Information]
Object Name: | WSH_FREIGHT_COSTS_EFC |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_FREIGHT_COSTS_EFC |
Subobject Name: | |
Status: | VALID |
WSH_FREIGHT_COSTS_EFC acts an archive table for the euro as a functional currency project
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONVERSION_RATE | NUMBER | conversion rate | ||
UNIT_AMOUNT | NUMBER | Yes | unit amount | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | currency code |
FREIGHT_COST_ID | NUMBER | Yes | freight cost 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 CONVERSION_RATE
, UNIT_AMOUNT
, CURRENCY_CODE
, FREIGHT_COST_ID
, TOTAL_AMOUNT
, SET_OF_BOOKS_ID
FROM WSH.WSH_FREIGHT_COSTS_EFC;
WSH.WSH_FREIGHT_COSTS_EFC does not reference any database object
WSH.WSH_FREIGHT_COSTS_EFC is referenced by following:
|
|
|