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

TABLE: XTR.XTR_TIME_RESTRICTIONS

Object Details
Object Name: XTR_TIME_RESTRICTIONS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_TIME_RESTRICTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_TYPE
ColumnDEAL_SUBTYPE
ColumnCPARTY_CODE
ColumnSECURITY_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

XTR.XTR_TIME_RESTRICTIONS does not reference any database object

XTR.XTR_TIME_RESTRICTIONS is referenced by following:

SchemaXTR
ViewXTR_TIME_RESTRICTIONS#