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_MFG_PRMTN_DTL#

Source

View Text - Preformatted


select REC_ID REC_ID, PRMTN_CD PRMTN_CD, ORG_CD ORG_CD, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR, PRMTN_FROM_DT PRMTN_FROM_DT, PRMTN_TO_DT PRMTN_TO_DT, PRMTN_PRICE_AMT PRMTN_PRICE_AMT, PRMTN_SHIP_FROM_DT PRMTN_SHIP_FROM_DT, PRMTN_SHIP_TO_DT PRMTN_SHIP_TO_DT, EXPTD_BASE_SLS_QTY EXPTD_BASE_SLS_QTY, EXPTD_INCR_SLS_QTY EXPTD_INCR_SLS_QTY, EXPTD_BASE_SLS_AMT EXPTD_BASE_SLS_AMT, EXPTD_INCR_SLS_AMT EXPTD_INCR_SLS_AMT, EXPTD_ACV_PCT EXPTD_ACV_PCT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, PROCESS_ACTION PROCESS_ACTION, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT from "DDR"."DDR_I_MFG_PRMTN_DTL"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, PRMTN_CD PRMTN_CD
, ORG_CD ORG_CD
, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR
, PRMTN_FROM_DT PRMTN_FROM_DT
, PRMTN_TO_DT PRMTN_TO_DT
, PRMTN_PRICE_AMT PRMTN_PRICE_AMT
, PRMTN_SHIP_FROM_DT PRMTN_SHIP_FROM_DT
, PRMTN_SHIP_TO_DT PRMTN_SHIP_TO_DT
, EXPTD_BASE_SLS_QTY EXPTD_BASE_SLS_QTY
, EXPTD_INCR_SLS_QTY EXPTD_INCR_SLS_QTY
, EXPTD_BASE_SLS_AMT EXPTD_BASE_SLS_AMT
, EXPTD_INCR_SLS_AMT EXPTD_INCR_SLS_AMT
, EXPTD_ACV_PCT EXPTD_ACV_PCT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, PROCESS_ACTION PROCESS_ACTION
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
FROM "DDR"."DDR_I_MFG_PRMTN_DTL"