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

TABLE: XTR.XTR_CONFIRMATION_DETAILS

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


XTR_CONFIRMATION_DETAILS contains details about your confirmation letters. Each row corresponds to one confirmation letter and includes the deal action, company, counterparty, deal type, deal subtype, deal and transaction numbers, and confirmation verification information for the confirmation letter.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTION_TYPE VARCHAR2 (50) Yes Deal confirmation action type
AMOUNT NUMBER

Transaction amount
AMOUNT_TYPE VARCHAR2 (7)
Code that identifies the purpose of the amounts for a deal type
CLIENT_CODE VARCHAR2 (7)
Client for which the deal is made
COMPANY_CODE VARCHAR2 (7) Yes Company code
CONFIRMATION_VALIDATED_BY VARCHAR2 (10)
User who validated the confirmation
CONFIRMATION_VALIDATED_ON DATE

Date the confirmation is validated
CONFO_PARTY_CODE VARCHAR2 (7)
Confirmation party code
CONFO_VALIDATION_BOTH VARCHAR2 (1) Yes Flag to indicates if an action requires just validation (V) or both validation and a confirmation letter (B)
CPARTY_CODE VARCHAR2 (7) Yes Counterparty code
CURRENCY VARCHAR2 (15)
Currency code
DATE_ACTION_INITIATED DATE
Yes Date the action was initiated
DEAL_NO NUMBER
Yes Unique number assigned to each deal
DEAL_SUBTYPE VARCHAR2 (7)
Code for deal executions permissible within a deal type
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
DEAL_UPDATED_YN VARCHAR2 (1)
Flag to indicate if deal is updated (Y), or not (N)
FILE_NAME VARCHAR2 (100)
Not currently used
INITIALLY_PRINTED_ON DATE

Date the confirmation letter is first printed
PARTY_CONFO_CHECKED VARCHAR2 (1)
Flag to indicate if party confirmation is checked (Y) or not (N)
PARTY_CONFO_CHECKED_BY VARCHAR2 (10)
User who checked the party confirmation
PARTY_CONFO_CHECKED_ON DATE

Date the party confirmation was checked
PARTY_CONFO_FILE_NAME VARCHAR2 (50)
Not currently used
REPRINTED_ON DATE

Date the confirmation letter is reprinted
REPRINT_REQUESTED_BY VARCHAR2 (10)
User who requested the reprint of a confirmation letter
SETTLE_DATE DATE

Settle date
STATUS_CODE VARCHAR2 (10) Yes Status code
TRANSACTION_NO NUMBER

Unique reference number assigned to a transaction
Query Text

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


SELECT ACTION_TYPE
,      AMOUNT
,      AMOUNT_TYPE
,      CLIENT_CODE
,      COMPANY_CODE
,      CONFIRMATION_VALIDATED_BY
,      CONFIRMATION_VALIDATED_ON
,      CONFO_PARTY_CODE
,      CONFO_VALIDATION_BOTH
,      CPARTY_CODE
,      CURRENCY
,      DATE_ACTION_INITIATED
,      DEAL_NO
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      DEAL_UPDATED_YN
,      FILE_NAME
,      INITIALLY_PRINTED_ON
,      PARTY_CONFO_CHECKED
,      PARTY_CONFO_CHECKED_BY
,      PARTY_CONFO_CHECKED_ON
,      PARTY_CONFO_FILE_NAME
,      REPRINTED_ON
,      REPRINT_REQUESTED_BY
,      SETTLE_DATE
,      STATUS_CODE
,      TRANSACTION_NO
FROM XTR.XTR_CONFIRMATION_DETAILS;

Dependencies

[top of page]

XTR.XTR_CONFIRMATION_DETAILS does not reference any database object

XTR.XTR_CONFIRMATION_DETAILS is referenced by following:

SchemaXTR
ViewXTR_CONFIRMATION_DETAILS#