[Home] [Help] [Dependency Information]
Object Name: | FTP_REPRICE_PAT_EVENT |
---|---|
Object Type: | TABLE |
Owner: | FTP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTP_REPRICE_PAT_EVENT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REPRICE_ID
EVENT_SEQ |
FTP_REPRICE_PAT_EVENT_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REPRICE_ID
ADJUSTABLE_TYPE_CODE EVENT_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPRICE_ID | NUMBER | (9) | Yes | |
ADJUSTABLE_TYPE_CODE | NUMBER | (9) | Yes | |
EVENT_SEQ | NUMBER | (9) | Yes | |
REPRICE_METHOD_CODE | NUMBER | (5) | Yes | |
EVENT_MONTH | NUMBER | (4) | ||
EVENT_DAY | NUMBER | (4) | ||
EVENT_FREQ | NUMBER | (9) | ||
EVENT_MULT | VARCHAR2 | (1) | ||
EVENT_REPEAT_TIMES | NUMBER | (9) | ||
NET_RATE | NUMBER | |||
GROSS_RATE | NUMBER | |||
TRANSFER_RATE | NUMBER | |||
IRC | NUMBER | (9) | ||
TRANSFER_RATE_IRC | NUMBER | (9) | ||
NET_MARGIN | NUMBER | |||
GROSS_MARGIN | NUMBER | |||
TRANSFER_MARGIN | NUMBER | |||
RATE_CAP_LIFE | NUMBER | |||
RATE_FLOOR_LIFE | NUMBER | |||
RATE_SET_LAG | NUMBER | (9) | ||
RATE_SET_LAG_MULT | VARCHAR2 | (1) | ||
YIELD_CURVE_TERM | NUMBER | (9) | ||
YIELD_CURVE_TERM_MULT | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REPRICE_ID
, ADJUSTABLE_TYPE_CODE
, EVENT_SEQ
, REPRICE_METHOD_CODE
, EVENT_MONTH
, EVENT_DAY
, EVENT_FREQ
, EVENT_MULT
, EVENT_REPEAT_TIMES
, NET_RATE
, GROSS_RATE
, TRANSFER_RATE
, IRC
, TRANSFER_RATE_IRC
, NET_MARGIN
, GROSS_MARGIN
, TRANSFER_MARGIN
, RATE_CAP_LIFE
, RATE_FLOOR_LIFE
, RATE_SET_LAG
, RATE_SET_LAG_MULT
, YIELD_CURVE_TERM
, YIELD_CURVE_TERM_MULT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM FTP.FTP_REPRICE_PAT_EVENT;
FTP.FTP_REPRICE_PAT_EVENT does not reference any database object
FTP.FTP_REPRICE_PAT_EVENT is referenced by following:
|
|
|