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

TABLE: XTR.XTR_EXPOSURE_TRANSACTIONS

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


XTR_EXPOSURE_TRANSACTIONS contains the exposure transactions that are used for gap analysis of all cash flows that affect Treasury, but are not retrieved or recorded through deals or through interface with Oracle Cash Management. Each row with a TAX_BROKERAGE_TYPE of ?Y? represents a withholding tax or brokerage fee exposure transaction. Otherwise, the exposure transaction belongs to an exposure type from the XTR_EXPOSURE_TYPES table.
This table corresponds to the Exposure Transactions window and the Cancel Tax/Brokerage Settlements window of the Tax/Brokerage form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_EXPOSURE_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_NUMBER
XTR_EXPOSURE_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_CODE
ColumnAMOUNT_TYPE
ColumnDEAL_TYPE
XTR_EXPOSURE_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNT_NO
ColumnCOMPANY_CODE
XTR_EXPOSURE_TRANSACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_SUBTYPE
ColumnDEAL_TYPE
XTR_EXPOSURE_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPOSURE_TYPE
ColumnCOMPANY_CODE
XTR_EXPOSURE_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTHIRDPARTY_CODE
XTR_EXPOSURE_TRANSACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCURRENCY
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NO VARCHAR2 (20)
Settlement account number
ACTION_CODE VARCHAR2 (7)
Code for actions involved in executing deals
AMOUNT NUMBER

Actual exposure amount
AMOUNT_HCE NUMBER
Yes Exposure amount in reporting currency equivalent
AMOUNT_TYPE VARCHAR2 (7)
Code that identifies the purpose of the amounts for an exposure type
ARCHIVE_BY VARCHAR2 (30)
Not currently used
ARCHIVE_DATE DATE

Not currently used
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
AVG_RATE NUMBER

Currency exchange rate
BALANCE NUMBER

Not currently used
BENEFICIARY_CODE VARCHAR2 (7)
Not currently used
COMMENTS VARCHAR2 (255)
Comments
COMPANY_CODE VARCHAR2 (7) Yes Company code
CONTRA_NZD_AMOUNT NUMBER

Not currently used
COVERED_BY_FX_CONTRACT NUMBER

Reference to foreign exchange deal number
CPARTY_CODE VARCHAR2 (7)
Counterparty code
CPARTY_REF VARCHAR2 (7)
Counterparty account reference code
CREATED_BY VARCHAR2 (30) Yes User who created the exposure
CREATED_ON DATE
Yes Date on which the exposure was generated
CURRENCY VARCHAR2 (15) Yes Currency code
DEAL_STATUS VARCHAR2 (1)
Code for the execution status of deals and transactions
DEAL_SUBTYPE VARCHAR2 (7) Yes Code for deal executions permissible within a deal type
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
ESTIMATE_AMOUNT NUMBER

Estimated exposure amount
ESTIMATE_DATE DATE

Estimated exposure date
EXPOSURE_TYPE VARCHAR2 (10) Yes User-defined exposure type code
FIS_FOB VARCHAR2 (3)
Not currently used
INTERMEDIARY_BANK_DETAILS VARCHAR2 (62)
Not currently used
NZD_AMOUNT NUMBER

Not currently used
PAYMENT_AMOUNT NUMBER

Not currently used
PAYMENT_STATUS VARCHAR2 (1)
Not currently used
PORTFOLIO_CODE VARCHAR2 (7)
Code for grouping deals under a single portfolio
PROFIT_LOSS NUMBER

Not currently used
PURCHASING_MODULE VARCHAR2 (1)
Not currently used
SELECT_ACTION VARCHAR2 (1)
Not currently used
SELECT_REFERENCE NUMBER

Not currently used
SETTLE_ACTION_REQD VARCHAR2 (1) Yes Y or N indicates if exposure cashflow was created for settlement
STATUS_CODE VARCHAR2 (10)
Code for the execution status of deals and transactions
SUBSIDIARY_REF VARCHAR2 (10)
Not currently used
TAX_BROKERAGE_TYPE VARCHAR2 (1)
Not currently used
THIRDPARTY_CODE VARCHAR2 (7)
Settlement counterparty
TRANSACTION_NUMBER NUMBER
Yes Unique reference number assigned to a transaction
UPDATED_BY VARCHAR2 (30)
User who last updated the exposure transaction
UPDATED_ON DATE

