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

TABLE: LNS.LNS_AMORT_SCHEDS_GT

Object Details
Object Name: LNS_AMORT_SCHEDS_GT
Object Type: TABLE
Owner: LNS
Subobject Name:
Status: VALID

Temporary Table Details

LNS.LNS_AMORT_SCHEDS_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$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
LNS_AMORT_SCHEDS_GT_U1 NORMAL UNIQUE Tablespace ColumnLOAN_ID
ColumnINSTALLMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Yes
INSTALLMENT_NUMBER NUMBER
Yes
DUE_DATE DATE

PRINCIPAL_AMOUNT NUMBER

INTEREST_AMOUNT NUMBER

FEE_AMOUNT NUMBER

OTHER_AMOUNT NUMBER

BEGIN_BALANCE NUMBER

END_BALANCE NUMBER

TOTAL NUMBER

INTEREST_CUMULATIVE NUMBER

PRINCIPAL_CUMULATIVE NUMBER

FEES_CUMULATIVE NUMBER

OTHER_CUMULATIVE NUMBER

RATE_ID NUMBER (15)
SOURCE VARCHAR2 (30)
GRAND_TOTAL_FLAG VARCHAR2 (1)
Query Text

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


SELECT LOAN_ID
,      INSTALLMENT_NUMBER
,      DUE_DATE
,      PRINCIPAL_AMOUNT
,      INTEREST_AMOUNT
,      FEE_AMOUNT
,      OTHER_AMOUNT
,      BEGIN_BALANCE
,      END_BALANCE
,      TOTAL
,      INTEREST_CUMULATIVE
,      PRINCIPAL_CUMULATIVE
,      FEES_CUMULATIVE
,      OTHER_CUMULATIVE
,      RATE_ID
,      SOURCE
,      GRAND_TOTAL_FLAG
FROM LNS.LNS_AMORT_SCHEDS_GT;

Dependencies

[top of page]

LNS.LNS_AMORT_SCHEDS_GT does not reference any database object

LNS.LNS_AMORT_SCHEDS_GT is referenced by following:

SchemaAPPS
SynonymLNS_AMORT_SCHEDS_GT