VIEW: DDR.DDR_R_RTL_SKU_BU_INV_RL#

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, BSNS_UNIT_CD BSNS_UNIT_CD, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, GLBL_ITEM_ID GLBL_ITEM_ID, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, REORDR_INTRVL REORDR_INTRVL, REORDR_THRSHLD REORDR_THRSHLD, REORDR_QTY REORDR_QTY, REORDR_QTY_PRMRY REORDR_QTY_PRMRY, REORDR_QTY_ALT REORDR_QTY_ALT, RPLNSHMNT_MTHD RPLNSHMNT_MTHD, LEAD_TIME_DAYS LEAD_TIME_DAYS, TRGT_DAYS_OF_SPLY TRGT_DAYS_OF_SPLY, TRGT_ON_HAND_QTY TRGT_ON_HAND_QTY, TRGT_ON_HAND_QTY_PRMRY TRGT_ON_HAND_QTY_PRMRY, TRGT_ON_HAND_QTY_ALT TRGT_ON_HAND_QTY_ALT, MAX_DAYS_SPLY MAX_DAYS_SPLY, MAX_STCK_ON_HAND_QTY MAX_STCK_ON_HAND_QTY, MAX_STCK_ON_HAND_QTY_PRMRY MAX_STCK_ON_HAND_QTY_PRMRY, MAX_STCK_ON_HAND_QTY_ALT MAX_STCK_ON_HAND_QTY_ALT, MIN_DAYS_SPLY MIN_DAYS_SPLY, MIN_STCK_ON_HAND_QTY MIN_STCK_ON_HAND_QTY, MIN_STCK_ON_HAND_QTY_PRMRY MIN_STCK_ON_HAND_QTY_PRMRY, MIN_STCK_ON_HAND_QTY_ALT MIN_STCK_ON_HAND_QTY_ALT, 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 from "DDR"."DDR_R_RTL_SKU_BU_INV_RL"

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
, BSNS_UNIT_CD BSNS_UNIT_CD
, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID GLBL_ITEM_ID
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, REORDR_INTRVL REORDR_INTRVL
, REORDR_THRSHLD REORDR_THRSHLD
, REORDR_QTY REORDR_QTY
, REORDR_QTY_PRMRY REORDR_QTY_PRMRY
, REORDR_QTY_ALT REORDR_QTY_ALT
, RPLNSHMNT_MTHD RPLNSHMNT_MTHD
, LEAD_TIME_DAYS LEAD_TIME_DAYS
, TRGT_DAYS_OF_SPLY TRGT_DAYS_OF_SPLY
, TRGT_ON_HAND_QTY TRGT_ON_HAND_QTY
, TRGT_ON_HAND_QTY_PRMRY TRGT_ON_HAND_QTY_PRMRY
, TRGT_ON_HAND_QTY_ALT TRGT_ON_HAND_QTY_ALT
, MAX_DAYS_SPLY MAX_DAYS_SPLY
, MAX_STCK_ON_HAND_QTY MAX_STCK_ON_HAND_QTY
, MAX_STCK_ON_HAND_QTY_PRMRY MAX_STCK_ON_HAND_QTY_PRMRY
, MAX_STCK_ON_HAND_QTY_ALT MAX_STCK_ON_HAND_QTY_ALT
, MIN_DAYS_SPLY MIN_DAYS_SPLY
, MIN_STCK_ON_HAND_QTY MIN_STCK_ON_HAND_QTY
, MIN_STCK_ON_HAND_QTY_PRMRY MIN_STCK_ON_HAND_QTY_PRMRY
, MIN_STCK_ON_HAND_QTY_ALT MIN_STCK_ON_HAND_QTY_ALT
, 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
FROM "DDR"."DDR_R_RTL_SKU_BU_INV_RL"