View: XTR_STOCK_CASH_DIVIDENDS_V

Product:	XTR - Treasury
Description:	This view is used for Stock input form to view stock cash dividends information.
Implementation/DBA Data:	APPS.XTR_STOCK_CASH_DIVIDENDS_V

View Text

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'

Columns