[Home] [Help] [Dependency Information]
Object Name: | FTP_ADJUSTMENT_RULE |
---|---|
Object Type: | TABLE |
Owner: | FTP |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTP_ADJUSTMENT_RULE_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_DEFINITION_ID
LINE_ITEM_ID CURRENCY COND_SEQUENCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_DEFINITION_ID | NUMBER | (9) | Yes | |
LINE_ITEM_ID | NUMBER | Yes | ||
CURRENCY | VARCHAR2 | (15) | Yes | |
COND_SEQUENCE | NUMBER | Yes | ||
ADJUSTMENT_TYPE_CODE | NUMBER | (5) | Yes | |
CALC_METHOD_CODE | NUMBER | (5) | Yes | |
REFERENCE_TERM_CODE | NUMBER | (5) | ||
LOOKUP_METHOD_CODE | NUMBER | (5) | ||
ASSIGNMENT_DATE_CODE | NUMBER | (5) | ||
INTEREST_RATE_CODE | NUMBER | (5) | ||
BREAK_FUNDING_RATE | NUMBER | |||
MINIMUM_CHARGE | NUMBER | |||
BREAK_FUNDING_AMT | NUMBER | |||
RATE_SPREAD | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | 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 OBJECT_DEFINITION_ID
, LINE_ITEM_ID
, CURRENCY
, COND_SEQUENCE
, ADJUSTMENT_TYPE_CODE
, CALC_METHOD_CODE
, REFERENCE_TERM_CODE
, LOOKUP_METHOD_CODE
, ASSIGNMENT_DATE_CODE
, INTEREST_RATE_CODE
, BREAK_FUNDING_RATE
, MINIMUM_CHARGE
, BREAK_FUNDING_AMT
, RATE_SPREAD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM FTP.FTP_ADJUSTMENT_RULE;
FTP.FTP_ADJUSTMENT_RULE does not reference any database object
FTP.FTP_ADJUSTMENT_RULE is referenced by following:
|
|
|