select itm.ROWID ITM_ROWID
, sbc.ROWID SBC_ROWID
, cls.ROWID CLS_ROWID
, grp.ROWID GRP_ROWID
, div.ROWID DIV_ROWID
, org.ROWID ORG_ROWID
, lkp.ROWID LKUP_ROWID
, itm.MFG_ORG_CD
, org.ORG_NAME as MFG_ORG_NAME
, itm.ORG_CD
, itm.MFG_ITEM_ID
, itm.MFG_ITEM_NAME
, itm.MFG_ITEM_NBR
, itm.MFG_BRND_CD
, itm.MFG_ITEM_DESC
, itm.MFG_ITEM_SHORT_DESC
, itm.MFG_ITEM_SCND_DESC
, itm.STORE_REORDRBL_IND
, lkp.BRND_NAME
, lkp.BRND_DESC
, sbc.MFG_ITEM_SBC_ID
, sbc.MFG_SBC_CD
, sbc.MFG_SBC_NAME
, cls.MFG_ITEM_CLASS_ID
, cls.MFG_CLASS_CD
, cls.MFG_CLASS_NAME
, grp.MFG_ITEM_GRP_ID
, grp.MFG_GRP_CD
, grp.MFG_GRP_NAME
, div.MFG_ITEM_DIV_ID
, div.MFG_DIV_CD
, div.MFG_DIV_NAME
, div.MFG_ITEM_CMPNY_ID
, itm.attribute1
, itm.attribute2
, itm.attribute3
from DDR_R_MFG_ITEM itm
, DDR_R_MFG_ITEM_SBC sbc
, DDR_R_MFG_ITEM_CLASS cls
, DDR_R_MFG_ITEM_GRP grp
, DDR_R_MFG_ITEM_DIV div
, DDR_R_ORG org
, DDR_L_BRND lkp
where itm.MFG_ITEM_SBC_ID = sbc.MFG_ITEM_SBC_ID
and sbc.MFG_ITEM_CLASS_ID = cls.MFG_ITEM_CLASS_ID
and cls.MFG_ITEM_GRP_ID = grp.MFG_ITEM_GRP_ID
and grp.MFG_ITEM_DIV_ID = div.MFG_ITEM_DIV_ID
and org.ORG_CD = itm.MFG_ORG_CD
and itm.MFG_ORG_CD = lkp.MFG_ORG_CD (+)
and itm.MFG_BRND_CD = lkp.BRND_CD (+)
SELECT ITM.ROWID ITM_ROWID
, SBC.ROWID SBC_ROWID
, CLS.ROWID CLS_ROWID
, GRP.ROWID GRP_ROWID
, DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, LKP.ROWID LKUP_ROWID
, ITM.MFG_ORG_CD
, ORG.ORG_NAME AS MFG_ORG_NAME
, ITM.ORG_CD
, ITM.MFG_ITEM_ID
, ITM.MFG_ITEM_NAME
, ITM.MFG_ITEM_NBR
, ITM.MFG_BRND_CD
, ITM.MFG_ITEM_DESC
, ITM.MFG_ITEM_SHORT_DESC
, ITM.MFG_ITEM_SCND_DESC
, ITM.STORE_REORDRBL_IND
, LKP.BRND_NAME
, LKP.BRND_DESC
, SBC.MFG_ITEM_SBC_ID
, SBC.MFG_SBC_CD
, SBC.MFG_SBC_NAME
, CLS.MFG_ITEM_CLASS_ID
, CLS.MFG_CLASS_CD
, CLS.MFG_CLASS_NAME
, GRP.MFG_ITEM_GRP_ID
, GRP.MFG_GRP_CD
, GRP.MFG_GRP_NAME
, DIV.MFG_ITEM_DIV_ID
, DIV.MFG_DIV_CD
, DIV.MFG_DIV_NAME
, DIV.MFG_ITEM_CMPNY_ID
, ITM.ATTRIBUTE1
, ITM.ATTRIBUTE2
, ITM.ATTRIBUTE3
FROM DDR_R_MFG_ITEM ITM
, DDR_R_MFG_ITEM_SBC SBC
, DDR_R_MFG_ITEM_CLASS CLS
, DDR_R_MFG_ITEM_GRP GRP
, DDR_R_MFG_ITEM_DIV DIV
, DDR_R_ORG ORG
, DDR_L_BRND LKP
WHERE ITM.MFG_ITEM_SBC_ID = SBC.MFG_ITEM_SBC_ID
AND SBC.MFG_ITEM_CLASS_ID = CLS.MFG_ITEM_CLASS_ID
AND CLS.MFG_ITEM_GRP_ID = GRP.MFG_ITEM_GRP_ID
AND GRP.MFG_ITEM_DIV_ID = DIV.MFG_ITEM_DIV_ID
AND ORG.ORG_CD = ITM.MFG_ORG_CD
AND ITM.MFG_ORG_CD = LKP.MFG_ORG_CD (+)
AND ITM.MFG_BRND_CD = LKP.BRND_CD (+)
|
|
|