[Home] [Help] [Dependency Information]
Object Name: | XTR_AMOUNT_ACTIONS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_AMOUNT_ACTIONS |
Subobject Name: | |
Status: | VALID |
XTR_AMOUNT_ACTIONS contains the pre-defined amount actions that are associated with deal type, amount type combinations. Each row corresponds to an amount action. Many amount actions can be defined for a given deal type and amount type. Along with date types and amount types, amount actions help define the journals structure. Oracle Treasury derives the amount actions in XTR_DEAL_DATE_AMOUNTS from this table.
This table corresponds to the Actions region in the Amount Types tab region in the Deal Types / Product Types / Deal Subtypes window.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_AMOUNT_ACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
AMOUNT_TYPE ACTION_CODE ZD_EDITION_NAME |
XTR_AMOUNT_ACTIONS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
AMOUNT_TYPE USER_ACTION_CODE ZD_EDITION_NAME |
XTR_AMOUNT_ACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
AMOUNT_TYPE
DEAL_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_CODE | VARCHAR2 | (7) | Yes | Code for actions involved in executing deals |
USER_ACTION_CODE | VARCHAR2 | (7) | Yes | User-defined action code |
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
DESCRIPTION | VARCHAR2 | (80) | Yes | User-defined amount action description |
SEEDED_DESCRIPTION | VARCHAR2 | (80) | Yes | Pre-defined amount action description |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_CODE
, USER_ACTION_CODE
, AMOUNT_TYPE
, DEAL_TYPE
, DESCRIPTION
, SEEDED_DESCRIPTION
, UPDATED_BY
, ZD_EDITION_NAME
FROM XTR.XTR_AMOUNT_ACTIONS;
XTR.XTR_AMOUNT_ACTIONS does not reference any database object
XTR.XTR_AMOUNT_ACTIONS is referenced by following:
|
|
|