VIEW: DDR.DDR_B_RTL_SL_RTN_ITM_DAY#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, RTL_ORG_CD RTL_ORG_CD, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID, BSNS_UNIT_CD BSNS_UNIT_CD, DAY_CD DAY_CD, GLBL_ITEM_ID GLBL_ITEM_ID, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, CRNCY_CD CRNCY_CD, 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, SLS_COST_AMT SLS_COST_AMT, SLS_COST_AMT_LCL SLS_COST_AMT_LCL, SLS_COST_AMT_RPT SLS_COST_AMT_RPT, RTRN_QTY RTRN_QTY, RTRN_QTY_PRMRY RTRN_QTY_PRMRY, RTRN_QTY_ALT RTRN_QTY_ALT, RTRN_AMT RTRN_AMT, RTRN_AMT_LCL RTRN_AMT_LCL, RTRN_AMT_RPT RTRN_AMT_RPT, RTRN_COST_AMT RTRN_COST_AMT, RTRN_COST_AMT_LCL RTRN_COST_AMT_LCL, RTRN_COST_AMT_RPT RTRN_COST_AMT_RPT, PRMTN_FLAG PRMTN_FLAG, 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, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID, ITM_TYP ITM_TYP, MFG_PRMTN_ID MFG_PRMTN_ID, SLS_TYP_CD SLS_TYP_CD from "DDR"."DDR_B_RTL_SL_RTN_ITM_DAY"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, RTL_ORG_CD RTL_ORG_CD
, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID
, BSNS_UNIT_CD BSNS_UNIT_CD
, DAY_CD DAY_CD
, GLBL_ITEM_ID GLBL_ITEM_ID
, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, 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
, SLS_COST_AMT SLS_COST_AMT
, SLS_COST_AMT_LCL SLS_COST_AMT_LCL
, SLS_COST_AMT_RPT SLS_COST_AMT_RPT
, RTRN_QTY RTRN_QTY
, RTRN_QTY_PRMRY RTRN_QTY_PRMRY
, RTRN_QTY_ALT RTRN_QTY_ALT
, RTRN_AMT RTRN_AMT
, RTRN_AMT_LCL RTRN_AMT_LCL
, RTRN_AMT_RPT RTRN_AMT_RPT
, RTRN_COST_AMT RTRN_COST_AMT
, RTRN_COST_AMT_LCL RTRN_COST_AMT_LCL
, RTRN_COST_AMT_RPT RTRN_COST_AMT_RPT
, PRMTN_FLAG PRMTN_FLAG
, 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
, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID
, ITM_TYP ITM_TYP
, MFG_PRMTN_ID MFG_PRMTN_ID
, SLS_TYP_CD SLS_TYP_CD
FROM "DDR"."DDR_B_RTL_SL_RTN_ITM_DAY"