DBA Data[Home] [Help] [Dependency Information]

TABLE: PJI.PJI_FM_AGGR_DLY_RATES_T

Object Details
Object Name: PJI_FM_AGGR_DLY_RATES_T
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

This table is used to store currency conversion rates for a given time identifier

Temporary Table Details

PJI.PJI_FM_AGGR_DLY_RATES_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER

Worker identifier
PF_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
TIME_ID NUMBER

Time identifier
RATE NUMBER

Currency conversion rate from functional currency to Global 1 currency
MAU NUMBER

Minimum accounting unit for Global 1 currency
RATE2 NUMBER

Currency conversion rate from functional currency to Global 2 currency
MAU2 NUMBER

Minimum accounting unit for Global 2 currency
Query Text

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_T;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_DLY_RATES_T does not reference any database object

PJI.PJI_FM_AGGR_DLY_RATES_T is referenced by following:

SchemaAPPS
SynonymPJI_FM_AGGR_DLY_RATES_T