VIEW: APPS.DDR_SV_INV_INT_C_MV#

Source

View Text - Preformatted

SELECT "A7"."MFG_ORG_CD" "MFG_ORG_CD",
    "A7"."RTL_ORG_CD" "RTL_ORG_CD",
    "A7"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID",
    "A7"."ITM_TYP" "ITM_TYP",
    "A3"."ORG_RGN_ID" "ORG_RGN_ID",
    "A3"."ORG_CHAIN_ID" "ORG_CHAIN_ID",
    "A5"."MFG_ITEM_ID" "MFG_ITEM_ID",
    "A5"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID",
    "A4"."RTL_ITEM_ID" "RTL_ITEM_ID",
    "A4"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID",
    "A6"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID",
    COUNT(*) "CNT_TOTAL",
    COUNT(DECODE(SIGN("A7"."ON_HAND_QTY_PRMRY"),1,1,NULL)) "IN_STCK_BU_ITM_DAYS",
    COUNT(DECODE(SIGN("A7"."ON_HAND_QTY_PRMRY"-"A2"."MIN_STCK_ON_HAND_QTY_PRMRY"),(-1),1,NULL)) "UNDR_STCK_BU_ITM_DAYS",
    AVG("A7"."ON_HAND_QTY_PRMRY"              * "A6"."MNTH_TIMESPN" ) "ON_HAND_QTY_PRMRY",
    AVG("A7"."ON_HAND_QTY_ALT"                * "A6"."MNTH_TIMESPN" ) "ON_HAND_QTY_ALT",
    SUM(NVL("A7"."RECVD_QTY_PRMRY",0)) "RECVD_QTY_PRMRY",
    SUM(NVL("A7"."RECVD_QTY_ALT",0)) "RECVD_QTY_ALT",
    AVG("A7"."IN_TRANSIT_QTY_PRMRY"    * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_QTY_PRMRY",
    AVG("A7"."IN_TRANSIT_QTY_ALT"      * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_QTY_ALT",
    AVG("A7"."BCK_ORDR_QTY_PRMRY"      * "A6"."MNTH_TIMESPN" ) "BCK_ORDR_QTY_PRMRY",
    AVG("A7"."BCK_ORDR_QTY_ALT"        * "A6"."MNTH_TIMESPN" ) "BCK_ORDR_QTY_ALT",
    AVG("A7"."QLTY_HOLD_QTY_PRMRY"     * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_QTY_PRMRY",
    AVG("A7"."QLTY_HOLD_QTY_ALT"       * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_QTY_ALT",
    AVG("A7"."ON_HAND_NET_COST_AMT"    * "A6"."MNTH_TIMESPN" ) "ON_HAND_NET_COST_AMT",
    AVG("A7"."ON_HAND_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "ON_HAND_NET_COST_AMT_RPT",
    SUM(NVL("A7"."RECVD_NET_COST_AMT",0)) "RECVD_NET_COST_AMT",
    SUM(NVL("A7"."RECVD_NET_COST_AMT_RPT",0)) "RECVD_NET_COST_AMT_RPT",
    AVG("A7"."IN_TRANSIT_NET_COST_AMT"    * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_NET_COST_AMT",
    AVG("A7"."IN_TRANSIT_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_NET_COST_AMT_RPT",
    AVG("A7"."BCKORDR_NET_COST_AMT"       * "A6"."MNTH_TIMESPN" ) "BCKORDR_NET_COST_AMT",
    AVG("A7"."BCKORDR_NET_COST_AMT_RPT"   * "A6"."MNTH_TIMESPN" ) "BCKORDR_NET_COST_AMT_RPT",
    AVG("A7"."QLTY_HOLD_NET_COST_AMT"     * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_NET_COST_AMT",
    AVG("A7"."QLTY_HOLD_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_NET_COST_AMT_RPT",
    AVG("A7"."ON_HAND_RTL_AMT"            * "A6"."MNTH_TIMESPN" ) "ON_HAND_RTL_AMT",
    AVG("A7"."ON_HAND_RTL_AMT_RPT"        * "A6"."MNTH_TIMESPN" ) "ON_HAND_RTL_AMT_RPT",
    SUM(NVL("A7"."RECVD_RTL_AMT",0)) "RECVD_RTL_AMT",
    SUM(NVL("A7"."RECVD_RTL_AMT_RPT",0)) "RECVD_RTL_AMT_RPT",
    AVG("A7"."IN_TRANSIT_RTL_AMT"    * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_RTL_AMT",
    AVG("A7"."IN_TRANSIT_RTL_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_RTL_AMT_RPT",
    AVG("A7"."BCKORDR_RTL_AMT"       * "A6"."MNTH_TIMESPN" ) "BCKORDR_RTL_AMT",
    AVG("A7"."BCKORDR_RTL_AMT_RPT"   * "A6"."MNTH_TIMESPN" ) "BCKORDR_RTL_AMT_RPT",
    AVG("A7"."QLTY_HOLD_RTL_AMT"     * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_RTL_AMT",
    AVG("A7"."QLTY_HOLD_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_RTL_AMT_RPT",
    COUNT("A7"."ON_HAND_QTY_PRMRY"   * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_QTY_PRMRY",
    COUNT("A7"."ON_HAND_QTY_ALT"     * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_QTY_ALT",
    COUNT(NVL("A7"."RECVD_QTY_PRMRY",0)) "CNT_RECVD_QTY_PRMRY",
    COUNT(NVL("A7"."RECVD_QTY_ALT",0)) "CNT_RECVD_QTY_ALT",
    COUNT("A7"."IN_TRANSIT_QTY_PRMRY"    * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_QTY_PRMRY",
    COUNT("A7"."IN_TRANSIT_QTY_ALT"      * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_QTY_ALT",
    COUNT("A7"."BCK_ORDR_QTY_PRMRY"      * "A6"."MNTH_TIMESPN" ) "CNT_BCK_ORDR_QTY_PRMRY",
    COUNT("A7"."BCK_ORDR_QTY_ALT"        * "A6"."MNTH_TIMESPN" ) "CNT_BCK_ORDR_QTY_ALT",
    COUNT("A7"."QLTY_HOLD_QTY_PRMRY"     * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_QTY_PRMRY",
    COUNT("A7"."QLTY_HOLD_QTY_ALT"       * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_QTY_ALT",
    COUNT("A7"."ON_HAND_NET_COST_AMT"    * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_NET_COST_AMT",
    COUNT("A7"."ON_HAND_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_NET_COST_AMT_RPT",
    COUNT(NVL("A7"."RECVD_NET_COST_AMT",0)) "CNT_RECVD_NET_COST_AMT",
    COUNT(NVL("A7"."RECVD_NET_COST_AMT_RPT",0)) "CNT_RECVD_NET_COST_AMT_RPT",
    COUNT("A7"."IN_TRANSIT_NET_COST_AMT"    * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_NET_COST_AMT",
    COUNT("A7"."IN_TRANSIT_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_NET_CST_AMT_RPT",
    COUNT("A7"."BCKORDR_NET_COST_AMT"       * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_NET_COST_AMT",
    COUNT("A7"."BCKORDR_NET_COST_AMT_RPT"   * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_NET_COST_AMT_RPT",
    COUNT("A7"."QLTY_HOLD_NET_COST_AMT"     * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_NET_COST_AMT",
    COUNT("A7"."QLTY_HOLD_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_NET_COST_AMT_RPT",
    COUNT("A7"."ON_HAND_RTL_AMT"            * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_RTL_AMT",
    COUNT("A7"."ON_HAND_RTL_AMT_RPT"        * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_RTL_AMT_RPT",
    COUNT(NVL("A7"."RECVD_RTL_AMT",0)) "CNT_RECVD_RTL_AMT",
    COUNT(NVL("A7"."RECVD_RTL_AMT_RPT",0)) "CNT_RECVD_RTL_AMT_RPT",
    COUNT("A7"."IN_TRANSIT_RTL_AMT"    * "A6"."MNTH_TIMESPN") "CNT_IN_TRANSIT_RTL_AMT",
    COUNT("A7"."IN_TRANSIT_RTL_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_RTL_AMT_RPT",
    COUNT("A7"."BCKORDR_RTL_AMT"       * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_RTL_AMT",
    COUNT("A7"."BCKORDR_RTL_AMT_RPT"   * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_RTL_AMT_RPT",
    COUNT("A7"."QLTY_HOLD_RTL_AMT"     * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_RTL_AMT",
    COUNT("A7"."QLTY_HOLD_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_RTL_AMT_RPT"
  FROM "APPS"."DDR_BS_INV_SKU_BU_DAY_MV" "A7",
    "APPS"."DDR_R_CLNDR_DAY_DN_MV" "A6",
    "APPS"."DDR_R_MFG_ITEM_SKU_DN_MV" "A5",
    "APPS"."DDR_R_RTL_ITEM_SKU_DN_MV" "A4",
    "APPS"."DDR_R_ORG_BU_DN_MV" "A3",
    "APPS"."DDR_R_INV_RULE_DN_MV" "A2"
  WHERE "A6"."DAY_CD"   ="A7"."DAY_CD"
  AND "A6"."CLNDR_DESC" ="A7"."MFG_ORG_CD"
    ||'-CLNDR'
  AND "A5"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
  AND "A4"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
  AND "A3"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
  AND "A3"."ORG_CD"          ="A7"."RTL_ORG_CD"
  AND "A2"."RTL_ORG_CD"      ="A3"."ORG_CD"
  AND "A2"."BSNS_UNIT_CD"    ="A3"."BSNS_UNIT_CD"
  AND "A2"."GLBL_ITEM_ID"    ="A7"."GLBL_ITEM_ID"
  AND "A2"."GLBL_ITEM_ID_TYP"="A7"."GLBL_ITEM_ID_TYP"
  AND "A2"."RTL_SKU_ITEM_NBR"="A4"."RTL_SKU_ITEM_NBR"
  GROUP BY "A6"."CLNDR_MNTH_ID",
    "A3"."ORG_RGN_ID",
    "A5"."MFG_ITEM_CLASS_ID",
    "A4"."RTL_ITEM_CLASS_ID",
    "A7"."ITM_TYP",
    "A7"."ORG_BSNS_UNIT_ID",
    "A3"."ORG_CHAIN_ID",
    "A5"."MFG_ITEM_ID",
    "A7"."MFG_ORG_CD",
    "A4"."RTL_ITEM_ID",
    "A7"."RTL_ORG_CD"

View Text - HTML Formatted

SELECT "A7"."MFG_ORG_CD" "MFG_ORG_CD"
, "A7"."RTL_ORG_CD" "RTL_ORG_CD"
, "A7"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID"
, "A7"."ITM_TYP" "ITM_TYP"
, "A3"."ORG_RGN_ID" "ORG_RGN_ID"
, "A3"."ORG_CHAIN_ID" "ORG_CHAIN_ID"
, "A5"."MFG_ITEM_ID" "MFG_ITEM_ID"
, "A5"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID"
, "A4"."RTL_ITEM_ID" "RTL_ITEM_ID"
, "A4"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID"
, "A6"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID"
, COUNT(*) "CNT_TOTAL"
, COUNT(DECODE(SIGN("A7"."ON_HAND_QTY_PRMRY")
, 1
, 1
, NULL)) "IN_STCK_BU_ITM_DAYS"
, COUNT(DECODE(SIGN("A7"."ON_HAND_QTY_PRMRY"-"A2"."MIN_STCK_ON_HAND_QTY_PRMRY")
, (-1)
, 1
, NULL)) "UNDR_STCK_BU_ITM_DAYS"
, AVG("A7"."ON_HAND_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "ON_HAND_QTY_PRMRY"
, AVG("A7"."ON_HAND_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "ON_HAND_QTY_ALT"
, SUM(NVL("A7"."RECVD_QTY_PRMRY"
, 0)) "RECVD_QTY_PRMRY"
, SUM(NVL("A7"."RECVD_QTY_ALT"
, 0)) "RECVD_QTY_ALT"
, AVG("A7"."IN_TRANSIT_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_QTY_PRMRY"
, AVG("A7"."IN_TRANSIT_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_QTY_ALT"
, AVG("A7"."BCK_ORDR_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "BCK_ORDR_QTY_PRMRY"
, AVG("A7"."BCK_ORDR_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "BCK_ORDR_QTY_ALT"
, AVG("A7"."QLTY_HOLD_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_QTY_PRMRY"
, AVG("A7"."QLTY_HOLD_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_QTY_ALT"
, AVG("A7"."ON_HAND_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "ON_HAND_NET_COST_AMT"
, AVG("A7"."ON_HAND_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "ON_HAND_NET_COST_AMT_RPT"
, SUM(NVL("A7"."RECVD_NET_COST_AMT"
, 0)) "RECVD_NET_COST_AMT"
, SUM(NVL("A7"."RECVD_NET_COST_AMT_RPT"
, 0)) "RECVD_NET_COST_AMT_RPT"
, AVG("A7"."IN_TRANSIT_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_NET_COST_AMT"
, AVG("A7"."IN_TRANSIT_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_NET_COST_AMT_RPT"
, AVG("A7"."BCKORDR_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "BCKORDR_NET_COST_AMT"
, AVG("A7"."BCKORDR_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "BCKORDR_NET_COST_AMT_RPT"
, AVG("A7"."QLTY_HOLD_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_NET_COST_AMT"
, AVG("A7"."QLTY_HOLD_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_NET_COST_AMT_RPT"
, AVG("A7"."ON_HAND_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "ON_HAND_RTL_AMT"
, AVG("A7"."ON_HAND_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "ON_HAND_RTL_AMT_RPT"
, SUM(NVL("A7"."RECVD_RTL_AMT"
, 0)) "RECVD_RTL_AMT"
, SUM(NVL("A7"."RECVD_RTL_AMT_RPT"
, 0)) "RECVD_RTL_AMT_RPT"
, AVG("A7"."IN_TRANSIT_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_RTL_AMT"
, AVG("A7"."IN_TRANSIT_RTL_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "IN_TRANSIT_RTL_AMT_RPT"
, AVG("A7"."BCKORDR_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "BCKORDR_RTL_AMT"
, AVG("A7"."BCKORDR_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "BCKORDR_RTL_AMT_RPT"
, AVG("A7"."QLTY_HOLD_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_RTL_AMT"
, AVG("A7"."QLTY_HOLD_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "QLTY_HOLD_RTL_AMT_RPT"
, COUNT("A7"."ON_HAND_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_QTY_PRMRY"
, COUNT("A7"."ON_HAND_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_QTY_ALT"
, COUNT(NVL("A7"."RECVD_QTY_PRMRY"
, 0)) "CNT_RECVD_QTY_PRMRY"
, COUNT(NVL("A7"."RECVD_QTY_ALT"
, 0)) "CNT_RECVD_QTY_ALT"
, COUNT("A7"."IN_TRANSIT_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_QTY_PRMRY"
, COUNT("A7"."IN_TRANSIT_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_QTY_ALT"
, COUNT("A7"."BCK_ORDR_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "CNT_BCK_ORDR_QTY_PRMRY"
, COUNT("A7"."BCK_ORDR_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "CNT_BCK_ORDR_QTY_ALT"
, COUNT("A7"."QLTY_HOLD_QTY_PRMRY" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_QTY_PRMRY"
, COUNT("A7"."QLTY_HOLD_QTY_ALT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_QTY_ALT"
, COUNT("A7"."ON_HAND_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_NET_COST_AMT"
, COUNT("A7"."ON_HAND_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_NET_COST_AMT_RPT"
, COUNT(NVL("A7"."RECVD_NET_COST_AMT"
, 0)) "CNT_RECVD_NET_COST_AMT"
, COUNT(NVL("A7"."RECVD_NET_COST_AMT_RPT"
, 0)) "CNT_RECVD_NET_COST_AMT_RPT"
, COUNT("A7"."IN_TRANSIT_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_NET_COST_AMT"
, COUNT("A7"."IN_TRANSIT_NET_COST_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_NET_CST_AMT_RPT"
, COUNT("A7"."BCKORDR_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_NET_COST_AMT"
, COUNT("A7"."BCKORDR_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_NET_COST_AMT_RPT"
, COUNT("A7"."QLTY_HOLD_NET_COST_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_NET_COST_AMT"
, COUNT("A7"."QLTY_HOLD_NET_COST_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_NET_COST_AMT_RPT"
, COUNT("A7"."ON_HAND_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_RTL_AMT"
, COUNT("A7"."ON_HAND_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_ON_HAND_RTL_AMT_RPT"
, COUNT(NVL("A7"."RECVD_RTL_AMT"
, 0)) "CNT_RECVD_RTL_AMT"
, COUNT(NVL("A7"."RECVD_RTL_AMT_RPT"
, 0)) "CNT_RECVD_RTL_AMT_RPT"
, COUNT("A7"."IN_TRANSIT_RTL_AMT" * "A6"."MNTH_TIMESPN") "CNT_IN_TRANSIT_RTL_AMT"
, COUNT("A7"."IN_TRANSIT_RTL_AMT_RPT"* "A6"."MNTH_TIMESPN" ) "CNT_IN_TRANSIT_RTL_AMT_RPT"
, COUNT("A7"."BCKORDR_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_RTL_AMT"
, COUNT("A7"."BCKORDR_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_BCKORDR_RTL_AMT_RPT"
, COUNT("A7"."QLTY_HOLD_RTL_AMT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_RTL_AMT"
, COUNT("A7"."QLTY_HOLD_RTL_AMT_RPT" * "A6"."MNTH_TIMESPN" ) "CNT_QLTY_HOLD_RTL_AMT_RPT"
FROM "APPS"."DDR_BS_INV_SKU_BU_DAY_MV" "A7"
, "APPS"."DDR_R_CLNDR_DAY_DN_MV" "A6"
, "APPS"."DDR_R_MFG_ITEM_SKU_DN_MV" "A5"
, "APPS"."DDR_R_RTL_ITEM_SKU_DN_MV" "A4"
, "APPS"."DDR_R_ORG_BU_DN_MV" "A3"
, "APPS"."DDR_R_INV_RULE_DN_MV" "A2"
WHERE "A6"."DAY_CD" ="A7"."DAY_CD"
AND "A6"."CLNDR_DESC" ="A7"."MFG_ORG_CD" ||'-CLNDR'
AND "A5"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
AND "A4"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
AND "A3"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
AND "A3"."ORG_CD" ="A7"."RTL_ORG_CD"
AND "A2"."RTL_ORG_CD" ="A3"."ORG_CD"
AND "A2"."BSNS_UNIT_CD" ="A3"."BSNS_UNIT_CD"
AND "A2"."GLBL_ITEM_ID" ="A7"."GLBL_ITEM_ID"
AND "A2"."GLBL_ITEM_ID_TYP"="A7"."GLBL_ITEM_ID_TYP"
AND "A2"."RTL_SKU_ITEM_NBR"="A4"."RTL_SKU_ITEM_NBR" GROUP BY "A6"."CLNDR_MNTH_ID"
, "A3"."ORG_RGN_ID"
, "A5"."MFG_ITEM_CLASS_ID"
, "A4"."RTL_ITEM_CLASS_ID"
, "A7"."ITM_TYP"
, "A7"."ORG_BSNS_UNIT_ID"
, "A3"."ORG_CHAIN_ID"
, "A5"."MFG_ITEM_ID"
, "A7"."MFG_ORG_CD"
, "A4"."RTL_ITEM_ID"
, "A7"."RTL_ORG_CD"