VIEW: APPS.DDR_BS_INV_SKU_BU_DAY_MV#

Source

View Text - Preformatted

select                   
  inv.MFG_ORG_CD,
  inv.RTL_ORG_CD,
  inv.ORG_BSNS_UNIT_ID,
  inv.ITM_TYP,
  inv.GLBL_ITEM_ID,
  inv.GLBL_ITEM_ID_TYP,
  inv.MFG_SKU_ITEM_ID,
  inv.RTL_SKU_ITEM_ID,
  inv.DAY_CD,
  count(*) as CNT_TOTAL,
  sum(inv.ON_HAND_QTY_PRMRY) as ON_HAND_QTY_PRMRY,
  sum(inv.ON_HAND_QTY_ALT) as ON_HAND_QTY_ALT,
  sum(inv.RECVD_QTY_PRMRY) as RECVD_QTY_PRMRY,
  sum(inv.RECVD_QTY_ALT) as RECVD_QTY_ALT,
  sum(inv.IN_TRANSIT_QTY_PRMRY) as IN_TRANSIT_QTY_PRMRY,
  sum(inv.IN_TRANSIT_QTY_ALT) as IN_TRANSIT_QTY_ALT,
  sum(inv.BCK_ORDR_QTY_PRMRY) as BCK_ORDR_QTY_PRMRY,
  sum(inv.BCK_ORDR_QTY_ALT) as BCK_ORDR_QTY_ALT,
  sum(inv.QLTY_HOLD_QTY_PRMRY) as QLTY_HOLD_QTY_PRMRY,
  sum(inv.QLTY_HOLD_QTY_ALT) as QLTY_HOLD_QTY_ALT,
  sum(inv.ON_HAND_NET_COST_AMT) as ON_HAND_NET_COST_AMT,
  sum(inv.ON_HAND_NET_COST_AMT_RPT) as ON_HAND_NET_COST_AMT_RPT,
  sum(inv.RECVD_NET_COST_AMT) as RECVD_NET_COST_AMT,
  sum(inv.RECVD_NET_COST_AMT_RPT) as RECVD_NET_COST_AMT_RPT,
  sum(inv.IN_TRANSIT_NET_COST_AMT) as IN_TRANSIT_NET_COST_AMT,
  sum(inv.IN_TRANSIT_NET_COST_AMT_RPT) as IN_TRANSIT_NET_COST_AMT_RPT,
  sum(inv.BCKORDR_NET_COST_AMT) as BCKORDR_NET_COST_AMT,
  sum(inv.BCKORDR_NET_COST_AMT_RPT) as BCKORDR_NET_COST_AMT_RPT,
  sum(inv.QLTY_HOLD_NET_COST_AMT) as QLTY_HOLD_NET_COST_AMT,
  sum(inv.QLTY_HOLD_NET_COST_AMT_RPT) as QLTY_HOLD_NET_COST_AMT_RPT,
  sum(inv.ON_HAND_RTL_AMT) as ON_HAND_RTL_AMT,
  sum(inv.ON_HAND_RTL_AMT_RPT) as ON_HAND_RTL_AMT_RPT,
  sum(inv.RECVD_RTL_AMT) as RECVD_RTL_AMT,
  sum(inv.RECVD_RTL_AMT_RPT) as RECVD_RTL_AMT_RPT,
  sum(inv.IN_TRANSIT_RTL_AMT) as IN_TRANSIT_RTL_AMT,
  sum(inv.IN_TRANSIT_RTL_AMT_RPT) as IN_TRANSIT_RTL_AMT_RPT,
  sum(inv.BCKORDR_RTL_AMT) as BCKORDR_RTL_AMT,
  sum(inv.BCKORDR_RTL_AMT_RPT) as BCKORDR_RTL_AMT_RPT,
  sum(inv.QLTY_HOLD_RTL_AMT) as QLTY_HOLD_RTL_AMT,
  sum(inv.QLTY_HOLD_RTL_AMT_RPT) as QLTY_HOLD_RTL_AMT_RPT,
  count(inv.ON_HAND_QTY_PRMRY) as CNT_ON_HAND_QTY_PRMRY,
  count(inv.ON_HAND_QTY_ALT) as CNT_ON_HAND_QTY_ALT,
  count(inv.RECVD_QTY_PRMRY) as CNT_RECVD_QTY_PRMRY,
  count(inv.RECVD_QTY_ALT) as CNT_RECVD_QTY_ALT,
  count(inv.IN_TRANSIT_QTY_PRMRY) as CNT_IN_TRANSIT_QTY_PRMRY,
  count(inv.IN_TRANSIT_QTY_ALT) as CNT_IN_TRANSIT_QTY_ALT,
  count(inv.BCK_ORDR_QTY_PRMRY) as CNT_BCK_ORDR_QTY_PRMRY,
  count(inv.BCK_ORDR_QTY_ALT) as CNT_BCK_ORDR_QTY_ALT,
  count(inv.QLTY_HOLD_QTY_PRMRY) as CNT_QLTY_HOLD_QTY_PRMRY,
  count(inv.QLTY_HOLD_QTY_ALT) as CNT_QLTY_HOLD_QTY_ALT,
  count(inv.ON_HAND_NET_COST_AMT) as CNT_ON_HAND_NET_COST_AMT,
  count(inv.ON_HAND_NET_COST_AMT_RPT) as CNT_ON_HAND_NET_COST_AMT_RPT,
  count(inv.RECVD_NET_COST_AMT) as CNT_RECVD_NET_COST_AMT,
  count(inv.RECVD_NET_COST_AMT_RPT) as CNT_RECVD_NET_COST_AMT_RPT,
  count(inv.IN_TRANSIT_NET_COST_AMT) as CNT_IN_TRANSIT_NET_COST_AMT,
  count(inv.IN_TRANSIT_NET_COST_AMT_RPT) as CNT_IN_TRANSIT_NET_CST_AMT_RPT,
  count(inv.BCKORDR_NET_COST_AMT) as CNT_BCKORDR_NET_COST_AMT,
  count(inv.BCKORDR_NET_COST_AMT_RPT) as CNT_BCKORDR_NET_COST_AMT_RPT,
  count(inv.QLTY_HOLD_NET_COST_AMT) as CNT_QLTY_HOLD_NET_COST_AMT,
  count(inv.QLTY_HOLD_NET_COST_AMT_RPT) as CNT_QLTY_HOLD_NET_COST_AMT_RPT,
  count(inv.ON_HAND_RTL_AMT) as CNT_ON_HAND_RTL_AMT,
  count(inv.ON_HAND_RTL_AMT_RPT) as CNT_ON_HAND_RTL_AMT_RPT,
  count(inv.RECVD_RTL_AMT) as CNT_RECVD_RTL_AMT,
  count(inv.RECVD_RTL_AMT_RPT) as CNT_RECVD_RTL_AMT_RPT,
  count(inv.IN_TRANSIT_RTL_AMT) as CNT_IN_TRANSIT_RTL_AMT,
  count(inv.IN_TRANSIT_RTL_AMT_RPT) as CNT_IN_TRANSIT_RTL_AMT_RPT,
  count(inv.BCKORDR_RTL_AMT) as CNT_BCKORDR_RTL_AMT,
  count(inv.BCKORDR_RTL_AMT_RPT) as CNT_BCKORDR_RTL_AMT_RPT,
  count(inv.QLTY_HOLD_RTL_AMT) as CNT_QLTY_HOLD_RTL_AMT,
  count(inv.QLTY_HOLD_RTL_AMT_RPT) as CNT_QLTY_HOLD_RTL_AMT_RPT
