[Home] [Help] [Dependency Information]
Object Name: | XTR_MIRROR_DDA_LIM_ROW_TMP# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NO | VARCHAR2 | (20) | ||
AMOUNT | NUMBER | Yes | ||
AMOUNT_DATE | DATE | |||
AMOUNT_INDIC | NUMBER | |||
COMMENCE_DATE | DATE | |||
COMPANY_CODE | VARCHAR2 | (7) | ||
CONTRA_CCY | VARCHAR2 | (15) | ||
COUNTRY_CODE | VARCHAR2 | (2) | ||
CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | ||
CURRENCY | VARCHAR2 | (15) | ||
CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
DATE_LAST_SET | DATE | Yes | ||
DEALER_CODE | VARCHAR2 | (10) | ||
DEAL_NUMBER | NUMBER | Yes | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
HCE_AMOUNT | NUMBER | Yes | ||
HCE_UTILISED_AMOUNT | NUMBER | |||
LIMIT_CODE | VARCHAR2 | (7) | ||
LIMIT_PARTY | VARCHAR2 | (7) | ||
LIMIT_TYPE | VARCHAR2 | (2) | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
STATUS_CODE | VARCHAR2 | (10) | ||
TRANSACTION_NUMBER | NUMBER | Yes | ||
TRANSACTION_RATE | NUMBER | |||
UTILISED_AMOUNT | NUMBER | |||
BANK_ACCT_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NO
, AMOUNT
, AMOUNT_DATE
, AMOUNT_INDIC
, COMMENCE_DATE
, COMPANY_CODE
, CONTRA_CCY
, COUNTRY_CODE
, CROSS_REF_TO_OTHER_PARTY
, CURRENCY
, CURRENCY_COMBINATION
, DATE_LAST_SET
, DEALER_CODE
, DEAL_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, HCE_AMOUNT
, HCE_UTILISED_AMOUNT
, LIMIT_CODE
, LIMIT_PARTY
, LIMIT_TYPE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, STATUS_CODE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, UTILISED_AMOUNT
, BANK_ACCT_USE_ID
FROM XTR.XTR_MIRROR_DDA_LIM_ROW_TMP#;
|
|
|