VIEW: DDR.DDR_S_RTL_ORDR_ITEM#

Source

View Text - Preformatted

select REC_ID REC_ID, MFG_ORG_CD MFG_ORG_CD, RTL_ORG_CD RTL_ORG_CD, 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, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, CRNCY_CD CRNCY_CD, ORDR_QTY ORDR_QTY, ORDR_QTY_PRMRY ORDR_QTY_PRMRY, ORDR_QTY_ALT ORDR_QTY_ALT, ORDR_AMT ORDR_AMT, ORDR_AMT_LCL ORDR_AMT_LCL, ORDR_AMT_RPT ORDR_AMT_RPT, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, TRANS_DT TRANS_DT, LOAD_ID LOAD_ID, ITM_TYP ITM_TYP, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID from "DDR"."DDR_S_RTL_ORDR_ITEM"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, MFG_ORG_CD MFG_ORG_CD
, RTL_ORG_CD RTL_ORG_CD
, 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
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, ORDR_QTY ORDR_QTY
, ORDR_QTY_PRMRY ORDR_QTY_PRMRY
, ORDR_QTY_ALT ORDR_QTY_ALT
, ORDR_AMT ORDR_AMT
, ORDR_AMT_LCL ORDR_AMT_LCL
, ORDR_AMT_RPT ORDR_AMT_RPT
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, TRANS_DT TRANS_DT
, LOAD_ID LOAD_ID
, ITM_TYP ITM_TYP
, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID
FROM "DDR"."DDR_S_RTL_ORDR_ITEM"