CMP_TCS_STOCK_HISTORY_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

STOCK_HISTORY_ID STMT_PAGE_DEF_ID PERD_RUN_ID CAT_ID GRANT_DATE_SEQ GRANT_DATE_LABEL GRANT_DATE_AVAIL_DSP GRANT_DATE_DSPLAY STOCK_SYMBOL_SEQ STOCK_SYMBOL_LABEL STOCK_SYMBOL_AVAIL_DSP STOCK_SYMBOL_DSPLAY GRANT_NUMBER_SEQ GRANT_NUMBER_LABEL GRANT_NUMBER_AVAIL_DSP GRANT_NUMBER_DSPLAY GRANT_NAME_SEQ GRANT_NAME_LABEL GRANT_NAME_AVAIL_DSP GRANT_NAME_DSPLAY GRANT_TYPE_SEQ GRANT_TYPE_LABEL GRANT_TYPE_AVAIL_DSP GRANT_TYPE_DSPLAY TOTAL_SHRS_SEQ TOTAL_SHRS_LABEL TOTAL_SHRS_AVAIL_DSP TOTAL_SHRS_DSPLAY TOTAL_SHRS_IN_CHART1_FLAG TOTAL_SHRS_IN_CHART2_FLAG SHRS_GRANTED_SEQ SHRS_GRANTED_LABEL SHRS_GRANTED_AVAIL_DSP SHRS_GRANTED_DSPLAY SHRS_GRNTD_IN_CHART1_FLAG SHRS_GRNTD_IN_CHART2_FLAG XRCISE_PRICE_SEQ XRCISE_PRICE_LABEL XRCISE_PRICE_AVAIL_DSP XRCISE_PRICE_DSPLAY GRANT_PRICE_SEQ GRANT_PRICE_LABEL GRANT_PRICE_AVAIL_DSP GRANT_PRICE_DSPLAY GRANT_VALUE_SEQ GRANT_VALUE_LABEL GRANT_VALUE_AVAIL_DSP GRANT_VALUE_DSPLAY CANCELLED_SHRS_SEQ CANCELLED_SHRS_LABEL CANCELLED_SHRS_AVAIL_DSP CANCELLED_SHRS_DSPLAY REASON_CODE_SEQ REASON_CODE_LABEL REASON_CODE_AVAIL_DSP REASON_CODE_DSPLAY CLASS_TYPE_SEQ CLASS_TYPE_LABEL CLASS_TYPE_AVAIL_DSP CLASS_TYPE_DSPLAY MISC_SEQ MISC_LABEL MISC_AVAIL_DSP MISC_DSPLAY EST_VALUE_SEQ EST_VALUE_LABEL EST_VALUE_AVAIL_DSP EST_VALUE_DSPLAY EST_MKT_VAL_SEQ EST_MKT_VAL_LABEL EST_MKT_VAL_AVAIL_DSP EST_MKT_VAL_DSPLAY VST_SHRS_SEQ VST_SHRS_LABEL VST_SHRS_AVAIL_DSP VST_SHRS_DSPLAY VST_SHRS_IN_CHART1_FLAG VST_SHRS_IN_CHART2_FLAG VST_EX_SEQ VST_EX_LABEL VST_EX_AVAIL_DSP VST_EX_DSPLAY VST_EX_IN_CHART1_FLAG VST_EX_IN_CHART2_FLAG VST_UNEX_SEQ VST_UNEX_LABEL VST_UNEX_AVAIL_DSP VST_UNEX_DSPLAY VST_UNEX_IN_CHART1_FLAG VST_UNEX_IN_CHART2_FLAG VST_EST_VAL_SEQ VST_EST_VAL_LABEL VST_EST_VAL_AVAIL_DSP VST_EST_VAL_DSPLAY VST_EST_MKT_VAL_SEQ VST_EST_MKT_VAL_LABEL VST_EST_MKT_VAL_AVAIL_DSP VST_EST_MKT_VAL_DSP VST_EST_UNEX_VAL_SEQ VST_EST_UNEX_VAL_LABEL VST_EST_UNEX_VAL_AVAIL_DSP VST_EST_UNEX_VAL_DSP VST_EST_UNEX_MKT_VAL_SEQ VST_EST_UNEX_MKT_VAL_LABEL VST_EST_UNEX_MKT_VAL_AVAIL_DSP VST_EST_UNEX_MKT_VAL_DSP UNVST_SHRS_SEQ UNVST_SHRS_LABEL UNVST_SHRS_AVAIL_DSP UNVST_SHRS_DSPLAY UNVST_SHRS_IN_CHART1_FLAG UNVST_SHRS_IN_CHART2_FLAG UNVST_EST_VAL_SEQ UNVST_EST_VAL_LABEL UNVST_EST_VAL_AVAIL_DSP UNVST_EST_VAL_DSPLAY UNVST_EST_MKT_VAL_SEQ UNVST_EST_MKT_VAL_LABEL UNVST_EST_MKT_VAL_AVAIL_DSP UNVST_EST_MKT_VAL_DSP EXPIRE_DATE_SEQ EXPIRE_DATE_LABEL EXPIRE_DATE_AVAIL_DSP EXPIRE_DATE_DSPLAY EST_VALUE_IN_CHART1_FLAG EST_VALUE_IN_CHART2_FLAG EST_MKT_VAL_IN_CHART1_FLAG EST_MKT_VAL_IN_CHART2_FLAG VST_EST_VAL_IN_CHART1_FLAG VST_EST_VAL_IN_CHART2_FLAG VST_EST_MKT_VAL_N_CHART1_FLAG VST_EST_MKT_VAL_N_CHART2_FLAG VST_EST_UNEX_VAL_N_CHART1_FLAG VST_EST_UNEX_VAL_N_CHART2_FLAG VST_EST_UNX_MKT_VAL_N_CHT1_FLG VST_EST_UNX_MKT_VAL_N_CHT2_FLG UNVST_EST_VAL_IN_CHART1_FLAG UNVST_EST_VAL_IN_CHART2_FLAG UNVST_EST_MKT_VAL_IN_CHT1_FLAG UNVST_EST_MKT_VAL_IN_CHT2_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LANGUAGE BUSINESS_GROUP_ID VEST_DATE_LABEL EXERCISE_DATE_LABEL CANCEL_DATE_LABEL MISC1_LABEL MISC2_LABEL MISC3_LABEL MISC4_LABEL MISC5_LABEL MISC_NUM1_LABEL MISC_NUM2_LABEL MISC_NUM3_LABEL MISC_NUM4_LABEL MISC_NUM5_LABEL VEST_DATE_SEQ VEST_DATE_AVAIL_DSP VEST_DATE_DSPLAY EXERCISE_DATE_SEQ EXERCISE_DATE_AVAIL_DSP EXERCISE_DATE_DSPLAY CANCEL_DATE_SEQ CANCEL_DATE_AVAIL_DSP CANCEL_DATE_DSPLAY MISC1_SEQ MISC1_AVAIL_DSP MISC1_DSPLAY MISC2_SEQ MISC2_AVAIL_DSP MISC2_DSPLAY MISC3_SEQ MISC3_AVAIL_DSP MISC3_DSPLAY MISC4_SEQ MISC4_AVAIL_DSP MISC4_DSPLAY MISC5_SEQ MISC5_AVAIL_DSP MISC5_DSPLAY MISC_NUM1_SEQ MISC_NUM1_AVAIL_DSP MISC_NUM1_DSPLAY MISC_NUM2_SEQ MISC_NUM2_AVAIL_DSP MISC_NUM2_DSPLAY MISC_NUM3_SEQ MISC_NUM3_AVAIL_DSP MISC_NUM3_DSPLAY MISC_NUM4_SEQ MISC_NUM4_AVAIL_DSP MISC_NUM4_DSPLAY MISC_NUM5_SEQ MISC_NUM5_AVAIL_DSP MISC_NUM5_DSPLAY GRANT_DATE_DSPLAY_IN_PDF STOCK_SYMBOL_DSPLAY_IN_PDF GRANT_NUMBER_DSPLAY_IN_PDF GRANT_NAME_DSPLAY_IN_PDF GRANT_TYPE_DSPLAY_IN_PDF TOTAL_SHRS_DSPLAY_IN_PDF SHRS_GRANTED_DSPLAY_IN_PDF XRCISE_PRICE_DSPLAY_IN_PDF GRANT_PRICE_DSPLAY_IN_PDF GRANT_VALUE_DSPLAY_IN_PDF CANCELLED_SHRS_DSPLAY_IN_PDF CANCEL_DATE_DSPLAY_IN_PDF REASON_CODE_DSPLAY_IN_PDF CLASS_TYPE_DSPLAY_IN_PDF MISC_DSPLAY_IN_PDF EST_VALUE_DSPLAY_IN_PDF EST_MKT_VAL_DSPLAY_IN_PDF MISC1_DSPLAY_IN_PDF MISC2_DSPLAY_IN_PDF MISC3_DSPLAY_IN_PDF MISC4_DSPLAY_IN_PDF MISC5_DSPLAY_IN_PDF VST_SHRS_DSPLAY_IN_PDF VEST_DATE_DSPLAY_IN_PDF VST_EX_DSPLAY_IN_PDF EXERCISE_DATE_DSPLAY_IN_PDF VST_UNEX_DSPLAY_IN_PDF VST_EST_VAL_DSPLAY_IN_PDF VST_EST_MKT_VAL_DSP_IN_PDF VST_EST_UNEX_VAL_DSP_IN_PDF VST_EST_UNEX_MKT_VAL_DSP_PDF UNVST_SHRS_DSPLAY_IN_PDF UNVST_EST_VAL_DSPLAY_IN_PDF UNVST_EST_MKT_VAL_DSP_IN_PDF EXPIRE_DATE_DSPLAY_IN_PDF MISC_NUM1_DSPLAY_IN_PDF MISC_NUM2_DSPLAY_IN_PDF MISC_NUM3_DSPLAY_IN_PDF MISC_NUM4_DSPLAY_IN_PDF MISC_NUM5_DSPLAY_IN_PDF

