eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_R_RTL_ITEM_SKU_DN_MV

Source


SELECT "A9".ROWID "SKU_ROWID","A8".ROWID "ITM_ROWID","A7".ROWID "SBC_ROWID","A6".ROWID "CLS_ROWID","A5".ROWID "DPT_ROWID","A4".ROWID "GRP_ROWID","A3".ROWID "DIV_ROWID","A2".ROWID "ORG_ROWID","A1".ROWID "LKP_ROWID","A9"."MFG_ORG_CD" "MFG_ORG_CD","A2"."ORG_NAME" "ORG_NAME","A2"."ORG_CD" "ORG_CD","A9"."RTL_SKU_ITEM_ID" "RTL_SKU_ITEM_ID","A9"."RTL_SKU_ITEM_NBR" "RTL_SKU_ITEM_NBR","A9"."RTL_SKU_ITEM_NAME" "RTL_SKU_ITEM_NAME","A9"."GLBL_ITEM_ID" "GLBL_ITEM_ID","A9"."GLBL_ITEM_ID_TYP" "GLBL_ITEM_ID_TYP","A9"."UNIT_PRICE_FCTR" "UNIT_PRICE_FCTR","A9"."SZ_TYP_CD" "SZ_TYP_CD","A9"."STCK_ITEM_TYP_CD" "STCK_ITEM_TYP_CD","A9"."STCK_ITEM_STYLE_CD" "STCK_ITEM_STYLE_CD","A9"."STCK_ITEM_DYE_CD" "STCK_ITEM_DYE_CD","A9"."STCK_ITEM_COLOR_CD" "STCK_ITEM_COLOR_CD","A9"."STCK_ITEM_COATING_CD" "STCK_ITEM_COATING_CD","A9"."STCK_ITEM_WEAVE_CD" "STCK_ITEM_WEAVE_CD","A9"."STCK_ITEM_FABRIC_CD" "STCK_ITEM_FABRIC_CD","A9"."STCK_ITEM_FIBER_CD" "STCK_ITEM_FIBER_CD","A9"."SU_LAST_RCVD_COST_ESTBL_DT" "SU_LAST_RCVD_COST_ESTBL_DT","A9"."SU_LAST_RCVD_NET_COST_AMT" "SU_LAST_RCVD_NET_COST_AMT","A9"."SU_LAST_RCVD_NET_COST_AMT_LCL" "SU_LAST_RCVD_NET_COST_AMT_LCL","A9"."SU_LAST_RCVD_NET_COST_AMT_RPT" "SU_LAST_RCVD_NET_COST_AMT_RPT","A9"."RTL_SKU_SLNG_PRC_ID" "RTL_SKU_SLNG_PRC_ID","A9"."RTL_SKU_ITEM_TYP_CD" "RTL_SKU_ITEM_TYP_CD","A9"."RTL_SKU_ITEM_INDSTRY_IDNT_CD" "RTL_SKU_ITEM_INDSTRY_IDNT_CD","A9"."RTL_SKU_ITEM_SLNG_PRICE_NBR" "RTL_SKU_ITEM_SLNG_PRICE_NBR","A9"."RTL_SKU_ITEM_DESC" "RTL_SKU_ITEM_DESC","A9"."RTL_SKU_ITEM_LONG_DESC" "RTL_SKU_ITEM_LONG_DESC","A9"."RECALL_IND" "RECALL_IND","A9"."PCK_SELLBL_CD" "PCK_SELLBL_CD","A9"."PCK_SMPL_CD" "PCK_SMPL_CD","A9"."PCK_ORDRBL_CD" "PCK_ORDRBL_CD","A9"."PCK_IND" "PCK_IND","A9"."PKG_SZ" "PKG_SZ","A9"."PCK_SELLBL_DESC" "PCK_SELLBL_DESC","A9"."PCK_SMPL_DESC" "PCK_SMPL_DESC","A9"."PCK_ORDRBL_DESC" "PCK_ORDRBL_DESC","A8"."RTL_ITEM_ID" "RTL_ITEM_ID","A8"."RTL_ITEM_NBR" "RTL_ITEM_NBR","A8"."RTL_ITEM_NAME" "RTL_ITEM_NAME","A8"."RTL_BRND_CD" "RTL_BRND_CD","A8"."RTL_ITEM_SHORT_DESC" "RTL_ITEM_SHORT_DESC","A8"."RTL_ITEM_SCND_DESC" "RTL_ITEM_SCND_DESC","A8"."RTL_ITEM_DESC" "RTL_ITEM_DESC","A1"."BRND_NAME" "BRND_NAME","A1"."BRND_DESC" "BRND_DESC","A7"."RTL_ITEM_SBC_ID" "RTL_ITEM_SBC_ID","A7"."RTL_SBC_CD" "RTL_SBC_CD","A7"."RTL_SBC_NAME" "RTL_SBC_NAME","A6"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID","A6"."RTL_CLASS_CD" "RTL_CLASS_CD","A6"."RTL_CLASS_NAME" "RTL_CLASS_NAME","A5"."RTL_ITEM_DEPT_ID" "RTL_ITEM_DEPT_ID","A5"."RTL_DEPT_CD" "RTL_DEPT_CD","A5"."RTL_DEPT_NAME" "RTL_DEPT_NAME","A4"."RTL_ITEM_GRP_ID" "RTL_ITEM_GRP_ID","A4"."RTL_GRP_CD" "RTL_GRP_CD","A4"."RTL_GRP_NAME" "RTL_GRP_NAME","A3"."RTL_ITEM_DIV_ID" "RTL_ITEM_DIV_ID","A3"."RTL_DIV_CD" "RTL_DIV_CD","A3"."RTL_DIV_NAME" "RTL_DIV_NAME","A3"."RTL_ITEM_CMPNY_ID" "RTL_ITEM_CMPNY_ID",NVL("A9"."EFF_FROM_DT",TO_DATE('01-JAN-1900')) "EFF_FROM_DT",NVL("A9"."EFF_TO_DT",TO_DATE('31-DEC-9999')) "EFF_TO_DT","A9"."ATTRIBUTE1" "ATTRIBUTE1","A9"."ATTRIBUTE2" "ATTRIBUTE2","A9"."ATTRIBUTE3" "ATTRIBUTE3" FROM "DDR"."DDR_R_RTL_SKU_ITEM" "A9","DDR"."DDR_R_RTL_ITEM" "A8","DDR"."DDR_R_RTL_ITEM_SBC" "A7","DDR"."DDR_R_RTL_ITEM_CLASS" "A6","DDR"."DDR_R_RTL_ITEM_DEPT" "A5","DDR"."DDR_R_RTL_ITEM_GRP" "A4","DDR"."DDR_R_RTL_ITEM_DIV" "A3","DDR"."DDR_R_ORG" "A2", (SELECT "A10"."MFG_ORG_CD" "MFG_ORG_CD","A10"."LKUP_CD" "BRND_CD","A10"."LKUP_NAME" "BRND_NAME","A10"."LKUP_DESC" "BRND_DESC","A10".ROWID "ROWID" FROM "DDR"."DDR_R_LKUP_MST" "A10" WHERE "A10"."LKUP_TYP_CD"='BRND') "A1" WHERE "A9"."RTL_ITEM_ID"="A8"."RTL_ITEM_ID" AND "A8"."RTL_ITEM_SBC_ID"="A7"."RTL_ITEM_SBC_ID" AND "A7"."RTL_ITEM_CLASS_ID"="A6"."RTL_ITEM_CLASS_ID" AND "A6"."RTL_ITEM_DEPT_ID"="A5"."RTL_ITEM_DEPT_ID" AND "A5"."RTL_ITEM_GRP_ID"="A4"."RTL_ITEM_GRP_ID" AND "A4"."RTL_ITEM_DIV_ID"="A3"."RTL_ITEM_DIV_ID" AND "A2"."ORG_CD"="A3"."RTL_ORG_CD" AND "A8"."MFG_ORG_CD"="A1"."MFG_ORG_CD"(+) AND "A8"."RTL_BRND_CD"="A1"."BRND_CD"(+)