[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_R_RTL_ITEM_GRP_DN_MV
Source
select grp.ROWID GRP_ROWID
, div.ROWID DIV_ROWID
, org.ROWID ORG_ROWID
, grp.MFG_ORG_CD
, org.ORG_NAME
, org.ORG_CD
, 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
from DDR_R_RTL_ITEM_GRP grp
, DDR_R_RTL_ITEM_DIV div
, DDR_R_ORG org
where grp.RTL_ITEM_DIV_ID = div.RTL_ITEM_DIV_ID
and org.ORG_CD = div.RTL_ORG_CD