[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_R_ORG_DSTRCT_DN_MV
Source
select d.ROWID DSTRCT_ROWID
, r.ROWID RGN_ROWID
, a.ROWID AREA_ROWID
, c.ROWID CHAIN_ROWID
, o.ROWID ORG_ROWID
, d.MFG_ORG_CD
, o.ORG_CD
, o.ORG_TYP
, o.ORG_NAME
, 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_DSTRCT d
, DDR_R_ORG_RGN r
, DDR_R_ORG_AREA a
, DDR_R_ORG_CHAIN c
, DDR_R_ORG o
where 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