select sbc.ROWID SBC_ROWID
, cls.ROWID CLS_ROWID
, dpt.ROWID DPT_ROWID
, grp.ROWID GRP_ROWID
, div.ROWID DIV_ROWID
, org.ROWID ORG_ROWID
, sbc.MFG_ORG_CD
, org.ORG_NAME
, org.ORG_CD
, sbc.RTL_ITEM_SBC_ID
, sbc.RTL_SBC_CD
, sbc.RTL_SBC_NAME
, cls.RTL_ITEM_CLASS_ID
, cls.RTL_CLASS_CD
, cls.RTL_CLASS_NAME
, dpt.RTL_ITEM_DEPT_ID
, dpt.RTL_DEPT_CD
, dpt.RTL_DEPT_NAME
, grp.RTL_ITEM_GRP_ID
, grp.RTL_GRP_CD
, grp.RTL_GRP_NAME
, div.RTL_ITEM_DIV_ID
, div.RTL_DIV_CD
, div.RTL_DIV_NAME
, div.RTL_ITEM_CMPNY_ID
, sbc.attribute1
, sbc.attribute2
, sbc.attribute3
from DDR_R_RTL_ITEM_SBC sbc
, DDR_R_RTL_ITEM_CLASS cls
, DDR_R_RTL_ITEM_DEPT dpt
, DDR_R_RTL_ITEM_GRP grp
, DDR_R_RTL_ITEM_DIV div
, DDR_R_ORG org
where sbc.RTL_ITEM_CLASS_ID = cls.RTL_ITEM_CLASS_ID
and cls.RTL_ITEM_DEPT_ID = dpt.RTL_ITEM_DEPT_ID
and dpt.RTL_ITEM_GRP_ID = grp.RTL_ITEM_GRP_ID
and grp.RTL_ITEM_DIV_ID = div.RTL_ITEM_DIV_ID
and org.ORG_CD = div.RTL_ORG_CD
SELECT SBC.ROWID SBC_ROWID
, CLS.ROWID CLS_ROWID
, DPT.ROWID DPT_ROWID
, GRP.ROWID GRP_ROWID
, DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, SBC.MFG_ORG_CD
, ORG.ORG_NAME
, ORG.ORG_CD
, SBC.RTL_ITEM_SBC_ID
, SBC.RTL_SBC_CD
, SBC.RTL_SBC_NAME
, CLS.RTL_ITEM_CLASS_ID
, CLS.RTL_CLASS_CD
, CLS.RTL_CLASS_NAME
, DPT.RTL_ITEM_DEPT_ID
, DPT.RTL_DEPT_CD
, DPT.RTL_DEPT_NAME
, GRP.RTL_ITEM_GRP_ID
, GRP.RTL_GRP_CD
, GRP.RTL_GRP_NAME
, DIV.RTL_ITEM_DIV_ID
, DIV.RTL_DIV_CD
, DIV.RTL_DIV_NAME
, DIV.RTL_ITEM_CMPNY_ID
, SBC.ATTRIBUTE1
, SBC.ATTRIBUTE2
, SBC.ATTRIBUTE3
FROM DDR_R_RTL_ITEM_SBC SBC
, DDR_R_RTL_ITEM_CLASS CLS
, DDR_R_RTL_ITEM_DEPT DPT
, DDR_R_RTL_ITEM_GRP GRP
, DDR_R_RTL_ITEM_DIV DIV
, DDR_R_ORG ORG
WHERE SBC.RTL_ITEM_CLASS_ID = CLS.RTL_ITEM_CLASS_ID
AND CLS.RTL_ITEM_DEPT_ID = DPT.RTL_ITEM_DEPT_ID
AND DPT.RTL_ITEM_GRP_ID = GRP.RTL_ITEM_GRP_ID
AND GRP.RTL_ITEM_DIV_ID = DIV.RTL_ITEM_DIV_ID
AND ORG.ORG_CD = DIV.RTL_ORG_CD
|
|
|