VIEW: DDR.DDR_S_SLS_FRCST_ITEM#

Source

View Text - Preformatted

select REC_ID REC_ID, TRANS_DT TRANS_DT, MFG_ORG_CD MFG_ORG_CD, RTL_ORG_CD RTL_ORG_CD, FRCST_NBR FRCST_NBR, FRCST_TYP FRCST_TYP, FRCST_VRSN FRCST_VRSN, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID, RTL_BSNS_UNIT_CD RTL_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, FRCST_SLS_UOM_CD FRCST_SLS_UOM_CD, FRCST_SLS_UOM_CD_PRMRY FRCST_SLS_UOM_CD_PRMRY, FRCST_SLS_UOM_CD_ALT FRCST_SLS_UOM_CD_ALT, CRNCY_CD CRNCY_CD, FRCST_SLS_QTY FRCST_SLS_QTY, FRCST_SLS_QTY_PRMRY FRCST_SLS_QTY_PRMRY, FRCST_SLS_QTY_ALT FRCST_SLS_QTY_ALT, FRCST_SLS_AMT FRCST_SLS_AMT, FRCST_SLS_AMT_LCL FRCST_SLS_AMT_LCL, FRCST_SLS_AMT_RPT FRCST_SLS_AMT_RPT, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, LOAD_ID LOAD_ID, ITM_TYP ITM_TYP, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID, FRCST_PURP FRCST_PURP, BSNS_UNIT_CD BSNS_UNIT_CD from "DDR"."DDR_S_SLS_FRCST_ITEM"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, TRANS_DT TRANS_DT
, MFG_ORG_CD MFG_ORG_CD
, RTL_ORG_CD RTL_ORG_CD
, FRCST_NBR FRCST_NBR
, FRCST_TYP FRCST_TYP
, FRCST_VRSN FRCST_VRSN
, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID
, RTL_BSNS_UNIT_CD RTL_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
, FRCST_SLS_UOM_CD FRCST_SLS_UOM_CD
, FRCST_SLS_UOM_CD_PRMRY FRCST_SLS_UOM_CD_PRMRY
, FRCST_SLS_UOM_CD_ALT FRCST_SLS_UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, FRCST_SLS_QTY FRCST_SLS_QTY
, FRCST_SLS_QTY_PRMRY FRCST_SLS_QTY_PRMRY
, FRCST_SLS_QTY_ALT FRCST_SLS_QTY_ALT
, FRCST_SLS_AMT FRCST_SLS_AMT
, FRCST_SLS_AMT_LCL FRCST_SLS_AMT_LCL
, FRCST_SLS_AMT_RPT FRCST_SLS_AMT_RPT
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, LOAD_ID LOAD_ID
, ITM_TYP ITM_TYP
, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID
, FRCST_PURP FRCST_PURP
, BSNS_UNIT_CD BSNS_UNIT_CD
FROM "DDR"."DDR_S_SLS_FRCST_ITEM"