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: XTR.XTR_STOCK_ALLOC_DETAILS#

Source

View Text - Preformatted


select STOCK_ALLOC_DETAIL_ID STOCK_ALLOC_DETAIL_ID, BATCH_ID BATCH_ID, DEAL_NO DEAL_NO, CROSS_REF_NO CROSS_REF_NO, FAIR_VALUE FAIR_VALUE, INIT_CONSIDERATION INIT_CONSIDERATION, QUANTITY QUANTITY, REMAINING_QUANTITY REMAINING_QUANTITY, PRICE_PER_SHARE PRICE_PER_SHARE, REAL_GAIN_LOSS REAL_GAIN_LOSS, FRONT_END_BROKERAGE FRONT_END_BROKERAGE, BACK_END_BROKERAGE BACK_END_BROKERAGE, CROSS_REF_DEAL_DATE CROSS_REF_DEAL_DATE, CROSS_REF_START_DATE CROSS_REF_START_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AVG_RATE_LAST_PROCESSED AVG_RATE_LAST_PROCESSED from "XTR"."XTR_STOCK_ALLOC_DETAILS"

View Text - HTML Formatted

SELECT STOCK_ALLOC_DETAIL_ID STOCK_ALLOC_DETAIL_ID
, BATCH_ID BATCH_ID
, DEAL_NO DEAL_NO
, CROSS_REF_NO CROSS_REF_NO
, FAIR_VALUE FAIR_VALUE
, INIT_CONSIDERATION INIT_CONSIDERATION
, QUANTITY QUANTITY
, REMAINING_QUANTITY REMAINING_QUANTITY
, PRICE_PER_SHARE PRICE_PER_SHARE
, REAL_GAIN_LOSS REAL_GAIN_LOSS
, FRONT_END_BROKERAGE FRONT_END_BROKERAGE
, BACK_END_BROKERAGE BACK_END_BROKERAGE
, CROSS_REF_DEAL_DATE CROSS_REF_DEAL_DATE
, CROSS_REF_START_DATE CROSS_REF_START_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AVG_RATE_LAST_PROCESSED AVG_RATE_LAST_PROCESSED
FROM "XTR"."XTR_STOCK_ALLOC_DETAILS"