Skip to content

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

TABLE: XTR.XTR_INTRA_DAY_LIMITS

Object Details
Object Name: XTR_INTRA_DAY_LIMITS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_INTRA_DAY_LIMITS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AUDIT_INDICATOR VARCHAR2 (1)
AUTHORISED VARCHAR2 (1)
Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
CREATED_BY VARCHAR2 (30)
User who created this record.
CREATED_ON DATE

Dealer identifier. Foreign key to XTR_DEALER_CODES.
DEALER_CODE VARCHAR2 (10) Yes Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DEAL_TYPE VARCHAR2 (7) Yes Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
LIMIT_AMOUNT NUMBER
Yes Total amount allowed for this limit.
UPDATED_BY VARCHAR2 (30)
Last updated user.
UPDATED_ON DATE

Last updated date.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_INDICATOR
,      AUTHORISED
,      CREATED_BY
,      CREATED_ON
,      DEALER_CODE
,      DEAL_TYPE
,      LIMIT_AMOUNT
,      UPDATED_BY
,      UPDATED_ON
FROM XTR.XTR_INTRA_DAY_LIMITS;

Dependencies

[top of page]

XTR.XTR_INTRA_DAY_LIMITS does not reference any database object

XTR.XTR_INTRA_DAY_LIMITS is referenced by following:

SchemaAPPS
SynonymXTR_INTRA_DAY_LIMITS