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: APPS.DDR_BS_SLSR_ITM_BU_WK_C_MV#

Source

View Text - Preformatted


SELECT "A5"."MFG_ORG_CD" "MFG_ORG_CD",
    "A5"."RTL_ORG_CD" "RTL_ORG_CD",
    "A5"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID",
    "A5"."ITM_TYP" "ITM_TYP",
    "A3"."MKT_AREA_ID" "MKT_AREA_ID",
    "A3"."CHNL_TYP_CD" "CHNL_TYP_CD",
    "A3"."ORG_RGN_ID" "ORG_RGN_ID",
    "A3"."ORG_CHAIN_ID" "ORG_CHAIN_ID",
    "A2"."MFG_ITEM_ID" "MFG_ITEM_ID",
    "A2"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID",
    "A1"."RTL_ITEM_ID" "RTL_ITEM_ID",
    "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID",
    "A4"."CLNDR_WK_ID" "CLNDR_WK_ID",
    "A5"."SLS_TYP_CD" "SLS_TYP_CD",
    "A5"."MFG_PRMTN_ID" "MFG_PRMTN_ID",
    COUNT(*) "CNT_TOTAL",
    COUNT(DECODE(SIGN("A5"."SLS_QTY_PRMRY"),1,1,NULL)) "ACT_BU_ITM_DAYS_SCANNED",
    SUM(NVL("A5"."SLS_QTY_PRMRY",0)) "SLS_QTY_PRMRY",
    SUM(NVL("A5"."SLS_QTY_ALT",0)) "SLS_QTY_ALT",
    SUM(NVL("A5"."SLS_AMT",0)) "SLS_AMT",
    SUM(NVL("A5"."SLS_AMT_RPT",0)) "SLS_AMT_RPT",
    SUM(NVL("A5"."SLS_COST_AMT",0)) "SLS_COST_AMT",
    SUM(NVL("A5"."SLS_COST_AMT_RPT",0)) "SLS_COST_AMT_RPT",
    SUM(NVL("A5"."RTRN_QTY_PRMRY",0)) "RTRN_QTY_PRMRY",
    SUM(NVL("A5"."RTRN_QTY_ALT",0)) "RTRN_QTY_ALT",
    SUM(NVL("A5"."RTRN_AMT",0)) "RTRN_AMT",
    SUM(NVL("A5"."RTRN_AMT_RPT",0)) "RTRN_AMT_RPT",
    SUM(NVL("A5"."RTRN_COST_AMT",0)) "RTRN_COST_AMT",
    SUM(NVL("A5"."RTRN_COST_AMT_RPT",0)) "RTRN_COST_AMT_RPT",
    COUNT(NVL("A5"."SLS_QTY_PRMRY",0)) "CNT_SLS_QTY_PRMRY",
    COUNT(NVL("A5"."SLS_QTY_ALT",0)) "CNT_SLS_QTY_ALT",
    COUNT(NVL("A5"."SLS_AMT",0)) "CNT_SLS_AMT",
    COUNT(NVL("A5"."SLS_AMT_RPT",0)) "CNT_SLS_AMT_RPT",
    COUNT(NVL("A5"."SLS_COST_AMT",0)) "CNT_SLS_COST_AMT",
    COUNT(NVL("A5"."SLS_COST_AMT_RPT",0)) "CNT_SLS_COST_AMT_RPT",
    COUNT(NVL("A5"."RTRN_QTY_PRMRY",0)) "CNT_RTRN_QTY_PRMRY",
    COUNT(NVL("A5"."RTRN_QTY_ALT",0)) "CNT_RTRN_QTY_ALT",
    COUNT(NVL("A5"."RTRN_AMT",0)) "CNT_RTRN_AMT",
    COUNT(NVL("A5"."RTRN_AMT_RPT",0)) "CNT_RTRN_AMT_RPT",
    COUNT(NVL("A5"."RTRN_COST_AMT",0)) "CNT_RTRN_COST_AMT",
    COUNT(NVL("A5"."RTRN_COST_AMT_RPT",0)) "CNT_RTRN_COST_AMT_RPT"
  FROM "DDR_B_RTL_SL_RTN_ITM_DAY" "A5",
    "DDR_R_CLNDR_DAY_DN_MV" "A4",
    "DDR_R_ORG_BU_DN_MV" "A3",
    "DDR_R_MFG_ITEM_SKU_DN_MV" "A2",
    "DDR_R_RTL_ITEM_SKU_DN_MV" "A1"
  WHERE "A4"."DAY_CD"  ="A5"."DAY_CD"
  AND "A4"."CLNDR_DESC"="A5"."MFG_ORG_CD"
    ||'-CLNDR'
  AND "A2"."MFG_SKU_ITEM_ID" ="A5"."MFG_SKU_ITEM_ID"
  AND "A1"."RTL_SKU_ITEM_ID" ="A5"."RTL_SKU_ITEM_ID"
  AND "A3"."ORG_BSNS_UNIT_ID"="A5"."ORG_BSNS_UNIT_ID"
  GROUP BY "A4"."CLNDR_WK_ID",
    "A5"."MFG_ORG_CD",
    "A5"."RTL_ORG_CD",
    "A5"."ORG_BSNS_UNIT_ID",
    "A5"."ITM_TYP",
    "A3"."MKT_AREA_ID",
    "A3"."CHNL_TYP_CD",
    "A3"."ORG_RGN_ID",
    "A3"."ORG_CHAIN_ID",
    "A2"."MFG_ITEM_ID",
    "A2"."MFG_ITEM_CLASS_ID",
    "A1"."RTL_ITEM_ID",
    "A1"."RTL_ITEM_CLASS_ID",
    "A5"."SLS_TYP_CD",
    "A5"."MFG_PRMTN_ID"

