[Home] [Help] [Dependency Information]
Object Name: | FTP_TRANSFER_PRICE_RULE |
---|---|
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_TRANSFER_PRICE_RULE_U1 | 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 | ||
DATA_SOURCE_CODE | NUMBER | (4) | Yes | |
TP_CALC_METHOD_CODE | NUMBER | (4) | Yes | |
GROSS_RATE_FLG | NUMBER | (1) | Yes | |
INTEREST_RATE_CODE | NUMBER | (9) | ||
YIELD_CURVE_TERM | NUMBER | (9) | ||
YIELD_CURVE_MULT | VARCHAR2 | (1) | ||
HISTORICAL_TERM | NUMBER | (9) | ||
HISTORICAL_MULT | VARCHAR2 | (1) | ||
ASSIGNMENT_DATE_CODE | NUMBER | (4) | ||
OPTION_COST_METHOD_CODE | NUMBER | (4) | ||
TARGET_BAL_CODE | NUMBER | (4) | ||
RATE_SPREAD | NUMBER | |||
LAG_TERM | NUMBER | (9) | ||
LAG_MULT | VARCHAR2 | (1) | ||
ACROSS_ORG_UNIT_FLG | NUMBER | (1) | ||
MID_PERIOD_REPRICE_FLG | NUMBER | (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 OBJECT_DEFINITION_ID
, LINE_ITEM_ID
, CURRENCY
, COND_SEQUENCE
, DATA_SOURCE_CODE
, TP_CALC_METHOD_CODE
, GROSS_RATE_FLG
, INTEREST_RATE_CODE
, YIELD_CURVE_TERM
, YIELD_CURVE_MULT
, HISTORICAL_TERM
, HISTORICAL_MULT
, ASSIGNMENT_DATE_CODE
, OPTION_COST_METHOD_CODE
, TARGET_BAL_CODE
, RATE_SPREAD
, LAG_TERM
, LAG_MULT
, ACROSS_ORG_UNIT_FLG
, MID_PERIOD_REPRICE_FLG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM FTP.FTP_TRANSFER_PRICE_RULE;
FTP.FTP_TRANSFER_PRICE_RULE does not reference any database object
FTP.FTP_TRANSFER_PRICE_RULE is referenced by following:
|
|
|