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: MSD.T_SRC_SALES_TMPL#

Source

View Text - Preformatted


select T_EP_P1 T_EP_P1, T_EP_LR1 T_EP_LR1, T_EP_LS1 T_EP_LS1, ACTUAL_QTY ACTUAL_QTY, BASE_EVT_DOL_RTL BASE_EVT_DOL_RTL, INCR_EVT_DOL_RTL INCR_EVT_DOL_RTL, ITEM_PRICE ITEM_PRICE, SALES_DATE SALES_DATE, SDATA10 SDATA10, SDATA11 SDATA11, SDATA12 SDATA12, SDATA13 SDATA13, SDATA14 SDATA14, SDATA4 SDATA4, SDATA5 SDATA5, SDATA6 SDATA6, SDATA7 SDATA7, SDATA8 SDATA8, SDATA9 SDATA9, SHELF_PRICE_SD SHELF_PRICE_SD, T_EP_M1 T_EP_M1, T_EP_M2 T_EP_M2, SDATA15 SDATA15, DM_ITEM_CODE DM_ITEM_CODE, DM_ORG_CODE DM_ORG_CODE, DM_SITE_CODE DM_SITE_CODE, E1_ITEM_BRANCH_CATEGORY_1 E1_ITEM_BRANCH_CATEGORY_1, E1_ITEM_BRANCH_CATEGORY_2 E1_ITEM_BRANCH_CATEGORY_2, E1_ITEM_BRANCH_CATEGORY_3 E1_ITEM_BRANCH_CATEGORY_3, E1_ITEM_BRANCH_CATEGORY_4 E1_ITEM_BRANCH_CATEGORY_4, E1_ITEM_BRANCH_CATEGORY_5 E1_ITEM_BRANCH_CATEGORY_5, E1_ITEM_BRANCH_CATEGORY_6 E1_ITEM_BRANCH_CATEGORY_6, E1_ITEM_BRANCH_CATEGORY_7 E1_ITEM_BRANCH_CATEGORY_7, E1_ITEM_BRANCH_CATEGORY_8 E1_ITEM_BRANCH_CATEGORY_8, E1_ITEM_BRANCH_CATEGORY_9 E1_ITEM_BRANCH_CATEGORY_9, E1_ITEM_BRANCH_CATEGORY_10 E1_ITEM_BRANCH_CATEGORY_10, E1_ITEM_BRANCH_CATEGORY_11 E1_ITEM_BRANCH_CATEGORY_11, E1_ITEM_BRANCH_CATEGORY_12 E1_ITEM_BRANCH_CATEGORY_12, E1_ITEM_BRANCH_CATEGORY_13 E1_ITEM_BRANCH_CATEGORY_13, E1_ITEM_BRANCH_CATEGORY_14 E1_ITEM_BRANCH_CATEGORY_14, E1_ITEM_BRANCH_CATEGORY_15 E1_ITEM_BRANCH_CATEGORY_15, E1_ITEM_BRANCH_CATEGORY_16 E1_ITEM_BRANCH_CATEGORY_16, E1_ITEM_BRANCH_CATEGORY_17 E1_ITEM_BRANCH_CATEGORY_17, E1_ITEM_BRANCH_CATEGORY_18 E1_ITEM_BRANCH_CATEGORY_18, E1_ITEM_BRANCH_CATEGORY_19 E1_ITEM_BRANCH_CATEGORY_19, E1_ITEM_BRANCH_CATEGORY_20 E1_ITEM_BRANCH_CATEGORY_20, E1_ITEM_BRANCH_CATEGORY_21 E1_ITEM_BRANCH_CATEGORY_21, E1_ITEM_BRANCH_CATEGORY_22 E1_ITEM_BRANCH_CATEGORY_22, E1_ITEM_BRANCH_CATEGORY_23 E1_ITEM_BRANCH_CATEGORY_23, EBS_DEMAND_CLASS_CODE EBS_DEMAND_CLASS_CODE, EBS_SALES_CHANNEL_CODE EBS_SALES_CHANNEL_CODE, EBS_BOOK_HIST_BOOK_QTY_BD EBS_BOOK_HIST_BOOK_QTY_BD, EBS_BOOK_HIST_REQ_QTY_BD EBS_BOOK_HIST_REQ_QTY_BD, EBS_BOOK_HIST_BOOK_QTY_RD EBS_BOOK_HIST_BOOK_QTY_RD, EBS_BOOK_HIST_REQ_QTY_RD EBS_BOOK_HIST_REQ_QTY_RD, EBS_SHIP_HIST_SHIP_QTY_SD EBS_SHIP_HIST_SHIP_QTY_SD, EBS_SHIP_HIST_SHIP_QTY_RD EBS_SHIP_HIST_SHIP_QTY_RD, EBS_SHIP_HIST_REQ_QTY_RD EBS_SHIP_HIST_REQ_QTY_RD, EBS_ITEM_SR_PK EBS_ITEM_SR_PK, EBS_ORG_SR_PK EBS_ORG_SR_PK, EBS_SITE_SR_PK EBS_SITE_SR_PK, EBS_DEMAND_CLASS_SR_PK EBS_DEMAND_CLASS_SR_PK, EBS_SALES_CHANNEL_SR_PK EBS_SALES_CHANNEL_SR_PK, DM_PARENT_ITEM_CODE DM_PARENT_ITEM_CODE, CTO_PLN_PCT CTO_PLN_PCT, EBS_PARENT_ITEM_SR_PK EBS_PARENT_ITEM_SR_PK, EBS_BASE_MODEL_SR_PK EBS_BASE_MODEL_SR_PK, EBS_PARENT_ITEM_CODE EBS_PARENT_ITEM_CODE, EBS_BASE_MODEL_CODE EBS_BASE_MODEL_CODE, COMPONENT_CODE COMPONENT_CODE, COMPONENT_CODE_LEGACY COMPONENT_CODE_LEGACY from "MSD"."T_SRC_SALES_TMPL"

