select bu.ROWID BU_DN_ROWID
, ma.ROWID MKT_AREA_ROWID
, bu.MFG_ORG_CD
, bu.ORG_CD
, bu.ORG_TYP
, bu.ORG_NAME
, bu.ORG_BSNS_UNIT_ID
, bu.BSNS_UNIT_CD
, bu.BSNS_UNIT_NAME
, bu.BSNS_UNIT_TYP
, bu.CHNL_TYP_CD
, bu.CHNL_TYP_DESC
, bu.STORE_MGR
, bu.STORE_OPEN_DT
, bu.STORE_CLOSE_DT
, bu.STORE_TYP
, bu.NEW_STORE_IND
, bu.GLBL_LOC_ID
, bu.GLBL_LOC_ID_TYP
, bu.BSNS_UNIT_CNCPT
, bu.MKT_AREA_ID_1 AS MKT_AREA_ID
, bu.MKT_AREA_CD_1 AS MKT_AREA_CD
, bu.MKT_AREA_TYP_1 AS MKT_AREA_TYP
, ma.MKT_AREA_NAME
, ma.MKT_AREA_DESC
, bu.ORG_DSTRCT_ID
, bu.DSTRCT_CD
, bu.DSTRCT_NAME
, bu.DSTRCT_MGR_NAME
, bu.ORG_RGN_ID
, bu.RGN_CD
, bu.RGN_NAME
, bu.RGN_MGR_NAME
, bu.ORG_AREA_ID
, bu.AREA_CD
, bu.AREA_NAME
, bu.AREA_MGR_NAME
, bu.ORG_CHAIN_ID
, bu.CHAIN_CD
, bu.CHAIN_NAME
, bu.CHAIN_MGR_NAME
, bu.GEO_SUB_RGN_ID
, bu.STORE_VOL
, decode(bu.BSNS_UNIT_TYP , 'RTLSTORE',1,0) NO_OF_RTL_STORES
from DDR_R_ORG_BU_CHNLTYP_DN_MV bu
, DDR_R_MKT_AREA ma
where bu.MFG_ORG_CD = ma.MFG_ORG_CD (+)
and bu.MKT_AREA_ID_1 = ma.MKT_AREA_ID (+)
SELECT BU.ROWID BU_DN_ROWID
, MA.ROWID MKT_AREA_ROWID
, BU.MFG_ORG_CD
, BU.ORG_CD
, BU.ORG_TYP
, BU.ORG_NAME
, BU.ORG_BSNS_UNIT_ID
, BU.BSNS_UNIT_CD
, BU.BSNS_UNIT_NAME
, BU.BSNS_UNIT_TYP
, BU.CHNL_TYP_CD
, BU.CHNL_TYP_DESC
, BU.STORE_MGR
, BU.STORE_OPEN_DT
, BU.STORE_CLOSE_DT
, BU.STORE_TYP
, BU.NEW_STORE_IND
, BU.GLBL_LOC_ID
, BU.GLBL_LOC_ID_TYP
, BU.BSNS_UNIT_CNCPT
, BU.MKT_AREA_ID_1 AS MKT_AREA_ID
, BU.MKT_AREA_CD_1 AS MKT_AREA_CD
, BU.MKT_AREA_TYP_1 AS MKT_AREA_TYP
, MA.MKT_AREA_NAME
, MA.MKT_AREA_DESC
, BU.ORG_DSTRCT_ID
, BU.DSTRCT_CD
, BU.DSTRCT_NAME
, BU.DSTRCT_MGR_NAME
, BU.ORG_RGN_ID
, BU.RGN_CD
, BU.RGN_NAME
, BU.RGN_MGR_NAME
, BU.ORG_AREA_ID
, BU.AREA_CD
, BU.AREA_NAME
, BU.AREA_MGR_NAME
, BU.ORG_CHAIN_ID
, BU.CHAIN_CD
, BU.CHAIN_NAME
, BU.CHAIN_MGR_NAME
, BU.GEO_SUB_RGN_ID
, BU.STORE_VOL
, DECODE(BU.BSNS_UNIT_TYP
, 'RTLSTORE'
, 1
, 0) NO_OF_RTL_STORES
FROM DDR_R_ORG_BU_CHNLTYP_DN_MV BU
, DDR_R_MKT_AREA MA
WHERE BU.MFG_ORG_CD = MA.MFG_ORG_CD (+)
AND BU.MKT_AREA_ID_1 = MA.MKT_AREA_ID (+)
|
|
|