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

TABLE: LNS.LNS_INT_RATE_LINES

Object Details
Object Name: LNS_INT_RATE_LINES
Object Type: TABLE
Owner: LNS
FND Design Data: TableLNS.LNS_INT_RATE_LINES
Subobject Name:
Status: VALID


Interest Rate Lines Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
LNS_INT_RATE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_RATE_LINE_ID
LNS_INT_RATE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_RATE_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_RATE_LINE_ID NUMBER (15) Yes Interest Rate Line identifier
INTEREST_RATE_ID NUMBER (15) Yes Interest Rate identifier (foreign key to LNS_INT_RATE_HEADERS.INTEREST_RATE_ID)
INTEREST_RATE NUMBER

Interest Rate value
END_DATE_ACTIVE DATE

Effective End Date of interest rate value
START_DATE_ACTIVE DATE

Effective Start Date of interest rate value
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for locking purposes
Query Text

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


SELECT INTEREST_RATE_LINE_ID
,      INTEREST_RATE_ID
,      INTEREST_RATE
,      END_DATE_ACTIVE
,      START_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
FROM LNS.LNS_INT_RATE_LINES;

Dependencies

[top of page]

LNS.LNS_INT_RATE_LINES does not reference any database object

LNS.LNS_INT_RATE_LINES is referenced by following:

SchemaLNS
ViewLNS_INT_RATE_LINES#