select sku.ROWID SKU_ROWID
, itm.ROWID ITM_ROWID
, sbc.ROWID SBC_ROWID
, cls.ROWID CLS_ROWID
, dpt.ROWID DPT_ROWID
, grp.ROWID GRP_ROWID
, div.ROWID DIV_ROWID
, org.ROWID ORG_ROWID
, lkp.ROWID LKP_ROWID
, sku.MFG_ORG_CD
, org.ORG_NAME
, org.ORG_CD
, sku.RTL_SKU_ITEM_ID
, sku.RTL_SKU_ITEM_NBR
, sku.RTL_SKU_ITEM_NAME
, sku.GLBL_ITEM_ID
, sku.GLBL_ITEM_ID_TYP
, sku.UNIT_PRICE_FCTR
, sku.SZ_TYP_CD
, sku.STCK_ITEM_TYP_CD
, sku.STCK_ITEM_STYLE_CD
, sku.STCK_ITEM_DYE_CD
, sku.STCK_ITEM_COLOR_CD
, sku.STCK_ITEM_COATING_CD
, sku.STCK_ITEM_WEAVE_CD
, sku.STCK_ITEM_FABRIC_CD
, sku.STCK_ITEM_FIBER_CD
, sku.SU_LAST_RCVD_COST_ESTBL_DT
, sku.SU_LAST_RCVD_NET_COST_AMT
, sku.SU_LAST_RCVD_NET_COST_AMT_LCL
, sku.SU_LAST_RCVD_NET_COST_AMT_RPT
, sku.RTL_SKU_SLNG_PRC_ID
, sku.RTL_SKU_ITEM_TYP_CD
, sku.RTL_SKU_ITEM_INDSTRY_IDNT_CD
, sku.RTL_SKU_ITEM_SLNG_PRICE_NBR
, sku.RTL_SKU_ITEM_DESC
, sku.RTL_SKU_ITEM_LONG_DESC
, sku.RECALL_IND
, sku.PCK_SELLBL_CD
, sku.PCK_SMPL_CD
, sku.PCK_ORDRBL_CD
, sku.PCK_IND
, sku.PKG_SZ
, sku.PCK_SELLBL_DESC
, sku.PCK_SMPL_DESC
, sku.PCK_ORDRBL_DESC
, itm.RTL_ITEM_ID
, itm.RTL_ITEM_NBR
, itm.RTL_ITEM_NAME
, itm.RTL_BRND_CD
, itm.RTL_ITEM_SHORT_DESC
, itm.RTL_ITEM_SCND_DESC
, itm.RTL_ITEM_DESC
, lkp.BRND_NAME
, lkp.BRND_DESC
, sbc.RTL_ITEM_SBC_ID
, sbc.RTL_SBC_CD
, sbc.RTL_SBC_NAME
, 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
, nvl(sku.EFF_FROM_DT, to_date('01-JAN-1900')) as EFF_FROM_DT
, nvl(sku.EFF_TO_DT, to_date('31-DEC-9999')) as EFF_TO_DT
, sku.attribute1
, sku.attribute2
, sku.attribute3
from DDR_R_RTL_SKU_ITEM sku
, DDR_R_RTL_ITEM itm
, DDR_R_RTL_ITEM_SBC sbc
, 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
, DDR_L_BRND lkp
where sku.RTL_ITEM_ID = itm.RTL_ITEM_ID
and itm.RTL_ITEM_SBC_ID = sbc.RTL_ITEM_SBC_ID
and sbc.RTL_ITEM_CLASS_ID = cls.RTL_ITEM_CLASS_ID
and 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
and itm.MFG_ORG_CD = lkp.MFG_ORG_CD (+)
and itm.RTL_BRND_CD = lkp.BRND_CD (+)
SELECT SKU.ROWID SKU_ROWID
, ITM.ROWID ITM_ROWID
, SBC.ROWID SBC_ROWID
, CLS.ROWID CLS_ROWID
, DPT.ROWID DPT_ROWID
, GRP.ROWID GRP_ROWID
, DIV.ROWID DIV_ROWID
, ORG.ROWID ORG_ROWID
, LKP.ROWID LKP_ROWID
, SKU.MFG_ORG_CD
, ORG.ORG_NAME
, ORG.ORG_CD
, SKU.RTL_SKU_ITEM_ID
, SKU.RTL_SKU_ITEM_NBR
, SKU.RTL_SKU_ITEM_NAME
, SKU.GLBL_ITEM_ID
, SKU.GLBL_ITEM_ID_TYP
, SKU.UNIT_PRICE_FCTR
, SKU.SZ_TYP_CD
, SKU.STCK_ITEM_TYP_CD
, SKU.STCK_ITEM_STYLE_CD
, SKU.STCK_ITEM_DYE_CD
, SKU.STCK_ITEM_COLOR_CD
, SKU.STCK_ITEM_COATING_CD
, SKU.STCK_ITEM_WEAVE_CD
, SKU.STCK_ITEM_FABRIC_CD
, SKU.STCK_ITEM_FIBER_CD
, SKU.SU_LAST_RCVD_COST_ESTBL_DT
, SKU.SU_LAST_RCVD_NET_COST_AMT
, SKU.SU_LAST_RCVD_NET_COST_AMT_LCL
, SKU.SU_LAST_RCVD_NET_COST_AMT_RPT
, SKU.RTL_SKU_SLNG_PRC_ID
, SKU.RTL_SKU_ITEM_TYP_CD
, SKU.RTL_SKU_ITEM_INDSTRY_IDNT_CD
, SKU.RTL_SKU_ITEM_SLNG_PRICE_NBR
, SKU.RTL_SKU_ITEM_DESC
, SKU.RTL_SKU_ITEM_LONG_DESC
, SKU.RECALL_IND
, SKU.PCK_SELLBL_CD
, SKU.PCK_SMPL_CD
, SKU.PCK_ORDRBL_CD
, SKU.PCK_IND
, SKU.PKG_SZ
, SKU.PCK_SELLBL_DESC
, SKU.PCK_SMPL_DESC
, SKU.PCK_ORDRBL_DESC
, ITM.RTL_ITEM_ID
, ITM.RTL_ITEM_NBR
, ITM.RTL_ITEM_NAME
, ITM.RTL_BRND_CD
, ITM.RTL_ITEM_SHORT_DESC
, ITM.RTL_ITEM_SCND_DESC
, ITM.RTL_ITEM_DESC
, LKP.BRND_NAME
, LKP.BRND_DESC
, SBC.RTL_ITEM_SBC_ID
, SBC.RTL_SBC_CD
, SBC.RTL_SBC_NAME
, 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
, NVL(SKU.EFF_FROM_DT
, TO_DATE('01-JAN-1900')) AS EFF_FROM_DT
, NVL(SKU.EFF_TO_DT
, TO_DATE('31-DEC-9999')) AS EFF_TO_DT
, SKU.ATTRIBUTE1
, SKU.ATTRIBUTE2
, SKU.ATTRIBUTE3
FROM DDR_R_RTL_SKU_ITEM SKU
, DDR_R_RTL_ITEM ITM
, DDR_R_RTL_ITEM_SBC SBC
, 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
, DDR_L_BRND LKP
WHERE SKU.RTL_ITEM_ID = ITM.RTL_ITEM_ID
AND ITM.RTL_ITEM_SBC_ID = SBC.RTL_ITEM_SBC_ID
AND SBC.RTL_ITEM_CLASS_ID = CLS.RTL_ITEM_CLASS_ID
AND 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
AND ITM.MFG_ORG_CD = LKP.MFG_ORG_CD (+)
AND ITM.RTL_BRND_CD = LKP.BRND_CD (+)
|
|
|