select bu.ROWID BU_ROWID
, d.ROWID DSTRCT_ROWID
, r.ROWID RGN_ROWID
, a.ROWID AREA_ROWID
, c.ROWID CHAIN_ROWID
, o.ROWID ORG_ROWID
, l.ROWID LKUP_MST_ROWID
, bu.MFG_ORG_CD
, o.ORG_CD
, o.ORG_TYP
, o.ORG_NAME
, bu.ORG_BSNS_UNIT_ID
, bu.BSNS_UNIT_CD
, bu.BSNS_UNIT_NAME
, bu.CHNL_TYP_CD
, l.CHNL_TYP_DESC
, bu.MKT_AREA_ID_1
, bu.MKT_AREA_CD_1
, bu.MKT_AREA_TYP_1
, 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.GEO_SUB_RGN_ID
, bu.STORE_VOL
, bu.BSNS_UNIT_TYP
, d.ORG_DSTRCT_ID
, d.DSTRCT_CD
, d.DSTRCT_NAME
, d.DSTRCT_MGR_NAME
, r.ORG_RGN_ID
, r.RGN_CD
, r.RGN_NAME
, r.RGN_MGR_NAME
, a.ORG_AREA_ID
, a.AREA_CD
, a.AREA_NAME
, a.AREA_MGR_NAME
, c.ORG_CHAIN_ID
, c.CHAIN_CD
, c.CHAIN_NAME
, c.CHAIN_MGR_NAME
from DDR_R_ORG_BSNS_UNIT bu
, DDR_R_ORG_DSTRCT d
, DDR_R_ORG_RGN r
, DDR_R_ORG_AREA a
, DDR_R_ORG_CHAIN c
, DDR_R_ORG o
, DDR_L_CHNL_TYP l
where bu.ORG_DSTRCT_ID = d.ORG_DSTRCT_ID
and d.ORG_RGN_ID = r.ORG_RGN_ID
and r.ORG_AREA_ID = a.ORG_AREA_ID
and a.ORG_CHAIN_ID = c.ORG_CHAIN_ID
and c.ORG_CD = o.ORG_CD
and bu.MFG_ORG_CD = l.MFG_ORG_CD (+)
and bu.CHNL_TYP_CD = l.CHNL_TYP_CD (+)
SELECT BU.ROWID BU_ROWID
, D.ROWID DSTRCT_ROWID
, R.ROWID RGN_ROWID
, A.ROWID AREA_ROWID
, C.ROWID CHAIN_ROWID
, O.ROWID ORG_ROWID
, L.ROWID LKUP_MST_ROWID
, BU.MFG_ORG_CD
, O.ORG_CD
, O.ORG_TYP
, O.ORG_NAME
, BU.ORG_BSNS_UNIT_ID
, BU.BSNS_UNIT_CD
, BU.BSNS_UNIT_NAME
, BU.CHNL_TYP_CD
, L.CHNL_TYP_DESC
, BU.MKT_AREA_ID_1
, BU.MKT_AREA_CD_1
, BU.MKT_AREA_TYP_1
, 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.GEO_SUB_RGN_ID
, BU.STORE_VOL
, BU.BSNS_UNIT_TYP
, D.ORG_DSTRCT_ID
, D.DSTRCT_CD
, D.DSTRCT_NAME
, D.DSTRCT_MGR_NAME
, R.ORG_RGN_ID
, R.RGN_CD
, R.RGN_NAME
, R.RGN_MGR_NAME
, A.ORG_AREA_ID
, A.AREA_CD
, A.AREA_NAME
, A.AREA_MGR_NAME
, C.ORG_CHAIN_ID
, C.CHAIN_CD
, C.CHAIN_NAME
, C.CHAIN_MGR_NAME
FROM DDR_R_ORG_BSNS_UNIT BU
, DDR_R_ORG_DSTRCT D
, DDR_R_ORG_RGN R
, DDR_R_ORG_AREA A
, DDR_R_ORG_CHAIN C
, DDR_R_ORG O
, DDR_L_CHNL_TYP L
WHERE BU.ORG_DSTRCT_ID = D.ORG_DSTRCT_ID
AND D.ORG_RGN_ID = R.ORG_RGN_ID
AND R.ORG_AREA_ID = A.ORG_AREA_ID
AND A.ORG_CHAIN_ID = C.ORG_CHAIN_ID
AND C.ORG_CD = O.ORG_CD
AND BU.MFG_ORG_CD = L.MFG_ORG_CD (+)
AND BU.CHNL_TYP_CD = L.CHNL_TYP_CD (+)
|
|
|