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.

[Home] [Help]

VIEW: DDR.DDR_I_RTL_ITEM_HCHY#

Source

View Text - Preformatted


select REC_ID REC_ID, RTL_CMPNY_CD RTL_CMPNY_CD, RTL_DIV_CD RTL_DIV_CD, RTL_DIV_NAME RTL_DIV_NAME, RTL_DIV_BYR_NAME RTL_DIV_BYR_NAME, RTL_DIV_MRCHNDSR_NAME RTL_DIV_MRCHNDSR_NAME, RTL_GRP_CD RTL_GRP_CD, RTL_GRP_NAME RTL_GRP_NAME, RTL_GRP_BYR_NAME RTL_GRP_BYR_NAME, RTL_GRP_MRCHNDSR_NAME RTL_GRP_MRCHNDSR_NAME, RTL_DEPT_CD RTL_DEPT_CD, RTL_DEPT_NAME RTL_DEPT_NAME, RTL_DEPT_BYR_NAME RTL_DEPT_BYR_NAME, RTL_DEPT_MRCHNDSR_NAME RTL_DEPT_MRCHNDSR_NAME, RTL_CLASS_CD RTL_CLASS_CD, RTL_CLASS_NAME RTL_CLASS_NAME, RTL_CLASS_BYR_NAME RTL_CLASS_BYR_NAME, RTL_CLASS_MRCHNDSR_NAME RTL_CLASS_MRCHNDSR_NAME, RTL_SBC_CD RTL_SBC_CD, RTL_SBC_NAME RTL_SBC_NAME, RTL_SBC_BYR_NAME RTL_SBC_BYR_NAME, RTL_SBC_MRCHNDSR_NAME RTL_SBC_MRCHNDSR_NAME, RTL_ITEM_NBR RTL_ITEM_NBR, RTL_ITEM_NAME RTL_ITEM_NAME, RTL_ITEM_DESC RTL_ITEM_DESC, RTL_BRND_CD RTL_BRND_CD, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, GLBL_ITEM_ID GLBL_ITEM_ID, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, RTL_SKU_ITEM_NAME RTL_SKU_ITEM_NAME, RTL_SKU_ITEM_DESC RTL_SKU_ITEM_DESC, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT from "DDR"."DDR_I_RTL_ITEM_HCHY"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, RTL_CMPNY_CD RTL_CMPNY_CD
, RTL_DIV_CD RTL_DIV_CD
, RTL_DIV_NAME RTL_DIV_NAME
, RTL_DIV_BYR_NAME RTL_DIV_BYR_NAME
, RTL_DIV_MRCHNDSR_NAME RTL_DIV_MRCHNDSR_NAME
, RTL_GRP_CD RTL_GRP_CD
, RTL_GRP_NAME RTL_GRP_NAME
, RTL_GRP_BYR_NAME RTL_GRP_BYR_NAME
, RTL_GRP_MRCHNDSR_NAME RTL_GRP_MRCHNDSR_NAME
, RTL_DEPT_CD RTL_DEPT_CD
, RTL_DEPT_NAME RTL_DEPT_NAME
, RTL_DEPT_BYR_NAME RTL_DEPT_BYR_NAME
, RTL_DEPT_MRCHNDSR_NAME RTL_DEPT_MRCHNDSR_NAME
, RTL_CLASS_CD RTL_CLASS_CD
, RTL_CLASS_NAME RTL_CLASS_NAME
, RTL_CLASS_BYR_NAME RTL_CLASS_BYR_NAME
, RTL_CLASS_MRCHNDSR_NAME RTL_CLASS_MRCHNDSR_NAME
, RTL_SBC_CD RTL_SBC_CD
, RTL_SBC_NAME RTL_SBC_NAME
, RTL_SBC_BYR_NAME RTL_SBC_BYR_NAME
, RTL_SBC_MRCHNDSR_NAME RTL_SBC_MRCHNDSR_NAME
, RTL_ITEM_NBR RTL_ITEM_NBR
, RTL_ITEM_NAME RTL_ITEM_NAME
, RTL_ITEM_DESC RTL_ITEM_DESC
, RTL_BRND_CD RTL_BRND_CD
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID GLBL_ITEM_ID
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, RTL_SKU_ITEM_NAME RTL_SKU_ITEM_NAME
, RTL_SKU_ITEM_DESC RTL_SKU_ITEM_DESC
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
FROM "DDR"."DDR_I_RTL_ITEM_HCHY"