[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_R_ORG_CHN_DN_MV
Source
select c.ROWID CHAIN_ROWID
, o.ROWID ORG_ROWID
, c.MFG_ORG_CD
, o.ORG_CD
, o.ORG_TYP
, o.ORG_NAME
, c.ORG_CHAIN_ID
, c.CHAIN_CD
, c.CHAIN_NAME
, c.CHAIN_MGR_NAME
from DDR_R_ORG_CHAIN c
, DDR_R_ORG o
where c.ORG_CD = o.ORG_CD