View Text - HTML Formatted

SELECT T_EP_P1 T_EP_P1
, T_EP_LR1 T_EP_LR1
, T_EP_LS1 T_EP_LS1
, ACTUAL_QTY ACTUAL_QTY
, BASE_EVT_DOL_RTL BASE_EVT_DOL_RTL
, INCR_EVT_DOL_RTL INCR_EVT_DOL_RTL
, ITEM_PRICE ITEM_PRICE
, SALES_DATE SALES_DATE
, SDATA10 SDATA10
, SDATA11 SDATA11
, SDATA12 SDATA12
, SDATA13 SDATA13
, SDATA14 SDATA14
, SDATA4 SDATA4
, SDATA5 SDATA5
, SDATA6 SDATA6
, SDATA7 SDATA7
, SDATA8 SDATA8
, SDATA9 SDATA9
, SHELF_PRICE_SD SHELF_PRICE_SD
, T_EP_M1 T_EP_M1
, T_EP_M2 T_EP_M2
, SDATA15 SDATA15
, DM_ITEM_CODE DM_ITEM_CODE
, DM_ORG_CODE DM_ORG_CODE
, DM_SITE_CODE DM_SITE_CODE
, E1_ITEM_BRANCH_CATEGORY_1 E1_ITEM_BRANCH_CATEGORY_1
, E1_ITEM_BRANCH_CATEGORY_2 E1_ITEM_BRANCH_CATEGORY_2
, E1_ITEM_BRANCH_CATEGORY_3 E1_ITEM_BRANCH_CATEGORY_3
, E1_ITEM_BRANCH_CATEGORY_4 E1_ITEM_BRANCH_CATEGORY_4
, E1_ITEM_BRANCH_CATEGORY_5 E1_ITEM_BRANCH_CATEGORY_5
, E1_ITEM_BRANCH_CATEGORY_6 E1_ITEM_BRANCH_CATEGORY_6
, E1_ITEM_BRANCH_CATEGORY_7 E1_ITEM_BRANCH_CATEGORY_7
, E1_ITEM_BRANCH_CATEGORY_8 E1_ITEM_BRANCH_CATEGORY_8
, E1_ITEM_BRANCH_CATEGORY_9 E1_ITEM_BRANCH_CATEGORY_9
, E1_ITEM_BRANCH_CATEGORY_10 E1_ITEM_BRANCH_CATEGORY_10
, E1_ITEM_BRANCH_CATEGORY_11 E1_ITEM_BRANCH_CATEGORY_11
, E1_ITEM_BRANCH_CATEGORY_12 E1_ITEM_BRANCH_CATEGORY_12
, E1_ITEM_BRANCH_CATEGORY_13 E1_ITEM_BRANCH_CATEGORY_13
, E1_ITEM_BRANCH_CATEGORY_14 E1_ITEM_BRANCH_CATEGORY_14
, E1_ITEM_BRANCH_CATEGORY_15 E1_ITEM_BRANCH_CATEGORY_15
, E1_ITEM_BRANCH_CATEGORY_16 E1_ITEM_BRANCH_CATEGORY_16
, E1_ITEM_BRANCH_CATEGORY_17 E1_ITEM_BRANCH_CATEGORY_17
, E1_ITEM_BRANCH_CATEGORY_18 E1_ITEM_BRANCH_CATEGORY_18
, E1_ITEM_BRANCH_CATEGORY_19 E1_ITEM_BRANCH_CATEGORY_19
, E1_ITEM_BRANCH_CATEGORY_20 E1_ITEM_BRANCH_CATEGORY_20
, E1_ITEM_BRANCH_CATEGORY_21 E1_ITEM_BRANCH_CATEGORY_21
, E1_ITEM_BRANCH_CATEGORY_22 E1_ITEM_BRANCH_CATEGORY_22
, E1_ITEM_BRANCH_CATEGORY_23 E1_ITEM_BRANCH_CATEGORY_23
, EBS_DEMAND_CLASS_CODE EBS_DEMAND_CLASS_CODE
, EBS_SALES_CHANNEL_CODE EBS_SALES_CHANNEL_CODE
, EBS_BOOK_HIST_BOOK_QTY_BD EBS_BOOK_HIST_BOOK_QTY_BD
, EBS_BOOK_HIST_REQ_QTY_BD EBS_BOOK_HIST_REQ_QTY_BD
, EBS_BOOK_HIST_BOOK_QTY_RD EBS_BOOK_HIST_BOOK_QTY_RD
, EBS_BOOK_HIST_REQ_QTY_RD EBS_BOOK_HIST_REQ_QTY_RD
, EBS_SHIP_HIST_SHIP_QTY_SD EBS_SHIP_HIST_SHIP_QTY_SD
, EBS_SHIP_HIST_SHIP_QTY_RD EBS_SHIP_HIST_SHIP_QTY_RD
, EBS_SHIP_HIST_REQ_QTY_RD EBS_SHIP_HIST_REQ_QTY_RD
, EBS_ITEM_SR_PK EBS_ITEM_SR_PK
, EBS_ORG_SR_PK EBS_ORG_SR_PK
, EBS_SITE_SR_PK EBS_SITE_SR_PK
, EBS_DEMAND_CLASS_SR_PK EBS_DEMAND_CLASS_SR_PK
, EBS_SALES_CHANNEL_SR_PK EBS_SALES_CHANNEL_SR_PK
, DM_PARENT_ITEM_CODE DM_PARENT_ITEM_CODE
, CTO_PLN_PCT CTO_PLN_PCT
, EBS_PARENT_ITEM_SR_PK EBS_PARENT_ITEM_SR_PK
, EBS_BASE_MODEL_SR_PK EBS_BASE_MODEL_SR_PK
, EBS_PARENT_ITEM_CODE EBS_PARENT_ITEM_CODE
, EBS_BASE_MODEL_CODE EBS_BASE_MODEL_CODE
, COMPONENT_CODE COMPONENT_CODE
, COMPONENT_CODE_LEGACY COMPONENT_CODE_LEGACY
FROM "MSD"."T_SRC_SALES_TMPL"