eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: DDR.DDR_E_RTL_SKU_BU_INV_RL#

Source

View Text - Preformatted


select REC_ID REC_ID, RTL_ORG_CD RTL_ORG_CD, BSNS_UNIT_CD BSNS_UNIT_CD, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, REORDR_INTRVL REORDR_INTRVL, REORDR_THRSHLD REORDR_THRSHLD, REORDR_QTY REORDR_QTY, 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, MAX_DAYS_SPLY MAX_DAYS_SPLY, MAX_STCK_ON_HAND_QTY MAX_STCK_ON_HAND_QTY, MIN_DAYS_SPLY MIN_DAYS_SPLY, MIN_STCK_ON_HAND_QTY MIN_STCK_ON_HAND_QTY, PROCESS_ACTION PROCESS_ACTION, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID from "DDR"."DDR_E_RTL_SKU_BU_INV_RL"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, RTL_ORG_CD RTL_ORG_CD
, BSNS_UNIT_CD BSNS_UNIT_CD
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, REORDR_INTRVL REORDR_INTRVL
, REORDR_THRSHLD REORDR_THRSHLD
, REORDR_QTY REORDR_QTY
, 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
, MAX_DAYS_SPLY MAX_DAYS_SPLY
, MAX_STCK_ON_HAND_QTY MAX_STCK_ON_HAND_QTY
, MIN_DAYS_SPLY MIN_DAYS_SPLY
, MIN_STCK_ON_HAND_QTY MIN_STCK_ON_HAND_QTY
, PROCESS_ACTION PROCESS_ACTION
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
FROM "DDR"."DDR_E_RTL_SKU_BU_INV_RL"