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

TABLE: XTR.XTR_DEAL_OVERWRITE_TYPES

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


This table will store overwrite types that are allowed for each deal type.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_DEAL_OVERWRITE_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCODE
ColumnDEAL_TYPE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DEAL_OVERWRITE_TYPE_ID NUMBER (15) Yes Unique identifier for each row of deal overwrite type.
DEAL_TYPE VARCHAR2 (7) Yes Denotes the deal type associated with this overwrite type.
CODE VARCHAR2 (30)
Code that represents the deal overwrite type. If the value is null, then there is no overwrite type associated with this deal type.
AUTHORIZED VARCHAR2 (1) Yes Specifies if the overwrite type is authorized for use by deals with the associated deal types. An unauthorized overwrite type cannot be assigned to new deals but will remains as a reference to existing deals.
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT DEAL_OVERWRITE_TYPE_ID
,      DEAL_TYPE
,      CODE
,      AUTHORIZED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM XTR.XTR_DEAL_OVERWRITE_TYPES;

Dependencies

[top of page]

XTR.XTR_DEAL_OVERWRITE_TYPES does not reference any database object

XTR.XTR_DEAL_OVERWRITE_TYPES is referenced by following:

SchemaXTR
ViewXTR_DEAL_OVERWRITE_TYPES#