VIEW: DDR.DDR_I_RTL_INV_ITEM#

Source

View Text - Preformatted

select REC_ID REC_ID, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD, TRANS_DT TRANS_DT, GLBL_ITEM_ID GLBL_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, INV_LOC_CD INV_LOC_CD, UOM UOM, ON_HAND_QTY ON_HAND_QTY, RECVD_QTY RECVD_QTY, IN_TRANSIT_QTY IN_TRANSIT_QTY, BCK_ORDR_QTY BCK_ORDR_QTY, QLTY_HOLD_QTY QLTY_HOLD_QTY, ON_HAND_NET_COST_AMT ON_HAND_NET_COST_AMT, RECVD_NET_COST_AMT RECVD_NET_COST_AMT, IN_TRANSIT_NET_COST_AMT IN_TRANSIT_NET_COST_AMT, BCKORDR_NET_COST_AMT BCKORDR_NET_COST_AMT, QLTY_HOLD_NET_COST_AMT QLTY_HOLD_NET_COST_AMT, ON_HAND_RTL_AMT ON_HAND_RTL_AMT, RECVD_RTL_AMT RECVD_RTL_AMT, IN_TRANSIT_RTL_AMT IN_TRANSIT_RTL_AMT, BCKORDR_RTL_AMT BCKORDR_RTL_AMT, QLTY_HOLD_RTL_AMT QLTY_HOLD_RTL_AMT, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, RTL_ORG_CD RTL_ORG_CD from "DDR"."DDR_I_RTL_INV_ITEM"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD
, TRANS_DT TRANS_DT
, GLBL_ITEM_ID GLBL_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, INV_LOC_CD INV_LOC_CD
, UOM UOM
, ON_HAND_QTY ON_HAND_QTY
, RECVD_QTY RECVD_QTY
, IN_TRANSIT_QTY IN_TRANSIT_QTY
, BCK_ORDR_QTY BCK_ORDR_QTY
, QLTY_HOLD_QTY QLTY_HOLD_QTY
, ON_HAND_NET_COST_AMT ON_HAND_NET_COST_AMT
, RECVD_NET_COST_AMT RECVD_NET_COST_AMT
, IN_TRANSIT_NET_COST_AMT IN_TRANSIT_NET_COST_AMT
, BCKORDR_NET_COST_AMT BCKORDR_NET_COST_AMT
, QLTY_HOLD_NET_COST_AMT QLTY_HOLD_NET_COST_AMT
, ON_HAND_RTL_AMT ON_HAND_RTL_AMT
, RECVD_RTL_AMT RECVD_RTL_AMT
, IN_TRANSIT_RTL_AMT IN_TRANSIT_RTL_AMT
, BCKORDR_RTL_AMT BCKORDR_RTL_AMT
, QLTY_HOLD_RTL_AMT QLTY_HOLD_RTL_AMT
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, RTL_ORG_CD RTL_ORG_CD
FROM "DDR"."DDR_I_RTL_INV_ITEM"