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.

[Home] [Help]

VIEW: MSD.MSD_DEM_SERIES#

Source

View Text - Preformatted


select SERIES_ID SERIES_ID, SERIES_NAME SERIES_NAME, SERIES_TYPE SERIES_TYPE, IDENTIFIER IDENTIFIER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STG_SERIES_COL_NAME STG_SERIES_COL_NAME, MSD_SR_ITEM_PK_COL MSD_SR_ITEM_PK_COL, GMP_SR_ITEM_PK_COL GMP_SR_ITEM_PK_COL, MSD_SOURCE_DATE_COL MSD_SOURCE_DATE_COL, GMP_SOURCE_DATE_COL GMP_SOURCE_DATE_COL, CUSTOM_VIEW_NAME CUSTOM_VIEW_NAME, GMP_CUSTOM_VIEW_NAME GMP_CUSTOM_VIEW_NAME, PS_VIEW_NAME PS_VIEW_NAME, ZD_EDITION_NAME ZD_EDITION_NAME, SOURCE_VIEW_HINT SOURCE_VIEW_HINT, SOURCE_VIEW_HINT2 SOURCE_VIEW_HINT2, EXTRA_WHERE EXTRA_WHERE from "MSD"."MSD_DEM_SERIES"

View Text - HTML Formatted

SELECT SERIES_ID SERIES_ID
, SERIES_NAME SERIES_NAME
, SERIES_TYPE SERIES_TYPE
, IDENTIFIER IDENTIFIER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STG_SERIES_COL_NAME STG_SERIES_COL_NAME
, MSD_SR_ITEM_PK_COL MSD_SR_ITEM_PK_COL
, GMP_SR_ITEM_PK_COL GMP_SR_ITEM_PK_COL
, MSD_SOURCE_DATE_COL MSD_SOURCE_DATE_COL
, GMP_SOURCE_DATE_COL GMP_SOURCE_DATE_COL
, CUSTOM_VIEW_NAME CUSTOM_VIEW_NAME
, GMP_CUSTOM_VIEW_NAME GMP_CUSTOM_VIEW_NAME
, PS_VIEW_NAME PS_VIEW_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
, SOURCE_VIEW_HINT SOURCE_VIEW_HINT
, SOURCE_VIEW_HINT2 SOURCE_VIEW_HINT2
, EXTRA_WHERE EXTRA_WHERE
FROM "MSD"."MSD_DEM_SERIES"