View Text - HTML Formatted

SELECT "A5"."MFG_ORG_CD" "MFG_ORG_CD"
, "A5"."RTL_ORG_CD" "RTL_ORG_CD"
, "A5"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID"
, "A5"."ITM_TYP" "ITM_TYP"
, "A3"."MKT_AREA_ID" "MKT_AREA_ID"
, "A3"."CHNL_TYP_CD" "CHNL_TYP_CD"
, "A3"."ORG_RGN_ID" "ORG_RGN_ID"
, "A3"."ORG_CHAIN_ID" "ORG_CHAIN_ID"
, "A2"."MFG_ITEM_ID" "MFG_ITEM_ID"
, "A2"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_ID" "RTL_ITEM_ID"
, "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID"
, "A4"."CLNDR_WK_ID" "CLNDR_WK_ID"
, "A5"."SLS_TYP_CD" "SLS_TYP_CD"
, "A5"."MFG_PRMTN_ID" "MFG_PRMTN_ID"
, COUNT(*) "CNT_TOTAL"
, COUNT(DECODE(SIGN("A5"."SLS_QTY_PRMRY")
, 1
, 1
, NULL)) "ACT_BU_ITM_DAYS_SCANNED"
, SUM(NVL("A5"."SLS_QTY_PRMRY"
, 0)) "SLS_QTY_PRMRY"
, SUM(NVL("A5"."SLS_QTY_ALT"
, 0)) "SLS_QTY_ALT"
, SUM(NVL("A5"."SLS_AMT"
, 0)) "SLS_AMT"
, SUM(NVL("A5"."SLS_AMT_RPT"
, 0)) "SLS_AMT_RPT"
, SUM(NVL("A5"."SLS_COST_AMT"
, 0)) "SLS_COST_AMT"
, SUM(NVL("A5"."SLS_COST_AMT_RPT"
, 0)) "SLS_COST_AMT_RPT"
, SUM(NVL("A5"."RTRN_QTY_PRMRY"
, 0)) "RTRN_QTY_PRMRY"
, SUM(NVL("A5"."RTRN_QTY_ALT"
, 0)) "RTRN_QTY_ALT"
, SUM(NVL("A5"."RTRN_AMT"
, 0)) "RTRN_AMT"
, SUM(NVL("A5"."RTRN_AMT_RPT"
, 0)) "RTRN_AMT_RPT"
, SUM(NVL("A5"."RTRN_COST_AMT"
, 0)) "RTRN_COST_AMT"
, SUM(NVL("A5"."RTRN_COST_AMT_RPT"
, 0)) "RTRN_COST_AMT_RPT"
, COUNT(NVL("A5"."SLS_QTY_PRMRY"
, 0)) "CNT_SLS_QTY_PRMRY"
, COUNT(NVL("A5"."SLS_QTY_ALT"
, 0)) "CNT_SLS_QTY_ALT"
, COUNT(NVL("A5"."SLS_AMT"
, 0)) "CNT_SLS_AMT"
, COUNT(NVL("A5"."SLS_AMT_RPT"
, 0)) "CNT_SLS_AMT_RPT"
, COUNT(NVL("A5"."SLS_COST_AMT"
, 0)) "CNT_SLS_COST_AMT"
, COUNT(NVL("A5"."SLS_COST_AMT_RPT"
, 0)) "CNT_SLS_COST_AMT_RPT"
, COUNT(NVL("A5"."RTRN_QTY_PRMRY"
, 0)) "CNT_RTRN_QTY_PRMRY"
, COUNT(NVL("A5"."RTRN_QTY_ALT"
, 0)) "CNT_RTRN_QTY_ALT"
, COUNT(NVL("A5"."RTRN_AMT"
, 0)) "CNT_RTRN_AMT"
, COUNT(NVL("A5"."RTRN_AMT_RPT"
, 0)) "CNT_RTRN_AMT_RPT"
, COUNT(NVL("A5"."RTRN_COST_AMT"
, 0)) "CNT_RTRN_COST_AMT"
, COUNT(NVL("A5"."RTRN_COST_AMT_RPT"
, 0)) "CNT_RTRN_COST_AMT_RPT"
FROM "DDR_B_RTL_SL_RTN_ITM_DAY" "A5"
, "DDR_R_CLNDR_DAY_DN_MV" "A4"
, "DDR_R_ORG_BU_DN_MV" "A3"
, "DDR_R_MFG_ITEM_SKU_DN_MV" "A2"
, "DDR_R_RTL_ITEM_SKU_DN_MV" "A1"
WHERE "A4"."DAY_CD" ="A5"."DAY_CD"
AND "A4"."CLNDR_DESC"="A5"."MFG_ORG_CD" ||'-CLNDR'
AND "A2"."MFG_SKU_ITEM_ID" ="A5"."MFG_SKU_ITEM_ID"
AND "A1"."RTL_SKU_ITEM_ID" ="A5"."RTL_SKU_ITEM_ID"
AND "A3"."ORG_BSNS_UNIT_ID"="A5"."ORG_BSNS_UNIT_ID" GROUP BY "A4"."CLNDR_WK_ID"
, "A5"."MFG_ORG_CD"
, "A5"."RTL_ORG_CD"
, "A5"."ORG_BSNS_UNIT_ID"
, "A5"."ITM_TYP"
, "A3"."MKT_AREA_ID"
, "A3"."CHNL_TYP_CD"
, "A3"."ORG_RGN_ID"
, "A3"."ORG_CHAIN_ID"
, "A2"."MFG_ITEM_ID"
, "A2"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_ID"
, "A1"."RTL_ITEM_CLASS_ID"
, "A5"."SLS_TYP_CD"
, "A5"."MFG_PRMTN_ID"