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


TABLE: XTR.XTR_CONFIRMATION_ACTIONS

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


XTR_CONFIRMATION_ACTIONS contains the deal confirmation actions required for a deal type. A deal type may have one or more actions associated with it, each of which may or may not require confirmation.
Each confirmation action belongs to a confirmation group. That confirmation group contains multiple confirmation actions. You create confirmation groups using the list of confirmation actions
in XTR_DEAL_CONFO_TYPES, which is supplied by Oracle. Once you save a confirmation group, you can choose to exclude (or re-include) one or more confirmation actions from the confirmation group. All confirmation actions must be defined in the XTR_DEAL_CONFO_TYPES table.
A confirmation group can be assigned to a party in the Counterparties window.
This table corresponds to the Confirmation Actions region on the Deal Confirmation Groups window.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTION_TYPE VARCHAR2 (50) Yes Deal action type
CONFO_ACTION_GROUP VARCHAR2 (20) Yes Confirmation action group
CONFO_REQD VARCHAR2 (1)
Flag to indicate if confirmation is required for the deal action (Y), or not (N)
DEAL_TYPE VARCHAR2 (7) Yes Code for high lev
GROUP_DESC VARCHAR2 (50) Yes Confirmation action group description
Query Text

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


SELECT ACTION_TYPE
,      CONFO_ACTION_GROUP
,      CONFO_REQD
,      DEAL_TYPE
,      GROUP_DESC
FROM XTR.XTR_CONFIRMATION_ACTIONS;

Dependencies

[top of page]

XTR.XTR_CONFIRMATION_ACTIONS does not reference any database object

XTR.XTR_CONFIRMATION_ACTIONS is referenced by following:

SchemaXTR
ViewXTR_CONFIRMATION_ACTIONS#