VIEW: APPS.DDR_R_MFG_ITEM_SBC_DN_MV#

Source

View Text - Preformatted

select   sbc.ROWID SBC_ROWID
,        cls.ROWID CLS_ROWID
,        grp.ROWID GRP_ROWID
,        div.ROWID DIV_ROWID
,        org.ROWID ORG_ROWID
,        sbc.MFG_ORG_CD
,        org.ORG_NAME as MFG_ORG_NAME
,        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
,        sbc.attribute1
,        sbc.attribute2
,        sbc.attribute3
from     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
where   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 = div.MFG_ORG_CD

View Text - HTML Formatted

SELECT SBC.ROWID SBC_ROWID
, CLS.ROWID CLS_ROWID
, GRP.ROWID GRP_ROWID
, DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, SBC.MFG_ORG_CD
, ORG.ORG_NAME AS MFG_ORG_NAME
, 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
, SBC.ATTRIBUTE1
, SBC.ATTRIBUTE2
, SBC.ATTRIBUTE3 FROM 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 WHERE 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 = DIV.MFG_ORG_CD