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

TABLE: XTR.XTR_DATE_AMOUNT_TYPES

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


XTR_DATE_AMOUNT_TYPES contains pre-defined date amount type combinations for deal types. Each row corresponds to a date amount type and whether or not it will appear on maturity reports.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_DATE_AMOUNT_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDEAL_TYPE
ColumnDATE_TYPE
ColumnAMOUNT_TYPE
ColumnZD_EDITION_NAME
XTR_DATE_AMOUNT_TYPES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAMOUNT_TYPE
ColumnDEAL_TYPE
XTR_DATE_AMOUNT_TYPES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnDATE_TYPE
ColumnDEAL_TYPE
Columns
Name Datatype Length Mandatory Comments
AMOUNT_TYPE VARCHAR2 (7) Yes Code that identifies the purpose of the amounts for a deal type
CASHFLOW_REPORT VARCHAR2 (1)
Not currently used
DATE_TYPE VARCHAR2 (7) Yes Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
MATURITY_REPORT VARCHAR2 (1)
Flag to indicate if the date amount type will be included in maturity reports (Y), or not (N)
PAY_RECEIVE_REPORT VARCHAR2 (1)
Not currently used
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT AMOUNT_TYPE
,      CASHFLOW_REPORT
,      DATE_TYPE
,      DEAL_TYPE
,      MATURITY_REPORT
,      PAY_RECEIVE_REPORT
,      ZD_EDITION_NAME
FROM XTR.XTR_DATE_AMOUNT_TYPES;

Dependencies

[top of page]

XTR.XTR_DATE_AMOUNT_TYPES does not reference any database object

XTR.XTR_DATE_AMOUNT_TYPES is referenced by following:

SchemaXTR
ViewXTR_DATE_AMOUNT_TYPES#