Date on which the exposure transaction was updated
VALUE_DATE DATE

Actual date of settlement
WHOLESALE_REFERENCE NUMBER

Not currently used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
For Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
EXTERNAL_COMMENTS VARCHAR2 (255)
External Comments corresponding to an exposure transaction.
INTERNAL_COMMENTS VARCHAR2 (255)
Internal Comments corresponding to an exposure transaction.
DEAL_LINK_CODE VARCHAR2 (8)
Deal Linking Code corresponding to an exposure transaction.
EXTERNAL_DEAL_ID VARCHAR2 (240)
Not currently used
REQUEST_ID NUMBER

Not currently used
PROGRAM_APPLICATION_ID NUMBER

Not currently used
PROGRAM_ID NUMBER

Not currently used
PROGRAM_UPDATE_DATE DATE

Not currently used
CPARTY_ACCOUNT_NO VARCHAR2 (20)
Counterparty bank account number
COMPANY_ACCT_USE_ID NUMBER (15)
Settlement account ID
CPARTY_ACCT_USE_ID NUMBER (15)
Counterparty account ID
DUAL_AUTHORISATION_BY VARCHAR2 (30)
Login name of the user who created the deal (applies only if the Treasury DUAL_AUTHORISE system parameter is set to Y)
DUAL_AUTHORISATION_ON DATE

Date that the user created the deal (applies only if the Treasury DUAL_AUTHORISE system parameter is set to Y)
CASH_POSITION_EXPOSURE VARCHAR2 (1)
Y or N indicates if the exposure transation was generated through cash positioning
Query Text

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


SELECT ACCOUNT_NO
,      ACTION_CODE
,      AMOUNT
,      AMOUNT_HCE
,      AMOUNT_TYPE
,      ARCHIVE_BY
,      ARCHIVE_DATE
,      AUDIT_INDICATOR
,      AVG_RATE
,      BALANCE
,      BENEFICIARY_CODE
,      COMMENTS
,      COMPANY_CODE
,      CONTRA_NZD_AMOUNT
,      COVERED_BY_FX_CONTRACT
,      CPARTY_CODE
,      CPARTY_REF
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DEAL_STATUS
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      ESTIMATE_AMOUNT
,      ESTIMATE_DATE
,      EXPOSURE_TYPE
,      FIS_FOB
,      INTERMEDIARY_BANK_DETAILS
,      NZD_AMOUNT
,      PAYMENT_AMOUNT
,      PAYMENT_STATUS
,      PORTFOLIO_CODE
,      PROFIT_LOSS
,      PURCHASING_MODULE
,      SELECT_ACTION
,      SELECT_REFERENCE
,      SETTLE_ACTION_REQD
,      STATUS_CODE
,      SUBSIDIARY_REF
,      TAX_BROKERAGE_TYPE
,      THIRDPARTY_CODE
,      TRANSACTION_NUMBER
,      UPDATED_BY
,      UPDATED_ON
,      VALUE_DATE
,      WHOLESALE_REFERENCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXTERNAL_COMMENTS
,      INTERNAL_COMMENTS
,      DEAL_LINK_CODE
,      EXTERNAL_DEAL_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CPARTY_ACCOUNT_NO
,      COMPANY_ACCT_USE_ID
,      CPARTY_ACCT_USE_ID
,      DUAL_AUTHORISATION_BY
,      DUAL_AUTHORISATION_ON
,      CASH_POSITION_EXPOSURE
FROM XTR.XTR_EXPOSURE_TRANSACTIONS;

Dependencies

[top of page]

XTR.XTR_EXPOSURE_TRANSACTIONS does not reference any database object

XTR.XTR_EXPOSURE_TRANSACTIONS is referenced by following:

SchemaXTR
ViewXTR_EXPOSURE_TRANSACTIONS#