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

Source

View Text - Preformatted


SELECT "A1"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID",
    "A1"."ORG_RGN_ID" "ORG_RGN_ID",
    "A1"."ORG_CHAIN_ID" "ORG_CHAIN_ID",
    "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID",
    "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID",
    "A1"."ITM_TYP" "ITM_TYP",
    "A1"."CLNDR_MNTH_ID" "CLNDR_DIM_ID",
    'MNTH' "CLNDR_DIM_LVL",
    DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID","A1"."ORG_RGN_ID"),2,"A1"."ORG_RGN_ID",1,"A1"."ORG_CHAIN_ID") "ORG_DIM_ID",
    DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID","A1"."ORG_RGN_ID"),2,'RGN',1,'CHN') "ORG_DIM_LVL",
    "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_DIM_ID",
    DECODE("A1"."MFG_ITEM_CLASS_ID",NULL,NULL,'CLS') "MFG_ITEM_DIM_LVL",
    "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_DIM_ID",
    DECODE("A1"."RTL_ITEM_CLASS_ID",NULL,NULL,'CLS') "RTL_ITEM_DIM_LVL",
    COUNT(*) "CNT_TOTAL",
    SUM("A1"."IN_STCK_BU_ITM_DAYS") "IN_STCK_BU_ITM_DAYS",
    COUNT("A1"."IN_STCK_BU_ITM_DAYS") "CNT_IN_STCK_BU_ITM_DAYS",
    SUM("A1"."UNDR_STCK_BU_ITM_DAYS") "UNDR_STCK_BU_ITM_DAYS",
    COUNT("A1"."UNDR_STCK_BU_ITM_DAYS") "CNT_UNDR_STCK_BU_ITM_DAYS",
    SUM(NVL("A1"."ON_HAND_QTY_PRMRY",0)) "ON_HAND_QTY_PRMRY",
    SUM(NVL("A1"."ON_HAND_QTY_ALT",0)) "ON_HAND_QTY_ALT",
    SUM("A1"."RECVD_QTY_PRMRY") "RECVD_QTY_PRMRY",
    SUM("A1"."RECVD_QTY_ALT") "RECVD_QTY_ALT",
    SUM(NVL("A1"."IN_TRANSIT_QTY_PRMRY",0)) "IN_TRANSIT_QTY_PRMRY",
    SUM(NVL("A1"."IN_TRANSIT_QTY_ALT",0)) "IN_TRANSIT_QTY_ALT",
    SUM(NVL("A1"."BCK_ORDR_QTY_PRMRY",0)) "BCK_ORDR_QTY_PRMRY",
    SUM(NVL("A1"."BCK_ORDR_QTY_ALT",0)) "BCK_ORDR_QTY_ALT",
    SUM(NVL("A1"."QLTY_HOLD_QTY_PRMRY",0)) "QLTY_HOLD_QTY_PRMRY",
    SUM(NVL("A1"."QLTY_HOLD_QTY_ALT",0)) "QLTY_HOLD_QTY_ALT",
    SUM(NVL("A1"."ON_HAND_NET_COST_AMT",0)) "ON_HAND_NET_COST_AMT",
    SUM(NVL("A1"."ON_HAND_NET_COST_AMT_RPT",0)) "ON_HAND_NET_COST_AMT_RPT",
    SUM("A1"."RECVD_NET_COST_AMT") "RECVD_NET_COST_AMT",
    SUM("A1"."RECVD_NET_COST_AMT_RPT") "RECVD_NET_COST_AMT_RPT",
    SUM(NVL("A1"."IN_TRANSIT_NET_COST_AMT",0)) "IN_TRANSIT_NET_COST_AMT",
    SUM(NVL("A1"."IN_TRANSIT_NET_COST_AMT_RPT",0)) "IN_TRANSIT_NET_COST_AMT_RPT",
    SUM(NVL("A1"."BCKORDR_NET_COST_AMT",0)) "BCKORDR_NET_COST_AMT",
    SUM(NVL("A1"."BCKORDR_NET_COST_AMT_RPT",0)) "BCKORDR_NET_COST_AMT_RPT",
    SUM(NVL("A1"."QLTY_HOLD_NET_COST_AMT",0)) "QLTY_HOLD_NET_COST_AMT",
    SUM(NVL("A1"."QLTY_HOLD_NET_COST_AMT_RPT",0)) "QLTY_HOLD_NET_COST_AMT_RPT",
    SUM(NVL("A1"."ON_HAND_RTL_AMT",0)) "ON_HAND_RTL_AMT",
    SUM(NVL("A1"."ON_HAND_RTL_AMT_RPT",0)) "ON_HAND_RTL_AMT_RPT",
    SUM("A1"."RECVD_RTL_AMT") "RECVD_RTL_AMT",
    SUM("A1"."RECVD_RTL_AMT_RPT") "RECVD_RTL_AMT_RPT",
    SUM(NVL("A1"."IN_TRANSIT_RTL_AMT",0)) "IN_TRANSIT_RTL_AMT",
    SUM(NVL("A1"."IN_TRANSIT_RTL_AMT_RPT",0)) "IN_TRANSIT_RTL_AMT_RPT",
    SUM(NVL("A1"."BCKORDR_RTL_AMT",0)) "BCKORDR_RTL_AMT",
    SUM(NVL("A1"."BCKORDR_RTL_AMT_RPT",0)) "BCKORDR_RTL_AMT_RPT",
    SUM(NVL("A1"."QLTY_HOLD_RTL_AMT",0)) "QLTY_HOLD_RTL_AMT",
    SUM(NVL("A1"."QLTY_HOLD_RTL_AMT_RPT",0)) "QLTY_HOLD_RTL_AMT_RPT",
    COUNT(NVL("A1"."ON_HAND_QTY_PRMRY",0)) "CNT_ON_HAND_QTY_PRMRY",
    COUNT(NVL("A1"."ON_HAND_QTY_ALT",0)) "CNT_ON_HAND_QTY_ALT",
    COUNT("A1"."RECVD_QTY_PRMRY") "CNT_RECVD_QTY_PRMRY",
    COUNT("A1"."RECVD_QTY_ALT") "CNT_RECVD_QTY_ALT",
    COUNT(NVL("A1"."IN_TRANSIT_QTY_PRMRY",0)) "CNT_IN_TRANSIT_QTY_PRMRY",
    COUNT(NVL("A1"."IN_TRANSIT_QTY_ALT",0)) "CNT_IN_TRANSIT_QTY_ALT",
    COUNT(NVL("A1"."BCK_ORDR_QTY_PRMRY",0)) "CNT_BCK_ORDR_QTY_PRMRY",
    COUNT(NVL("A1"."BCK_ORDR_QTY_ALT",0)) "CNT_BCK_ORDR_QTY_ALT",
    COUNT(NVL("A1"."QLTY_HOLD_QTY_PRMRY",0)) "CNT_QLTY_HOLD_QTY_PRMRY",
    COUNT(NVL("A1"."QLTY_HOLD_QTY_ALT",0)) "CNT_QLTY_HOLD_QTY_ALT",
    COUNT(NVL("A1"."ON_HAND_NET_COST_AMT",0)) "CNT_ON_HAND_NET_COST_AMT",
    COUNT(NVL("A1"."ON_HAND_NET_COST_AMT_RPT",0)) "CNT_ON_HAND_NET_COST_AMT_RPT",
    COUNT("A1"."RECVD_NET_COST_AMT") "CNT_RECVD_NET_COST_AMT",
    COUNT("A1"."RECVD_NET_COST_AMT_RPT") "CNT_RECVD_NET_COST_AMT_RPT",
    COUNT(NVL("A1"."IN_TRANSIT_NET_COST_AMT",0)) "CNT_IN_TRANSIT_NET_COST_AMT",
    COUNT(NVL("A1"."IN_TRANSIT_NET_COST_AMT_RPT",0)) "CNT_IN_TRANSIT_NET_CST_AMT_RPT",
    COUNT(NVL("A1"."BCKORDR_NET_COST_AMT",0)) "CNT_BCKORDR_NET_COST_AMT",
    COUNT(NVL("A1"."BCKORDR_NET_COST_AMT_RPT",0)) "CNT_BCKORDR_NET_COST_AMT_RPT",
    COUNT(NVL("A1"."QLTY_HOLD_NET_COST_AMT",0)) "CNT_QLTY_HOLD_NET_COST_AMT",
    COUNT(NVL("A1"."QLTY_HOLD_NET_COST_AMT_RPT",0)) "CNT_QLTY_HOLD_NET_COST_AMT_RPT",
    COUNT(NVL("A1"."ON_HAND_RTL_AMT",0)) "CNT_ON_HAND_RTL_AMT",
    COUNT(NVL("A1"."ON_HAND_RTL_AMT_RPT",0)) "CNT_ON_HAND_RTL_AMT_RPT",
    COUNT("A1"."RECVD_RTL_AMT") "CNT_RECVD_RTL_AMT",
    COUNT("A1"."RECVD_RTL_AMT_RPT") "CNT_RECVD_RTL_AMT_RPT",
    COUNT(NVL("A1"."IN_TRANSIT_RTL_AMT",0)) "CNT_IN_TRANSIT_RTL_AMT",
    COUNT(NVL("A1"."IN_TRANSIT_RTL_AMT_RPT",0)) "CNT_IN_TRANSIT_RTL_AMT_RPT",
    COUNT(NVL("A1"."BCKORDR_RTL_AMT",0)) "CNT_BCKORDR_RTL_AMT",
    COUNT(NVL("A1"."BCKORDR_RTL_AMT_RPT",0)) "CNT_BCKORDR_RTL_AMT_RPT",
    COUNT(NVL("A1"."QLTY_HOLD_RTL_AMT",0)) "CNT_QLTY_HOLD_RTL_AMT",
    COUNT(NVL("A1"."QLTY_HOLD_RTL_AMT_RPT",0)) "CNT_QLTY_HOLD_RTL_AMT_RPT",
    GROUPING_ID("A1"."ITM_TYP","A1"."MFG_ITEM_CLASS_ID","A1"."RTL_ITEM_CLASS_ID","A1"."ORG_RGN_ID","A1"."ORG_CHAIN_ID","A1"."CLNDR_MNTH_ID") "GROUPING_ID"
  FROM "APPS"."DDR_SV_INV_INT_C_MV" "A1"
  GROUP BY GROUPING SETS (("A1"."CLNDR_MNTH_ID", "A1"."ORG_RGN_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."RTL_ITEM_CLASS_ID", "A1"."ITM_TYP"), ("A1"."CLNDR_MNTH_ID", "A1"."ORG_CHAIN_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."RTL_ITEM_CLASS_ID", "A1"."ITM_TYP"))

