[Home] [Help]
[Dependency Information]
| Object Name: | XTR_A_EXPOSURE_TRANSACTIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XTR.XTR_A_EXPOSURE_TRANSACTIONS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 | (10) | 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) | ||
| ESTIMATE_DATE | DATE | |||
| ESTIMATE_AMOUNT | NUMBER | |||
| COVERED_BY_FX_CONTRACT | NUMBER | |||
| STATUS_CODE | VARCHAR2 | (10) | ||
| AUDIT_INDICATOR | VARCHAR2 | (1) | ||
| AUDIT_DATE_STORED | DATE |
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
, ESTIMATE_DATE
, ESTIMATE_AMOUNT
, COVERED_BY_FX_CONTRACT
, STATUS_CODE
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
FROM APPS.XTR_A_EXPOSURE_TRANSACTIONS_V;
APPS
XTR_A_EXPOSURE_TRANSACTIONS
APPS.XTR_A_EXPOSURE_TRANSACTIONS_V is not referenced by any database object
|
|
|
|