select div.ROWID DIV_ROWID
, org.ROWID ORG_ROWID
, div.MFG_ORG_CD
, org.ORG_NAME as MFG_ORG_NAME
, div.MFG_ITEM_DIV_ID
, div.MFG_DIV_CD
, div.MFG_DIV_NAME
, div.MFG_ITEM_CMPNY_ID
, div.attribute1
, div.attribute2
, div.attribute3
from DDR_R_MFG_ITEM_DIV div
, DDR_R_ORG org
where org.ORG_CD = div.MFG_ORG_CD
SELECT DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, DIV.MFG_ORG_CD
, ORG.ORG_NAME AS MFG_ORG_NAME
, DIV.MFG_ITEM_DIV_ID
, DIV.MFG_DIV_CD
, DIV.MFG_DIV_NAME
, DIV.MFG_ITEM_CMPNY_ID
, DIV.ATTRIBUTE1
, DIV.ATTRIBUTE2
, DIV.ATTRIBUTE3
FROM DDR_R_MFG_ITEM_DIV DIV
, DDR_R_ORG ORG
WHERE ORG.ORG_CD = DIV.MFG_ORG_CD
|
|
|