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


TABLE: APPS.FII_AP_RATES_GT

Object Details
Object Name: FII_AP_RATES_GT
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

Temporary Table Details

APPS.FII_AP_RATES_GT 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
TRX_CURRENCY VARCHAR2 (15)
FUNC_CURRENCY VARCHAR2 (15)
EXCHANGE_DATE DATE

EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_RATE NUMBER

FUNCTIONAL_MAU NUMBER

INVOICE_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRX_CURRENCY
,      FUNC_CURRENCY
,      EXCHANGE_DATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      FUNCTIONAL_MAU
,      INVOICE_DATE
FROM APPS.FII_AP_RATES_GT;

Dependencies

[top of page]

APPS.FII_AP_RATES_GT does not reference any database object

APPS.FII_AP_RATES_GT is referenced by following:

SchemaAPPS
Package BodyFII_AP_INV_SUM_INC - show dependent code