VIEW: DDR.DDR_B_RTL_INV_ITEM_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, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD, GLBL_ITEM_ID GLBL_ITEM_ID, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, DAY_CD DAY_CD, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, INV_LOC_TYP_CD INV_LOC_TYP_CD, INV_LOC_ID INV_LOC_ID, INV_LOC_CD INV_LOC_CD, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, CRNCY_CD CRNCY_CD, ON_HAND_QTY ON_HAND_QTY, ON_HAND_QTY_PRMRY ON_HAND_QTY_PRMRY, ON_HAND_QTY_ALT ON_HAND_QTY_ALT, RECVD_QTY RECVD_QTY, RECVD_QTY_PRMRY RECVD_QTY_PRMRY, RECVD_QTY_ALT RECVD_QTY_ALT, IN_TRANSIT_QTY IN_TRANSIT_QTY, IN_TRANSIT_QTY_PRMRY IN_TRANSIT_QTY_PRMRY, IN_TRANSIT_QTY_ALT IN_TRANSIT_QTY_ALT, BCK_ORDR_QTY BCK_ORDR_QTY, BCK_ORDR_QTY_PRMRY BCK_ORDR_QTY_PRMRY, BCK_ORDR_QTY_ALT BCK_ORDR_QTY_ALT, QLTY_HOLD_QTY QLTY_HOLD_QTY, QLTY_HOLD_QTY_PRMRY QLTY_HOLD_QTY_PRMRY, QLTY_HOLD_QTY_ALT QLTY_HOLD_QTY_ALT, ON_HAND_NET_COST_AMT ON_HAND_NET_COST_AMT, ON_HAND_NET_COST_AMT_LCL ON_HAND_NET_COST_AMT_LCL, ON_HAND_NET_COST_AMT_RPT ON_HAND_NET_COST_AMT_RPT, RECVD_NET_COST_AMT RECVD_NET_COST_AMT, RECVD_NET_COST_AMT_LCL RECVD_NET_COST_AMT_LCL, RECVD_NET_COST_AMT_RPT RECVD_NET_COST_AMT_RPT, IN_TRANSIT_NET_COST_AMT IN_TRANSIT_NET_COST_AMT, IN_TRANSIT_NET_COST_AMT_LCL IN_TRANSIT_NET_COST_AMT_LCL, IN_TRANSIT_NET_COST_AMT_RPT IN_TRANSIT_NET_COST_AMT_RPT, BCKORDR_NET_COST_AMT BCKORDR_NET_COST_AMT, BCKORDR_NET_COST_AMT_LCL BCKORDR_NET_COST_AMT_LCL, BCKORDR_NET_COST_AMT_RPT BCKORDR_NET_COST_AMT_RPT, QLTY_HOLD_NET_COST_AMT QLTY_HOLD_NET_COST_AMT, QLTY_HOLD_NET_COST_AMT_LCL QLTY_HOLD_NET_COST_AMT_LCL, QLTY_HOLD_NET_COST_AMT_RPT QLTY_HOLD_NET_COST_AMT_RPT, ON_HAND_RTL_AMT ON_HAND_RTL_AMT, ON_HAND_RTL_AMT_LCL ON_HAND_RTL_AMT_LCL, ON_HAND_RTL_AMT_RPT ON_HAND_RTL_AMT_RPT, RECVD_RTL_AMT RECVD_RTL_AMT, RECVD_RTL_AMT_LCL RECVD_RTL_AMT_LCL, RECVD_RTL_AMT_RPT RECVD_RTL_AMT_RPT, IN_TRANSIT_RTL_AMT IN_TRANSIT_RTL_AMT, IN_TRANSIT_RTL_AMT_LCL IN_TRANSIT_RTL_AMT_LCL, IN_TRANSIT_RTL_AMT_RPT IN_TRANSIT_RTL_AMT_RPT, BCKORDR_RTL_AMT BCKORDR_RTL_AMT, BCKORDR_RTL_AMT_LCL BCKORDR_RTL_AMT_LCL, BCKORDR_RTL_AMT_RPT BCKORDR_RTL_AMT_RPT, QLTY_HOLD_RTL_AMT QLTY_HOLD_RTL_AMT, QLTY_HOLD_RTL_AMT_LCL QLTY_HOLD_RTL_AMT_LCL, QLTY_HOLD_RTL_AMT_RPT QLTY_HOLD_RTL_AMT_RPT, 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 from "DDR"."DDR_B_RTL_INV_ITEM_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
, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD
, GLBL_ITEM_ID GLBL_ITEM_ID
, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, DAY_CD DAY_CD
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, INV_LOC_TYP_CD INV_LOC_TYP_CD
, INV_LOC_ID INV_LOC_ID
, INV_LOC_CD INV_LOC_CD
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, ON_HAND_QTY ON_HAND_QTY
, ON_HAND_QTY_PRMRY ON_HAND_QTY_PRMRY
, ON_HAND_QTY_ALT ON_HAND_QTY_ALT
, RECVD_QTY RECVD_QTY
, RECVD_QTY_PRMRY RECVD_QTY_PRMRY
, RECVD_QTY_ALT RECVD_QTY_ALT
, IN_TRANSIT_QTY IN_TRANSIT_QTY
, IN_TRANSIT_QTY_PRMRY IN_TRANSIT_QTY_PRMRY
, IN_TRANSIT_QTY_ALT IN_TRANSIT_QTY_ALT
, BCK_ORDR_QTY BCK_ORDR_QTY
, BCK_ORDR_QTY_PRMRY BCK_ORDR_QTY_PRMRY
, BCK_ORDR_QTY_ALT BCK_ORDR_QTY_ALT
, QLTY_HOLD_QTY QLTY_HOLD_QTY
, QLTY_HOLD_QTY_PRMRY QLTY_HOLD_QTY_PRMRY
, QLTY_HOLD_QTY_ALT QLTY_HOLD_QTY_ALT
, ON_HAND_NET_COST_AMT ON_HAND_NET_COST_AMT
, ON_HAND_NET_COST_AMT_LCL ON_HAND_NET_COST_AMT_LCL
, ON_HAND_NET_COST_AMT_RPT ON_HAND_NET_COST_AMT_RPT
, RECVD_NET_COST_AMT RECVD_NET_COST_AMT
, RECVD_NET_COST_AMT_LCL RECVD_NET_COST_AMT_LCL
, RECVD_NET_COST_AMT_RPT RECVD_NET_COST_AMT_RPT
, IN_TRANSIT_NET_COST_AMT IN_TRANSIT_NET_COST_AMT
, IN_TRANSIT_NET_COST_AMT_LCL IN_TRANSIT_NET_COST_AMT_LCL
, IN_TRANSIT_NET_COST_AMT_RPT IN_TRANSIT_NET_COST_AMT_RPT
, BCKORDR_NET_COST_AMT BCKORDR_NET_COST_AMT
, BCKORDR_NET_COST_AMT_LCL BCKORDR_NET_COST_AMT_LCL
, BCKORDR_NET_COST_AMT_RPT BCKORDR_NET_COST_AMT_RPT
, QLTY_HOLD_NET_COST_AMT QLTY_HOLD_NET_COST_AMT
, QLTY_HOLD_NET_COST_AMT_LCL QLTY_HOLD_NET_COST_AMT_LCL
, QLTY_HOLD_NET_COST_AMT_RPT QLTY_HOLD_NET_COST_AMT_RPT
, ON_HAND_RTL_AMT ON_HAND_RTL_AMT
, ON_HAND_RTL_AMT_LCL ON_HAND_RTL_AMT_LCL
, ON_HAND_RTL_AMT_RPT ON_HAND_RTL_AMT_RPT
, RECVD_RTL_AMT RECVD_RTL_AMT
, RECVD_RTL_AMT_LCL RECVD_RTL_AMT_LCL
, RECVD_RTL_AMT_RPT RECVD_RTL_AMT_RPT
, IN_TRANSIT_RTL_AMT IN_TRANSIT_RTL_AMT
, IN_TRANSIT_RTL_AMT_LCL IN_TRANSIT_RTL_AMT_LCL
, IN_TRANSIT_RTL_AMT_RPT IN_TRANSIT_RTL_AMT_RPT
, BCKORDR_RTL_AMT BCKORDR_RTL_AMT
, BCKORDR_RTL_AMT_LCL BCKORDR_RTL_AMT_LCL
, BCKORDR_RTL_AMT_RPT BCKORDR_RTL_AMT_RPT
, QLTY_HOLD_RTL_AMT QLTY_HOLD_RTL_AMT
, QLTY_HOLD_RTL_AMT_LCL QLTY_HOLD_RTL_AMT_LCL
, QLTY_HOLD_RTL_AMT_RPT QLTY_HOLD_RTL_AMT_RPT
, 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
FROM "DDR"."DDR_B_RTL_INV_ITEM_DAY"