[Home] [Help] [Dependency Information]
Object Name: | XTR_TIME_RESTRICTIONS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_TIME_RESTRICTIONS |
Subobject Name: | |
Status: | VALID |
XTR_TIME_RESTRICTIONS contains details of time restriction on deals. Each row corresponds to a time limit placed on a deal type or any combination of deal type and deal subtype, product type, or counterparty. The unique key for this table is the deal type, deal subtype, product type and counterparty; however, only the deal type is required.
This table corresponds to the Deal Time Restrictions window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_TIME_RESTRICTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DEAL_TYPE
DEAL_SUBTYPE CPARTY_CODE SECURITY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
HIGH_VAL | NUMBER | Yes | Length of term limit (in terms of the period type) | |
LOW_VAL | NUMBER | Not currently used | ||
PERIOD_TYPE | VARCHAR2 | (1) | Yes | Period type of term limit (days, weeks, months, or years) |
RANGE | NUMBER | Number of days of the term limit | ||
SECURITY_NAME | VARCHAR2 | (10) | Code for products involved in a deal type |
Cut, paste (and edit) the following text to query this object:
SELECT CPARTY_CODE
, DEAL_SUBTYPE
, DEAL_TYPE
, HIGH_VAL
, LOW_VAL
, PERIOD_TYPE
, RANGE
, SECURITY_NAME
FROM XTR.XTR_TIME_RESTRICTIONS;
XTR.XTR_TIME_RESTRICTIONS does not reference any database object
XTR.XTR_TIME_RESTRICTIONS is referenced by following:
|
|
|