select a.ROWID AREA_ROWID
, c.ROWID CHAIN_ROWID
, o.ROWID ORG_ROWID
, a.MFG_ORG_CD
, o.ORG_CD
, o.ORG_TYP
, o.ORG_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
, a.attribute1
, a.attribute2
, a.attribute3
from DDR_R_ORG_AREA a
, DDR_R_ORG_CHAIN c
, DDR_R_ORG o
where a.ORG_CHAIN_ID = c.ORG_CHAIN_ID
and c.ORG_CD = o.ORG_CD
SELECT A.ROWID AREA_ROWID
, C.ROWID CHAIN_ROWID
, O.ROWID ORG_ROWID
, A.MFG_ORG_CD
, O.ORG_CD
, O.ORG_TYP
, O.ORG_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
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
FROM DDR_R_ORG_AREA A
, DDR_R_ORG_CHAIN C
, DDR_R_ORG O
WHERE A.ORG_CHAIN_ID = C.ORG_CHAIN_ID
AND C.ORG_CD = O.ORG_CD
|
|
|