[Home] [Help] [Dependency Information]
Object Name: | PA_MC_UPGRADE_RATES# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRIMARY_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
REPORTING_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
FROM_CURRENCY | VARCHAR2 | (15) | Yes | |
TO_CURRENCY | VARCHAR2 | (15) | Yes | |
DENOM_RATE | NUMBER | |||
NUM_RATE | NUMBER | |||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_DATE | DATE | |||
RATE_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_SET_OF_BOOKS_ID
, REPORTING_SET_OF_BOOKS_ID
, FROM_CURRENCY
, TO_CURRENCY
, DENOM_RATE
, NUM_RATE
, EXCHANGE_RATE
, EXCHANGE_DATE
, RATE_TYPE
FROM PA.PA_MC_UPGRADE_RATES#;
|
|
|