[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_R_MFG_ITEM_SBC_DN_MV
Source
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
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