[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_AGGR_DLY_RATES |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_AGGR_DLY_RATES |
Subobject Name: | |
Status: | VALID |
This intermediate table contains PJI currency conversion rates during a summarization run.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 0 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_FM_AGGR_DLY_RATES_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TIME_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | Summarization state data | ||
PF_CURRENCY_CODE | VARCHAR2 | (15) | Project Functional currency code | |
TIME_ID | NUMBER | Transaction date | ||
RATE | NUMBER | Primary Global currency conversion rate | ||
MAU | NUMBER | Primary Global minimum accountable unit | ||
RATE2 | NUMBER | Secondary Global currency conversion rate | ||
MAU2 | NUMBER | Secondary Global minimum accountable unit |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, PF_CURRENCY_CODE
, TIME_ID
, RATE
, MAU
, RATE2
, MAU2
FROM PJI.PJI_FM_AGGR_DLY_RATES;
PJI.PJI_FM_AGGR_DLY_RATES does not reference any database object
PJI.PJI_FM_AGGR_DLY_RATES is referenced by following:
|
|
|