[Home] [Help] [Dependency Information]
Object Name: | XTR_DEAL_OVERWRITE_TYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DEAL_OVERWRITE_TYPES |
Subobject Name: | |
Status: | VALID |
This table will store overwrite types that are allowed for each deal type.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DEAL_OVERWRITE_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
CODE
DEAL_TYPE ZD_EDITION_NAME |
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 |
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;
XTR.XTR_DEAL_OVERWRITE_TYPES does not reference any database object
XTR.XTR_DEAL_OVERWRITE_TYPES is referenced by following:
|
|
|