DBA Data[Home] [Help]

VIEW: APPS.XTR_QUICK_INPUT_DEALS_V

Source

View Text - Preformatted

SELECT QUOTE_NO ,DEAL_NO ,TRANSACTION_NUMBER ,COMPANY_CODE ,CPARTY_CODE ,CLIENT_CODE ,DEAL_TYPE ,DEAL_SUBTYPE ,PRODUCT_TYPE ,ISSUE_CODE ,CURRENCY1 ,CURRENCY2 ,TRANSACTION_RATE ,FX_SWAP_RATE ,AMOUNT_TYPE ,BASE_AMOUNT ,DEAL_DATE ,VALUE_DATE ,MATURITY_DATE ,DEALER_CODE ,CREATED_BY ,CREATED_ON ,UPDATED_BY ,UPDATED_ON ,FULL_INPUT_COMPLETED ,STATUS_CODE ,PORTFOLIO_CODE ,PUT_CALL ,PREMIUM_AMOUNT ,YEAR_CALC_TYPE, ROUNDING_TYPE, DAY_COUNT_TYPE, PREPAID_INTEREST from XTR_QUICK_INPUT_DEALS
View Text - HTML Formatted

SELECT QUOTE_NO
, DEAL_NO
, TRANSACTION_NUMBER
, COMPANY_CODE
, CPARTY_CODE
, CLIENT_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, ISSUE_CODE
, CURRENCY1
, CURRENCY2
, TRANSACTION_RATE
, FX_SWAP_RATE
, AMOUNT_TYPE
, BASE_AMOUNT
, DEAL_DATE
, VALUE_DATE
, MATURITY_DATE
, DEALER_CODE
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, FULL_INPUT_COMPLETED
, STATUS_CODE
, PORTFOLIO_CODE
, PUT_CALL
, PREMIUM_AMOUNT
, YEAR_CALC_TYPE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PREPAID_INTEREST
FROM XTR_QUICK_INPUT_DEALS