View Text - HTML Formatted

SELECT "A1"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID"
, "A1"."ORG_RGN_ID" "ORG_RGN_ID"
, "A1"."ORG_CHAIN_ID" "ORG_CHAIN_ID"
, "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID"
, "A1"."ITM_TYP" "ITM_TYP"
, "A1"."CLNDR_MNTH_ID" "CLNDR_DIM_ID"
, 'MNTH' "CLNDR_DIM_LVL"
, DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID"
, "A1"."ORG_RGN_ID")
, 2
, "A1"."ORG_RGN_ID"
, 1
, "A1"."ORG_CHAIN_ID") "ORG_DIM_ID"
, DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID"
, "A1"."ORG_RGN_ID")
, 2
, 'RGN'
, 1
, 'CHN') "ORG_DIM_LVL"
, "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_DIM_ID"
, DECODE("A1"."MFG_ITEM_CLASS_ID"
, NULL
, NULL
, 'CLS') "MFG_ITEM_DIM_LVL"
, "A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_DIM_ID"
, DECODE("A1"."RTL_ITEM_CLASS_ID"
, NULL
, NULL
, 'CLS') "RTL_ITEM_DIM_LVL"
, COUNT(*) "CNT_TOTAL"
, SUM("A1"."IN_STCK_BU_ITM_DAYS") "IN_STCK_BU_ITM_DAYS"
, COUNT("A1"."IN_STCK_BU_ITM_DAYS") "CNT_IN_STCK_BU_ITM_DAYS"
, SUM("A1"."UNDR_STCK_BU_ITM_DAYS") "UNDR_STCK_BU_ITM_DAYS"
, COUNT("A1"."UNDR_STCK_BU_ITM_DAYS") "CNT_UNDR_STCK_BU_ITM_DAYS"
, SUM(NVL("A1"."ON_HAND_QTY_PRMRY"
, 0)) "ON_HAND_QTY_PRMRY"
, SUM(NVL("A1"."ON_HAND_QTY_ALT"
, 0)) "ON_HAND_QTY_ALT"
, SUM("A1"."RECVD_QTY_PRMRY") "RECVD_QTY_PRMRY"
, SUM("A1"."RECVD_QTY_ALT") "RECVD_QTY_ALT"
, SUM(NVL("A1"."IN_TRANSIT_QTY_PRMRY"
, 0)) "IN_TRANSIT_QTY_PRMRY"
, SUM(NVL("A1"."IN_TRANSIT_QTY_ALT"
, 0)) "IN_TRANSIT_QTY_ALT"
, SUM(NVL("A1"."BCK_ORDR_QTY_PRMRY"
, 0)) "BCK_ORDR_QTY_PRMRY"
, SUM(NVL("A1"."BCK_ORDR_QTY_ALT"
, 0)) "BCK_ORDR_QTY_ALT"
, SUM(NVL("A1"."QLTY_HOLD_QTY_PRMRY"
, 0)) "QLTY_HOLD_QTY_PRMRY"
, SUM(NVL("A1"."QLTY_HOLD_QTY_ALT"
, 0)) "QLTY_HOLD_QTY_ALT"
, SUM(NVL("A1"."ON_HAND_NET_COST_AMT"
, 0)) "ON_HAND_NET_COST_AMT"
, SUM(NVL("A1"."ON_HAND_NET_COST_AMT_RPT"
, 0)) "ON_HAND_NET_COST_AMT_RPT"
, SUM("A1"."RECVD_NET_COST_AMT") "RECVD_NET_COST_AMT"
, SUM("A1"."RECVD_NET_COST_AMT_RPT") "RECVD_NET_COST_AMT_RPT"
, SUM(NVL("A1"."IN_TRANSIT_NET_COST_AMT"
, 0)) "IN_TRANSIT_NET_COST_AMT"
, SUM(NVL("A1"."IN_TRANSIT_NET_COST_AMT_RPT"
, 0)) "IN_TRANSIT_NET_COST_AMT_RPT"
, SUM(NVL("A1"."BCKORDR_NET_COST_AMT"
, 0)) "BCKORDR_NET_COST_AMT"
, SUM(NVL("A1"."BCKORDR_NET_COST_AMT_RPT"
, 0)) "BCKORDR_NET_COST_AMT_RPT"
, SUM(NVL("A1"."QLTY_HOLD_NET_COST_AMT"
, 0)) "QLTY_HOLD_NET_COST_AMT"
, SUM(NVL("A1"."QLTY_HOLD_NET_COST_AMT_RPT"
, 0)) "QLTY_HOLD_NET_COST_AMT_RPT"
, SUM(NVL("A1"."ON_HAND_RTL_AMT"
, 0)) "ON_HAND_RTL_AMT"
, SUM(NVL("A1"."ON_HAND_RTL_AMT_RPT"
, 0)) "ON_HAND_RTL_AMT_RPT"
, SUM("A1"."RECVD_RTL_AMT") "RECVD_RTL_AMT"
, SUM("A1"."RECVD_RTL_AMT_RPT") "RECVD_RTL_AMT_RPT"
, SUM(NVL("A1"."IN_TRANSIT_RTL_AMT"
, 0)) "IN_TRANSIT_RTL_AMT"
, SUM(NVL("A1"."IN_TRANSIT_RTL_AMT_RPT"
, 0)) "IN_TRANSIT_RTL_AMT_RPT"
, SUM(NVL("A1"."BCKORDR_RTL_AMT"
, 0)) "BCKORDR_RTL_AMT"
, SUM(NVL("A1"."BCKORDR_RTL_AMT_RPT"
, 0)) "BCKORDR_RTL_AMT_RPT"
, SUM(NVL("A1"."QLTY_HOLD_RTL_AMT"
, 0)) "QLTY_HOLD_RTL_AMT"
, SUM(NVL("A1"."QLTY_HOLD_RTL_AMT_RPT"
, 0)) "QLTY_HOLD_RTL_AMT_RPT"
, COUNT(NVL("A1"."ON_HAND_QTY_PRMRY"
, 0)) "CNT_ON_HAND_QTY_PRMRY"
, COUNT(NVL("A1"."ON_HAND_QTY_ALT"
, 0)) "CNT_ON_HAND_QTY_ALT"
, COUNT("A1"."RECVD_QTY_PRMRY") "CNT_RECVD_QTY_PRMRY"
, COUNT("A1"."RECVD_QTY_ALT") "CNT_RECVD_QTY_ALT"
, COUNT(NVL("A1"."IN_TRANSIT_QTY_PRMRY"
, 0)) "CNT_IN_TRANSIT_QTY_PRMRY"
, COUNT(NVL("A1"."IN_TRANSIT_QTY_ALT"
, 0)) "CNT_IN_TRANSIT_QTY_ALT"
, COUNT(NVL("A1"."BCK_ORDR_QTY_PRMRY"
, 0)) "CNT_BCK_ORDR_QTY_PRMRY"
, COUNT(NVL("A1"."BCK_ORDR_QTY_ALT"
, 0)) "CNT_BCK_ORDR_QTY_ALT"
, COUNT(NVL("A1"."QLTY_HOLD_QTY_PRMRY"
, 0)) "CNT_QLTY_HOLD_QTY_PRMRY"
, COUNT(NVL("A1"."QLTY_HOLD_QTY_ALT"
, 0)) "CNT_QLTY_HOLD_QTY_ALT"
, COUNT(NVL("A1"."ON_HAND_NET_COST_AMT"
, 0)) "CNT_ON_HAND_NET_COST_AMT"
, COUNT(NVL("A1"."ON_HAND_NET_COST_AMT_RPT"
, 0)) "CNT_ON_HAND_NET_COST_AMT_RPT"
, COUNT("A1"."RECVD_NET_COST_AMT") "CNT_RECVD_NET_COST_AMT"
, COUNT("A1"."RECVD_NET_COST_AMT_RPT") "CNT_RECVD_NET_COST_AMT_RPT"
, COUNT(NVL("A1"."IN_TRANSIT_NET_COST_AMT"
, 0)) "CNT_IN_TRANSIT_NET_COST_AMT"
, COUNT(NVL("A1"."IN_TRANSIT_NET_COST_AMT_RPT"
, 0)) "CNT_IN_TRANSIT_NET_CST_AMT_RPT"
, COUNT(NVL("A1"."BCKORDR_NET_COST_AMT"
, 0)) "CNT_BCKORDR_NET_COST_AMT"
, COUNT(NVL("A1"."BCKORDR_NET_COST_AMT_RPT"
, 0)) "CNT_BCKORDR_NET_COST_AMT_RPT"
, COUNT(NVL("A1"."QLTY_HOLD_NET_COST_AMT"
, 0)) "CNT_QLTY_HOLD_NET_COST_AMT"
, COUNT(NVL("A1"."QLTY_HOLD_NET_COST_AMT_RPT"
, 0)) "CNT_QLTY_HOLD_NET_COST_AMT_RPT"
, COUNT(NVL("A1"."ON_HAND_RTL_AMT"
, 0)) "CNT_ON_HAND_RTL_AMT"
, COUNT(NVL("A1"."ON_HAND_RTL_AMT_RPT"
, 0)) "CNT_ON_HAND_RTL_AMT_RPT"
, COUNT("A1"."RECVD_RTL_AMT") "CNT_RECVD_RTL_AMT"
, COUNT("A1"."RECVD_RTL_AMT_RPT") "CNT_RECVD_RTL_AMT_RPT"
, COUNT(NVL("A1"."IN_TRANSIT_RTL_AMT"
, 0)) "CNT_IN_TRANSIT_RTL_AMT"
, COUNT(NVL("A1"."IN_TRANSIT_RTL_AMT_RPT"
, 0)) "CNT_IN_TRANSIT_RTL_AMT_RPT"
, COUNT(NVL("A1"."BCKORDR_RTL_AMT"
, 0)) "CNT_BCKORDR_RTL_AMT"
, COUNT(NVL("A1"."BCKORDR_RTL_AMT_RPT"
, 0)) "CNT_BCKORDR_RTL_AMT_RPT"
, COUNT(NVL("A1"."QLTY_HOLD_RTL_AMT"
, 0)) "CNT_QLTY_HOLD_RTL_AMT"
, COUNT(NVL("A1"."QLTY_HOLD_RTL_AMT_RPT"
, 0)) "CNT_QLTY_HOLD_RTL_AMT_RPT"
, GROUPING_ID("A1"."ITM_TYP"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_CLASS_ID"
, "A1"."ORG_RGN_ID"
, "A1"."ORG_CHAIN_ID"
, "A1"."CLNDR_MNTH_ID") "GROUPING_ID"
FROM "APPS"."DDR_SV_INV_INT_C_MV" "A1" GROUP BY GROUPING SETS (("A1"."CLNDR_MNTH_ID"
, "A1"."ORG_RGN_ID"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_CLASS_ID"
, "A1"."ITM_TYP")
, ("A1"."CLNDR_MNTH_ID"
, "A1"."ORG_CHAIN_ID"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ITEM_CLASS_ID"
, "A1"."ITM_TYP"))