VIEW: DDR.DDR_R_RTL_SKU_SLNG_PRC_H#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, RTL_SKU_SLNG_PRC_H_ID RTL_SKU_SLNG_PRC_H_ID, RTL_ORG_CD RTL_ORG_CD, RTL_BSNS_UNIT_ID RTL_BSNS_UNIT_ID, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR, RTL_SKU_SLNG_PRC_ID RTL_SKU_SLNG_PRC_ID, SLNG_PRICE_NBR SLNG_PRICE_NBR, SL_PRICE_AMT SL_PRICE_AMT, SL_PRICE_AMT_LCL SL_PRICE_AMT_LCL, SL_PRICE_AMT_RPT SL_PRICE_AMT_RPT, EFF_FROM_DT EFF_FROM_DT, EFF_TO_DT EFF_TO_DT, 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_SLNG_PRC_H"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, RTL_SKU_SLNG_PRC_H_ID RTL_SKU_SLNG_PRC_H_ID
, RTL_ORG_CD RTL_ORG_CD
, RTL_BSNS_UNIT_ID RTL_BSNS_UNIT_ID
, RTL_BSNS_UNIT_CD RTL_BSNS_UNIT_CD
, RTL_SKU_ITEM_ID RTL_SKU_ITEM_ID
, RTL_SKU_ITEM_NBR RTL_SKU_ITEM_NBR
, RTL_SKU_SLNG_PRC_ID RTL_SKU_SLNG_PRC_ID
, SLNG_PRICE_NBR SLNG_PRICE_NBR
, SL_PRICE_AMT SL_PRICE_AMT
, SL_PRICE_AMT_LCL SL_PRICE_AMT_LCL
, SL_PRICE_AMT_RPT SL_PRICE_AMT_RPT
, EFF_FROM_DT EFF_FROM_DT
, EFF_TO_DT EFF_TO_DT
, 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_SLNG_PRC_H"