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


VIEW: APPS.XTR_R_EXPOSURE_TRANSACTIONS_V

Object Details
Object Name: XTR_R_EXPOSURE_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_R_EXPOSURE_TRANSACTIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_NUMBER NUMBER
Yes
COMPANY_CODE VARCHAR2 (7) Yes
DEAL_TYPE VARCHAR2 (7) Yes
DEAL_SUBTYPE VARCHAR2 (7) Yes
EXPOSURE_TYPE VARCHAR2 (7) Yes
CURRENCY VARCHAR2 (15) Yes
VALUE_DATE DATE

AMOUNT NUMBER

SETTLE_ACTION_REQD VARCHAR2 (1) Yes
AMOUNT_HCE NUMBER
Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

THIRDPARTY_CODE VARCHAR2 (7)
ACTION_CODE VARCHAR2 (7)
AMOUNT_TYPE VARCHAR2 (7)
ACCOUNT_NO VARCHAR2 (20)
COMMENTS VARCHAR2 (255)
CPARTY_REF VARCHAR2 (7)
PORTFOLIO_CODE VARCHAR2 (7)
TAX_BROKERAGE_TYPE VARCHAR2 (1)
ARCHIVE_DATE DATE

ARCHIVE_BY VARCHAR2 (30)
PURCHASING_MODULE VARCHAR2 (1)
BENEFICIARY_CODE VARCHAR2 (7)
NZD_AMOUNT NUMBER

FIS_FOB VARCHAR2 (3)
SUBSIDIARY_REF VARCHAR2 (10)
INTERMEDIARY_BANK_DETAILS VARCHAR2 (62)
DEAL_STATUS VARCHAR2 (1)
WHOLESALE_REFERENCE NUMBER

SELECT_REFERENCE NUMBER

PROFIT_LOSS NUMBER

SELECT_ACTION VARCHAR2 (1)
PAYMENT_AMOUNT NUMBER

BALANCE NUMBER

AVG_RATE NUMBER

CONTRA_NZD_AMOUNT NUMBER

CPARTY_CODE VARCHAR2 (7)
PAYMENT_STATUS VARCHAR2 (1)
AUDIT_INDICATOR VARCHAR2 (1)
ESTIMATE_DATE DATE

ESTIMATE_AMOUNT NUMBER

COVERED_BY_FX_CONTRACT NUMBER

STATUS_CODE VARCHAR2 (10)
Query Text

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


SELECT TRANSACTION_NUMBER
,      COMPANY_CODE
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      EXPOSURE_TYPE
,      CURRENCY
,      VALUE_DATE
,      AMOUNT
,      SETTLE_ACTION_REQD
,      AMOUNT_HCE
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      THIRDPARTY_CODE
,      ACTION_CODE
,      AMOUNT_TYPE
,      ACCOUNT_NO
,      COMMENTS
,      CPARTY_REF
,      PORTFOLIO_CODE
,      TAX_BROKERAGE_TYPE
,      ARCHIVE_DATE
,      ARCHIVE_BY
,      PURCHASING_MODULE
,      BENEFICIARY_CODE
,      NZD_AMOUNT
,      FIS_FOB
,      SUBSIDIARY_REF
,      INTERMEDIARY_BANK_DETAILS
,      DEAL_STATUS
,      WHOLESALE_REFERENCE
,      SELECT_REFERENCE
,      PROFIT_LOSS
,      SELECT_ACTION
,      PAYMENT_AMOUNT
,      BALANCE
,      AVG_RATE
,      CONTRA_NZD_AMOUNT
,      CPARTY_CODE
,      PAYMENT_STATUS
,      AUDIT_INDICATOR
,      ESTIMATE_DATE
,      ESTIMATE_AMOUNT
,      COVERED_BY_FX_CONTRACT
,      STATUS_CODE
FROM APPS.XTR_R_EXPOSURE_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.XTR_R_EXPOSURE_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymXTR_R_EXPOSURE_TRANSACTIONS

APPS.XTR_R_EXPOSURE_TRANSACTIONS_V is not referenced by any database object