VIEW: APPS.DDR_R_RTL_ITEM_CLS_DN_MV#

Source

View Text - Preformatted

select   cls.ROWID CLS_ROWID
,        dpt.ROWID DPT_ROWID
,        grp.ROWID GRP_ROWID
,        div.ROWID DIV_ROWID
,        org.ROWID ORG_ROWID
,        cls.MFG_ORG_CD
,        org.ORG_NAME
,        org.ORG_CD
,        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
,        cls.attribute1
,        cls.attribute2
,        cls.attribute3
from     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   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

View Text - HTML Formatted

SELECT CLS.ROWID CLS_ROWID
, DPT.ROWID DPT_ROWID
, GRP.ROWID GRP_ROWID
, DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, CLS.MFG_ORG_CD
, ORG.ORG_NAME
, ORG.ORG_CD
, 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
, CLS.ATTRIBUTE1
, CLS.ATTRIBUTE2
, CLS.ATTRIBUTE3 FROM 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 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