VIEW: DDR.DDR_I_RTL_SL_RTN_ITEM#

Source

View Text - Preformatted

select REC_ID REC_ID, LOC_IDNT_CD LOC_IDNT_CD, GLBL_ITEM_ID GLBL_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, UOM UOM, SLS_QTY SLS_QTY, SLS_AMOUNT SLS_AMOUNT, RTRN_QTY RTRN_QTY, RTRN_AMOUNT RTRN_AMOUNT, SLS_COST_AMOUNT SLS_COST_AMOUNT, RTRN_COST_AMOUNT RTRN_COST_AMOUNT, TRANS_DT TRANS_DT, PRMTN_FLAG PRMTN_FLAG, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, PERIOD_TYP_FLAG PERIOD_TYP_FLAG, LOC_IDNT_FLAG LOC_IDNT_FLAG, ORG_LVL_CD ORG_LVL_CD, RTL_ORG_CD RTL_ORG_CD, SLS_AMT SLS_AMT, RTRN_AMT RTRN_AMT, SLS_COST_AMT SLS_COST_AMT, RTRN_COST_AMT RTRN_COST_AMT, ALLOC_PARENT_IDNT ALLOC_PARENT_IDNT from "DDR"."DDR_I_RTL_SL_RTN_ITEM"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, LOC_IDNT_CD LOC_IDNT_CD
, GLBL_ITEM_ID GLBL_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, UOM UOM
, SLS_QTY SLS_QTY
, SLS_AMOUNT SLS_AMOUNT
, RTRN_QTY RTRN_QTY
, RTRN_AMOUNT RTRN_AMOUNT
, SLS_COST_AMOUNT SLS_COST_AMOUNT
, RTRN_COST_AMOUNT RTRN_COST_AMOUNT
, TRANS_DT TRANS_DT
, PRMTN_FLAG PRMTN_FLAG
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, PERIOD_TYP_FLAG PERIOD_TYP_FLAG
, LOC_IDNT_FLAG LOC_IDNT_FLAG
, ORG_LVL_CD ORG_LVL_CD
, RTL_ORG_CD RTL_ORG_CD
, SLS_AMT SLS_AMT
, RTRN_AMT RTRN_AMT
, SLS_COST_AMT SLS_COST_AMT
, RTRN_COST_AMT RTRN_COST_AMT
, ALLOC_PARENT_IDNT ALLOC_PARENT_IDNT
FROM "DDR"."DDR_I_RTL_SL_RTN_ITEM"