from ddr_b_rtl_inv_item_day        inv
group by inv.MFG_ORG_CD
,        inv.RTL_ORG_CD
,        inv.ORG_BSNS_UNIT_ID
,        inv.ITM_TYP
,        inv.GLBL_ITEM_ID
,        inv.GLBL_ITEM_ID_TYP
,        inv.MFG_SKU_ITEM_ID
,        inv.RTL_SKU_ITEM_ID
,        inv.DAY_CD

View Text - HTML Formatted

SELECT INV.MFG_ORG_CD
, INV.RTL_ORG_CD
, INV.ORG_BSNS_UNIT_ID
, INV.ITM_TYP
, INV.GLBL_ITEM_ID
, INV.GLBL_ITEM_ID_TYP
, INV.MFG_SKU_ITEM_ID
, INV.RTL_SKU_ITEM_ID
, INV.DAY_CD
, COUNT(*) AS CNT_TOTAL
, SUM(INV.ON_HAND_QTY_PRMRY) AS ON_HAND_QTY_PRMRY
, SUM(INV.ON_HAND_QTY_ALT) AS ON_HAND_QTY_ALT
, SUM(INV.RECVD_QTY_PRMRY) AS RECVD_QTY_PRMRY
, SUM(INV.RECVD_QTY_ALT) AS RECVD_QTY_ALT
, SUM(INV.IN_TRANSIT_QTY_PRMRY) AS IN_TRANSIT_QTY_PRMRY
, SUM(INV.IN_TRANSIT_QTY_ALT) AS IN_TRANSIT_QTY_ALT
, SUM(INV.BCK_ORDR_QTY_PRMRY) AS BCK_ORDR_QTY_PRMRY
, SUM(INV.BCK_ORDR_QTY_ALT) AS BCK_ORDR_QTY_ALT
, SUM(INV.QLTY_HOLD_QTY_PRMRY) AS QLTY_HOLD_QTY_PRMRY
, SUM(INV.QLTY_HOLD_QTY_ALT) AS QLTY_HOLD_QTY_ALT
, SUM(INV.ON_HAND_NET_COST_AMT) AS ON_HAND_NET_COST_AMT
, SUM(INV.ON_HAND_NET_COST_AMT_RPT) AS ON_HAND_NET_COST_AMT_RPT
, SUM(INV.RECVD_NET_COST_AMT) AS RECVD_NET_COST_AMT
, SUM(INV.RECVD_NET_COST_AMT_RPT) AS RECVD_NET_COST_AMT_RPT
, SUM(INV.IN_TRANSIT_NET_COST_AMT) AS IN_TRANSIT_NET_COST_AMT
, SUM(INV.IN_TRANSIT_NET_COST_AMT_RPT) AS IN_TRANSIT_NET_COST_AMT_RPT
, SUM(INV.BCKORDR_NET_COST_AMT) AS BCKORDR_NET_COST_AMT
, SUM(INV.BCKORDR_NET_COST_AMT_RPT) AS BCKORDR_NET_COST_AMT_RPT
, SUM(INV.QLTY_HOLD_NET_COST_AMT) AS QLTY_HOLD_NET_COST_AMT
, SUM(INV.QLTY_HOLD_NET_COST_AMT_RPT) AS QLTY_HOLD_NET_COST_AMT_RPT
, SUM(INV.ON_HAND_RTL_AMT) AS ON_HAND_RTL_AMT
, SUM(INV.ON_HAND_RTL_AMT_RPT) AS ON_HAND_RTL_AMT_RPT
, SUM(INV.RECVD_RTL_AMT) AS RECVD_RTL_AMT
, SUM(INV.RECVD_RTL_AMT_RPT) AS RECVD_RTL_AMT_RPT
, SUM(INV.IN_TRANSIT_RTL_AMT) AS IN_TRANSIT_RTL_AMT
, SUM(INV.IN_TRANSIT_RTL_AMT_RPT) AS IN_TRANSIT_RTL_AMT_RPT
, SUM(INV.BCKORDR_RTL_AMT) AS BCKORDR_RTL_AMT
, SUM(INV.BCKORDR_RTL_AMT_RPT) AS BCKORDR_RTL_AMT_RPT
, SUM(INV.QLTY_HOLD_RTL_AMT) AS QLTY_HOLD_RTL_AMT
, SUM(INV.QLTY_HOLD_RTL_AMT_RPT) AS QLTY_HOLD_RTL_AMT_RPT
, COUNT(INV.ON_HAND_QTY_PRMRY) AS CNT_ON_HAND_QTY_PRMRY
, COUNT(INV.ON_HAND_QTY_ALT) AS CNT_ON_HAND_QTY_ALT
, COUNT(INV.RECVD_QTY_PRMRY) AS CNT_RECVD_QTY_PRMRY
, COUNT(INV.RECVD_QTY_ALT) AS CNT_RECVD_QTY_ALT
, COUNT(INV.IN_TRANSIT_QTY_PRMRY) AS CNT_IN_TRANSIT_QTY_PRMRY
, COUNT(INV.IN_TRANSIT_QTY_ALT) AS CNT_IN_TRANSIT_QTY_ALT
, COUNT(INV.BCK_ORDR_QTY_PRMRY) AS CNT_BCK_ORDR_QTY_PRMRY
, COUNT(INV.BCK_ORDR_QTY_ALT) AS CNT_BCK_ORDR_QTY_ALT
, COUNT(INV.QLTY_HOLD_QTY_PRMRY) AS CNT_QLTY_HOLD_QTY_PRMRY
, COUNT(INV.QLTY_HOLD_QTY_ALT) AS CNT_QLTY_HOLD_QTY_ALT
, COUNT(INV.ON_HAND_NET_COST_AMT) AS CNT_ON_HAND_NET_COST_AMT
, COUNT(INV.ON_HAND_NET_COST_AMT_RPT) AS CNT_ON_HAND_NET_COST_AMT_RPT
, COUNT(INV.RECVD_NET_COST_AMT) AS CNT_RECVD_NET_COST_AMT
, COUNT(INV.RECVD_NET_COST_AMT_RPT) AS CNT_RECVD_NET_COST_AMT_RPT
, COUNT(INV.IN_TRANSIT_NET_COST_AMT) AS CNT_IN_TRANSIT_NET_COST_AMT
, COUNT(INV.IN_TRANSIT_NET_COST_AMT_RPT) AS CNT_IN_TRANSIT_NET_CST_AMT_RPT
, COUNT(INV.BCKORDR_NET_COST_AMT) AS CNT_BCKORDR_NET_COST_AMT
, COUNT(INV.BCKORDR_NET_COST_AMT_RPT) AS CNT_BCKORDR_NET_COST_AMT_RPT
, COUNT(INV.QLTY_HOLD_NET_COST_AMT) AS CNT_QLTY_HOLD_NET_COST_AMT
, COUNT(INV.QLTY_HOLD_NET_COST_AMT_RPT) AS CNT_QLTY_HOLD_NET_COST_AMT_RPT
, COUNT(INV.ON_HAND_RTL_AMT) AS CNT_ON_HAND_RTL_AMT
, COUNT(INV.ON_HAND_RTL_AMT_RPT) AS CNT_ON_HAND_RTL_AMT_RPT
, COUNT(INV.RECVD_RTL_AMT) AS CNT_RECVD_RTL_AMT
, COUNT(INV.RECVD_RTL_AMT_RPT) AS CNT_RECVD_RTL_AMT_RPT
, COUNT(INV.IN_TRANSIT_RTL_AMT) AS CNT_IN_TRANSIT_RTL_AMT
, COUNT(INV.IN_TRANSIT_RTL_AMT_RPT) AS CNT_IN_TRANSIT_RTL_AMT_RPT
, COUNT(INV.BCKORDR_RTL_AMT) AS CNT_BCKORDR_RTL_AMT
, COUNT(INV.BCKORDR_RTL_AMT_RPT) AS CNT_BCKORDR_RTL_AMT_RPT
, COUNT(INV.QLTY_HOLD_RTL_AMT) AS CNT_QLTY_HOLD_RTL_AMT
, COUNT(INV.QLTY_HOLD_RTL_AMT_RPT) AS CNT_QLTY_HOLD_RTL_AMT_RPT FROM DDR_B_RTL_INV_ITEM_DAY INV GROUP BY INV.MFG_ORG_CD
, INV.RTL_ORG_CD
, INV.ORG_BSNS_UNIT_ID
, INV.ITM_TYP
, INV.GLBL_ITEM_ID
, INV.GLBL_ITEM_ID_TYP
, INV.MFG_SKU_ITEM_ID
, INV.RTL_SKU_ITEM_ID
, INV.DAY_CD