VIEW: DDR.DDR_B_MKT_ITEM_SLS_DAY#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, RTL_ORG_CD RTL_ORG_CD, GLBL_ITEM_ID GLBL_ITEM_ID, MKT_AREA_ID MKT_AREA_ID, MKT_AREA_CD MKT_AREA_CD, DAY_CD DAY_CD, BSNS_UNIT_CD BSNS_UNIT_CD, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, MKT_ITEM_ID MKT_ITEM_ID, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, CRNCY_CD CRNCY_CD, REC_CURR_DT REC_CURR_DT, AVG_MMACV_SLS_RATE AVG_MMACV_SLS_RATE, AVG_STORE_SELL_ITEM_QTY AVG_STORE_SELL_ITEM_QTY, AVG_STORE_SELL_ITEM_QTY_PRMRY AVG_STORE_SELL_ITEM_QTY_PRMRY, AVG_STORE_SELL_ITEM_QTY_ALT AVG_STORE_SELL_ITEM_QTY_ALT, AVG_ACV_WGT_DSTRBTN_PCT AVG_ACV_WGT_DSTRBTN_PCT, AVG_WGT_PRICE_RDCTN_PCT AVG_WGT_PRICE_RDCTN_PCT, SLS_QTY SLS_QTY, SLS_QTY_PRMRY SLS_QTY_PRMRY, SLS_QTY_ALT SLS_QTY_ALT, SLS_AMT SLS_AMT, SLS_AMT_LCL SLS_AMT_LCL, SLS_AMT_RPT SLS_AMT_RPT, NRML_QTY NRML_QTY, NRML_QTY_PRMRY NRML_QTY_PRMRY, NRML_QTY_ALT NRML_QTY_ALT, NRML_AMT NRML_AMT, NRML_AMT_LCL NRML_AMT_LCL, NRML_AMT_RPT NRML_AMT_RPT, SLS_PRICE_CUT_QTY SLS_PRICE_CUT_QTY, SLS_PRICE_CUT_QTY_PRMRY SLS_PRICE_CUT_QTY_PRMRY, SLS_PRICE_CUT_QTY_ALT SLS_PRICE_CUT_QTY_ALT, SLS_PRICE_CUT_AMT SLS_PRICE_CUT_AMT, SLS_PRICE_CUT_AMT_LCL SLS_PRICE_CUT_AMT_LCL, SLS_PRICE_CUT_AMT_RPT SLS_PRICE_CUT_AMT_RPT, MAIN_AD_QTY MAIN_AD_QTY, MAIN_AD_QTY_PRMRY MAIN_AD_QTY_PRMRY, MAIN_AD_QTY_ALT MAIN_AD_QTY_ALT, MAIN_AD_AMT MAIN_AD_AMT, MAIN_AD_AMT_LCL MAIN_AD_AMT_LCL, MAIN_AD_AMT_RPT MAIN_AD_AMT_RPT, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, CRTD_BY_DSR CRTD_BY_DSR, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR, 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 from "DDR"."DDR_B_MKT_ITEM_SLS_DAY"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, RTL_ORG_CD RTL_ORG_CD
, GLBL_ITEM_ID GLBL_ITEM_ID
, MKT_AREA_ID MKT_AREA_ID
, MKT_AREA_CD MKT_AREA_CD
, DAY_CD DAY_CD
, BSNS_UNIT_CD BSNS_UNIT_CD
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, MKT_ITEM_ID MKT_ITEM_ID
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, REC_CURR_DT REC_CURR_DT
, AVG_MMACV_SLS_RATE AVG_MMACV_SLS_RATE
, AVG_STORE_SELL_ITEM_QTY AVG_STORE_SELL_ITEM_QTY
, AVG_STORE_SELL_ITEM_QTY_PRMRY AVG_STORE_SELL_ITEM_QTY_PRMRY
, AVG_STORE_SELL_ITEM_QTY_ALT AVG_STORE_SELL_ITEM_QTY_ALT
, AVG_ACV_WGT_DSTRBTN_PCT AVG_ACV_WGT_DSTRBTN_PCT
, AVG_WGT_PRICE_RDCTN_PCT AVG_WGT_PRICE_RDCTN_PCT
, SLS_QTY SLS_QTY
, SLS_QTY_PRMRY SLS_QTY_PRMRY
, SLS_QTY_ALT SLS_QTY_ALT
, SLS_AMT SLS_AMT
, SLS_AMT_LCL SLS_AMT_LCL
, SLS_AMT_RPT SLS_AMT_RPT
, NRML_QTY NRML_QTY
, NRML_QTY_PRMRY NRML_QTY_PRMRY
, NRML_QTY_ALT NRML_QTY_ALT
, NRML_AMT NRML_AMT
, NRML_AMT_LCL NRML_AMT_LCL
, NRML_AMT_RPT NRML_AMT_RPT
, SLS_PRICE_CUT_QTY SLS_PRICE_CUT_QTY
, SLS_PRICE_CUT_QTY_PRMRY SLS_PRICE_CUT_QTY_PRMRY
, SLS_PRICE_CUT_QTY_ALT SLS_PRICE_CUT_QTY_ALT
, SLS_PRICE_CUT_AMT SLS_PRICE_CUT_AMT
, SLS_PRICE_CUT_AMT_LCL SLS_PRICE_CUT_AMT_LCL
, SLS_PRICE_CUT_AMT_RPT SLS_PRICE_CUT_AMT_RPT
, MAIN_AD_QTY MAIN_AD_QTY
, MAIN_AD_QTY_PRMRY MAIN_AD_QTY_PRMRY
, MAIN_AD_QTY_ALT MAIN_AD_QTY_ALT
, MAIN_AD_AMT MAIN_AD_AMT
, MAIN_AD_AMT_LCL MAIN_AD_AMT_LCL
, MAIN_AD_AMT_RPT MAIN_AD_AMT_RPT
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, CRTD_BY_DSR CRTD_BY_DSR
, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR
, 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
FROM "DDR"."DDR_B_MKT_ITEM_SLS_DAY"