Query

SQL_Statement

SELECT STK.STOCK_HISTORY_ID, STK.STMT_PAGE_DEF_ID, STK.PERD_RUN_ID, STK.CAT_ID, STK.GRANT_DATE_SEQ, STK_TL.GRANT_DATE_LABEL, STK.GRANT_DATE_AVAIL_DSP, STK.GRANT_DATE_DSPLAY, STK.STOCK_SYMBOL_SEQ, STK_TL.STOCK_SYMBOL_LABEL, STK.STOCK_SYMBOL_AVAIL_DSP, STK.STOCK_SYMBOL_DSPLAY, STK.GRANT_NUMBER_SEQ, STK_TL.GRANT_NUMBER_LABEL, STK.GRANT_NUMBER_AVAIL_DSP, STK.GRANT_NUMBER_DSPLAY, STK.GRANT_NAME_SEQ, STK_TL.GRANT_NAME_LABEL, STK.GRANT_NAME_AVAIL_DSP, STK.GRANT_NAME_DSPLAY, STK.GRANT_TYPE_SEQ, STK_TL.GRANT_TYPE_LABEL, STK.GRANT_TYPE_AVAIL_DSP, STK.GRANT_TYPE_DSPLAY, STK.TOTAL_SHRS_SEQ, STK_TL.TOTAL_SHRS_LABEL, STK.TOTAL_SHRS_AVAIL_DSP, STK.TOTAL_SHRS_DSPLAY, STK.TOTAL_SHRS_IN_CHART1_FLAG, STK.TOTAL_SHRS_IN_CHART2_FLAG, STK.SHRS_GRANTED_SEQ, STK_TL.SHRS_GRANTED_LABEL, STK.SHRS_GRANTED_AVAIL_DSP, STK.SHRS_GRANTED_DSPLAY, STK.SHRS_GRNTD_IN_CHART1_FLAG, STK.SHRS_GRNTD_IN_CHART2_FLAG, STK.XRCISE_PRICE_SEQ, STK_TL.XRCISE_PRICE_LABEL, STK.XRCISE_PRICE_AVAIL_DSP, STK.XRCISE_PRICE_DSPLAY, STK.GRANT_PRICE_SEQ, STK_TL.GRANT_PRICE_LABEL, STK.GRANT_PRICE_AVAIL_DSP, STK.GRANT_PRICE_DSPLAY, STK.GRANT_VALUE_SEQ, STK_TL.GRANT_VALUE_LABEL, STK.GRANT_VALUE_AVAIL_DSP, STK.GRANT_VALUE_DSPLAY, STK.CANCELLED_SHRS_SEQ, STK_TL.CANCELLED_SHRS_LABEL, STK.CANCELLED_SHRS_AVAIL_DSP, STK.CANCELLED_SHRS_DSPLAY, STK.REASON_CODE_SEQ, STK_TL.REASON_CODE_LABEL, STK.REASON_CODE_AVAIL_DSP, STK.REASON_CODE_DSPLAY, STK.CLASS_TYPE_SEQ, STK_TL.CLASS_TYPE_LABEL, STK.CLASS_TYPE_AVAIL_DSP, STK.CLASS_TYPE_DSPLAY, STK.MISC_SEQ, STK_TL.MISC_LABEL, STK.MISC_AVAIL_DSP, STK.MISC_DSPLAY, STK.EST_VALUE_SEQ, STK_TL.EST_VALUE_LABEL, STK.EST_VALUE_AVAIL_DSP, STK.EST_VALUE_DSPLAY, STK.EST_MKT_VAL_SEQ, STK_TL.EST_MKT_VAL_LABEL, STK.EST_MKT_VAL_AVAIL_DSP, STK.EST_MKT_VAL_DSPLAY, STK.VST_SHRS_SEQ, STK_TL.VST_SHRS_LABEL, STK.VST_SHRS_AVAIL_DSP, STK.VST_SHRS_DSPLAY, STK.VST_SHRS_IN_CHART1_FLAG, STK.VST_SHRS_IN_CHART2_FLAG, STK.VST_EX_SEQ, STK_TL.VST_EX_LABEL, STK.VST_EX_AVAIL_DSP, STK.VST_EX_DSPLAY, STK.VST_EX_IN_CHART1_FLAG, STK.VST_EX_IN_CHART2_FLAG, STK.VST_UNEX_SEQ, STK_TL.VST_UNEX_LABEL, STK.VST_UNEX_AVAIL_DSP, STK.VST_UNEX_DSPLAY, STK.VST_UNEX_IN_CHART1_FLAG, STK.VST_UNEX_IN_CHART2_FLAG, STK.VST_EST_VAL_SEQ, STK_TL.VST_EST_VAL_LABEL, STK.VST_EST_VAL_AVAIL_DSP, STK.VST_EST_VAL_DSPLAY, STK.VST_EST_MKT_VAL_SEQ, STK_TL.VST_EST_MKT_VAL_LABEL, STK.VST_EST_MKT_VAL_AVAIL_DSP, STK.VST_EST_MKT_VAL_DSP, STK.VST_EST_UNEX_VAL_SEQ, STK_TL.VST_EST_UNEX_VAL_LABEL, STK.VST_EST_UNEX_VAL_AVAIL_DSP, STK.VST_EST_UNEX_VAL_DSP, STK.VST_EST_UNEX_MKT_VAL_SEQ, STK_TL.VST_EST_UNEX_MKT_VAL_LABEL, STK.VST_EST_UNEX_MKT_VAL_AVAIL_DSP, STK.VST_EST_UNEX_MKT_VAL_DSP, STK.UNVST_SHRS_SEQ, STK_TL.UNVST_SHRS_LABEL, STK.UNVST_SHRS_AVAIL_DSP, STK.UNVST_SHRS_DSPLAY, STK.UNVST_SHRS_IN_CHART1_FLAG, STK.UNVST_SHRS_IN_CHART2_FLAG, STK.UNVST_EST_VAL_SEQ, STK_TL.UNVST_EST_VAL_LABEL, STK.UNVST_EST_VAL_AVAIL_DSP, STK.UNVST_EST_VAL_DSPLAY, STK.UNVST_EST_MKT_VAL_SEQ, STK_TL.UNVST_EST_MKT_VAL_LABEL, STK.UNVST_EST_MKT_VAL_AVAIL_DSP, STK.UNVST_EST_MKT_VAL_DSP, STK.EXPIRE_DATE_SEQ, STK_TL.EXPIRE_DATE_LABEL, STK.EXPIRE_DATE_AVAIL_DSP, STK.EXPIRE_DATE_DSPLAY, STK.EST_VALUE_IN_CHART1_FLAG, STK.EST_VALUE_IN_CHART2_FLAG, STK.EST_MKT_VAL_IN_CHART1_FLAG, STK.EST_MKT_VAL_IN_CHART2_FLAG, STK.VST_EST_VAL_IN_CHART1_FLAG, STK.VST_EST_VAL_IN_CHART2_FLAG, STK.VST_EST_MKT_VAL_N_CHART1_FLAG, STK.VST_EST_MKT_VAL_N_CHART2_FLAG, STK.VST_EST_UNEX_VAL_N_CHART1_FLAG, STK.VST_EST_UNEX_VAL_N_CHART2_FLAG, STK.VST_EST_UNX_MKT_VAL_N_CHT1_FLG, STK.VST_EST_UNX_MKT_VAL_N_CHT2_FLG, STK.UNVST_EST_VAL_IN_CHART1_FLAG, STK.UNVST_EST_VAL_IN_CHART2_FLAG, STK.UNVST_EST_MKT_VAL_IN_CHT1_FLAG, STK.UNVST_EST_MKT_VAL_IN_CHT2_FLAG, STK.CREATED_BY, STK.CREATION_DATE, STK.LAST_UPDATED_BY, STK.LAST_UPDATE_DATE, STK.LAST_UPDATE_LOGIN, STK_TL.LANGUAGE, STK.BUSINESS_GROUP_ID, STK_TL.VEST_DATE_LABEL , STK_TL.EXERCISE_DATE_LABEL , STK_TL.CANCEL_DATE_LABEL , STK_TL.MISC1_LABEL , STK_TL.MISC2_LABEL , STK_TL.MISC3_LABEL , STK_TL.MISC4_LABEL , STK_TL.MISC5_LABEL, STK_TL.MISC_NUM1_LABEL , STK_TL.MISC_NUM2_LABEL , STK_TL.MISC_NUM3_LABEL , STK_TL.MISC_NUM4_LABEL , STK_TL.MISC_NUM5_LABEL , STK.VEST_DATE_SEQ, STK.VEST_DATE_AVAIL_DSP , STK.VEST_DATE_DSPLAY , STK.EXERCISE_DATE_SEQ , STK.EXERCISE_DATE_AVAIL_DSP , STK.EXERCISE_DATE_DSPLAY , STK.CANCEL_DATE_SEQ , STK.CANCEL_DATE_AVAIL_DSP , STK.CANCEL_DATE_DSPLAY , STK.MISC1_SEQ , STK.MISC1_AVAIL_DSP , STK.MISC1_DSPLAY , STK.MISC2_SEQ , STK.MISC2_AVAIL_DSP , STK.MISC2_DSPLAY , STK.MISC3_SEQ , STK.MISC3_AVAIL_DSP, STK.MISC3_DSPLAY , STK.MISC4_SEQ , STK.MISC4_AVAIL_DSP , STK.MISC4_DSPLAY , STK.MISC5_SEQ , STK.MISC5_AVAIL_DSP , STK.MISC5_DSPLAY , STK.MISC_NUM1_SEQ , STK.MISC_NUM1_AVAIL_DSP , STK.MISC_NUM1_DSPLAY , STK.MISC_NUM2_SEQ , STK.MISC_NUM2_AVAIL_DSP , STK.MISC_NUM2_DSPLAY , STK.MISC_NUM3_SEQ , STK.MISC_NUM3_AVAIL_DSP , STK.MISC_NUM3_DSPLAY , STK.MISC_NUM4_SEQ , STK.MISC_NUM4_AVAIL_DSP , STK.MISC_NUM4_DSPLAY , STK.MISC_NUM5_SEQ , STK.MISC_NUM5_AVAIL_DSP , STK.MISC_NUM5_DSPLAY, STK.GRANT_DATE_DSPLAY_IN_PDF, STK.STOCK_SYMBOL_DSPLAY_IN_PDF, STK.GRANT_NUMBER_DSPLAY_IN_PDF, STK.GRANT_NAME_DSPLAY_IN_PDF, STK.GRANT_TYPE_DSPLAY_IN_PDF, STK.TOTAL_SHRS_DSPLAY_IN_PDF, STK.SHRS_GRANTED_DSPLAY_IN_PDF, STK.XRCISE_PRICE_DSPLAY_IN_PDF, STK.GRANT_PRICE_DSPLAY_IN_PDF, STK.GRANT_VALUE_DSPLAY_IN_PDF, STK.CANCELLED_SHRS_DSPLAY_IN_PDF, STK.CANCEL_DATE_DSPLAY_IN_PDF, STK.REASON_CODE_DSPLAY_IN_PDF, STK.CLASS_TYPE_DSPLAY_IN_PDF, STK.MISC_DSPLAY_IN_PDF, STK.EST_VALUE_DSPLAY_IN_PDF, STK.EST_MKT_VAL_DSPLAY_IN_PDF, STK.MISC1_DSPLAY_IN_PDF, STK.MISC2_DSPLAY_IN_PDF, STK.MISC3_DSPLAY_IN_PDF, STK.MISC4_DSPLAY_IN_PDF, STK.MISC5_DSPLAY_IN_PDF, STK.VST_SHRS_DSPLAY_IN_PDF, STK.VEST_DATE_DSPLAY_IN_PDF, STK.VST_EX_DSPLAY_IN_PDF, STK.EXERCISE_DATE_DSPLAY_IN_PDF, STK.VST_UNEX_DSPLAY_IN_PDF, STK.VST_EST_VAL_DSPLAY_IN_PDF, STK.VST_EST_MKT_VAL_DSP_IN_PDF, STK.VST_EST_UNEX_VAL_DSP_IN_PDF, STK.VST_EST_UNEX_MKT_VAL_DSP_PDF, STK.UNVST_SHRS_DSPLAY_IN_PDF, STK.UNVST_EST_VAL_DSPLAY_IN_PDF, STK.UNVST_EST_MKT_VAL_DSP_IN_PDF, STK.EXPIRE_DATE_DSPLAY_IN_PDF, STK.MISC_NUM1_DSPLAY_IN_PDF, STK.MISC_NUM2_DSPLAY_IN_PDF, STK.MISC_NUM3_DSPLAY_IN_PDF, STK.MISC_NUM4_DSPLAY_IN_PDF, STK.MISC_NUM5_DSPLAY_IN_PDF FROM CMP_TCS_STOCK_HISTORY STK, CMP_TCS_STOCK_HISTORY_TL STK_TL WHERE STK.STOCK_HISTORY_ID = STK_TL.STOCK_HISTORY_ID AND STK_TL.BUSINESS_GROUP_ID = STK.BUSINESS_GROUP_ID