eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.XTR_STOCK_CASH_DIVIDENDS_V

Source

View Text - Preformatted


SELECT RT.DEAL_NUMBER DEAL_NUMBER, RT.TRANSACTION_NUMBER TRANSACTION_NUMBER, ST.STOCK_ISSUE_CODE STOCK_ISSUE_CODE, RT.COMPANY_CODE COMPANY_CODE, RT.CPARTY_CODE CPARTY_CODE, RT.CLIENT_CODE CLIENT_CODE, RT.CURRENCY CURRENCY, RT.PORTFOLIO_CODE PORTFOLIO_CODE, RT.PRODUCT_TYPE PRODUCT_TYPE, RT.QUANTITY QUANTITY, ST.DIVIDEND_PER_SHARE DIVIDEND_PER_SHARE, RT.INTEREST TOTAL_DIVIDENDS, RT.TAX_RATE TAX_RATE, RT.TAX_AMOUNT TAX_AMOUNT, (RT.INTEREST - nvl(RT.TAX_AMOUNT,0)) AFTER_TAX, RT.DEAL_DATE DECLARE_DATE, RT.START_DATE RECORD_DATE, RT.SETTLE_DATE PAYMENT_DATE From XTR_ROLLOVER_TRANSACTIONS RT, XTR_STOCK_CASH_DIVIDENDS ST WHERE RT.TRANSACTION_NUMBER = ST.CASH_DIVIDEND_ID and RT.DEAL_TYPE='STOCK'

View Text - HTML Formatted

SELECT RT.DEAL_NUMBER DEAL_NUMBER
, RT.TRANSACTION_NUMBER TRANSACTION_NUMBER
, ST.STOCK_ISSUE_CODE STOCK_ISSUE_CODE
, RT.COMPANY_CODE COMPANY_CODE
, RT.CPARTY_CODE CPARTY_CODE
, RT.CLIENT_CODE CLIENT_CODE
, RT.CURRENCY CURRENCY
, RT.PORTFOLIO_CODE PORTFOLIO_CODE
, RT.PRODUCT_TYPE PRODUCT_TYPE
, RT.QUANTITY QUANTITY
, ST.DIVIDEND_PER_SHARE DIVIDEND_PER_SHARE
, RT.INTEREST TOTAL_DIVIDENDS
, RT.TAX_RATE TAX_RATE
, RT.TAX_AMOUNT TAX_AMOUNT
, (RT.INTEREST - NVL(RT.TAX_AMOUNT
, 0)) AFTER_TAX
, RT.DEAL_DATE DECLARE_DATE
, RT.START_DATE RECORD_DATE
, RT.SETTLE_DATE PAYMENT_DATE
FROM XTR_ROLLOVER_TRANSACTIONS RT
, XTR_STOCK_CASH_DIVIDENDS ST
WHERE RT.TRANSACTION_NUMBER = ST.CASH_DIVIDEND_ID
AND RT.DEAL_TYPE='STOCK'