----------------------------
Query  for "Result1"
----------------------------

SELECT
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_CO_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_DIV_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_NAME,
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_CDE,
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_NAME,
  EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.ECPR_EMP_CDE,
  EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.ECPR_EMP_FULL_NAME,
  EDM.D_EMP_HIER_V.PRNT_EMPMNT_STAT,
  sum(EDM.F_SLS_ITEM_V.SLS),
  sum(EDM.F_SLS_ITEM_V.QTY_ORD),
  sum(EDM.F_SLS_ITEM_V.QTY_SHIP)
FROM
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V,
  EDM.D_FIN_ORG_POSTING_V,
  EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V,
  EDM.D_EMP_HIER_V,
  EDM.F_SLS_ITEM_V,
  EDM.D_DATE_INVC_V,
  EDM.D_CUST_SHIP_TO_V
WHERE
  ( EDM.D_DATE_INVC_V.INVC_DATE = EDM.F_SLS_ITEM_V.INVC_DATE  )
  AND  ( EDM.D_CUST_SHIP_TO_V.CUST_SHIP_TO_KEY = EDM.F_SLS_ITEM_V.CUST_SHIP_TO_KEY  )
  AND  ( EDM.D_FIN_ORG_POSTING_V.FIN_ORG_POSTING_KEY = EDM.F_SLS_ITEM_V.FIN_POSTING_ORG_KEY  )
  AND  ( EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.SLS_REP_CUST_SHIP_TO_CURR_KEY=EDM.D_CUST_SHIP_TO_V.CURR_CUST_SHIP_TO_SLS_REP_KEY  )
  AND  ( EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.EMP_KEY=EDM.D_EMP_HIER_V.SUBSID_EMP_KEY  )
  AND  ( EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_CURR_EMP_KEY=EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.EMP_KEY  )
  AND  
  EDM.D_DATE_INVC_V.INVC_DATE  =  '02-06-2015 00:00:00'
GROUP BY
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_CDE, 
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_CO_CDE, 
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_DIV_CDE, 
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_NAME, 
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_CDE, 
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_NAME, 
  EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.ECPR_EMP_CDE, 
  EDM.D_EMP_SLS_REP_CUST_SHIP_TO_V.ECPR_EMP_FULL_NAME, 
  EDM.D_EMP_HIER_V.PRNT_EMPMNT_STAT


----------------------------
Query  for "Result2"
----------------------------

SELECT
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_CO_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_DIV_CDE,
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.CPR_SLS_REP_NAME,
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_CDE,
  EDM.D_FIN_ORG_POSTING_V.FOP_RANK_VIRT_SUB_LOC_NAME,
  SLS_REP_CUST_SHIP_TO_SLS_ORG.LVL_3_MGR_EMP_NBR,
  SLS_REP_CUST_SHIP_TO_SLS_ORG.LVL_3_MGR_NAME,
  SLS_REP_CUST_SHIP_TO_SLS_ORG.LEADER_NAME,
  SLS_REP_CUST_SHIP_TO_SLS_ORG.LEADER_POS_TITLE
FROM
  EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V,
  EDM.D_FIN_ORG_POSTING_V,
  EDM.B_SLS_REP_SLS_ORG_V  SLS_REP_CUST_SHIP_TO_SLS_ORG
WHERE
  ( EDM.D_SLS_REP_CUST_SHIP_TO_CURR_V.SLS_REP_CUST_SHIP_TO_CURR_KEY=SLS_REP_CUST_SHIP_TO_SLS_ORG.SLS_REP_KEY  )
  AND  ( EDM.D_FIN_ORG_POSTING_V.FIN_ORG_POSTING_KEY=SLS_REP_CUST_SHIP_TO_SLS_ORG.FIN_ORG_KEY  )