MATERIALIZED VIEW: APPS.DDR_R_MFG_ITEM_ITM_DN_MV

Source

SELECT "A7".ROWID "ITM_ROWID","A6".ROWID "SBC_ROWID","A5".ROWID "CLS_ROWID","A4".ROWID "GRP_ROWID","A3".ROWID "DIV_ROWID","A2".ROWID "ORG_ROWID","A1".ROWID "LKUP_ROWID","A7"."MFG_ORG_CD" "MFG_ORG_CD","A2"."ORG_NAME" "MFG_ORG_NAME","A7"."ORG_CD" "ORG_CD","A7"."MFG_ITEM_ID" "MFG_ITEM_ID","A7"."MFG_ITEM_NAME" "MFG_ITEM_NAME","A7"."MFG_ITEM_NBR" "MFG_ITEM_NBR","A7"."MFG_BRND_CD" "MFG_BRND_CD","A7"."MFG_ITEM_DESC" "MFG_ITEM_DESC","A7"."MFG_ITEM_SHORT_DESC" "MFG_ITEM_SHORT_DESC","A7"."MFG_ITEM_SCND_DESC" "MFG_ITEM_SCND_DESC","A7"."STORE_REORDRBL_IND" "STORE_REORDRBL_IND","A1"."BRND_NAME" "BRND_NAME","A1"."BRND_DESC" "BRND_DESC","A6"."MFG_ITEM_SBC_ID" "MFG_ITEM_SBC_ID","A6"."MFG_SBC_CD" "MFG_SBC_CD","A6"."MFG_SBC_NAME" "MFG_SBC_NAME","A5"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID","A5"."MFG_CLASS_CD" "MFG_CLASS_CD","A5"."MFG_CLASS_NAME" "MFG_CLASS_NAME","A4"."MFG_ITEM_GRP_ID" "MFG_ITEM_GRP_ID","A4"."MFG_GRP_CD" "MFG_GRP_CD","A4"."MFG_GRP_NAME" "MFG_GRP_NAME","A3"."MFG_ITEM_DIV_ID" "MFG_ITEM_DIV_ID","A3"."MFG_DIV_CD" "MFG_DIV_CD","A3"."MFG_DIV_NAME" "MFG_DIV_NAME","A3"."MFG_ITEM_CMPNY_ID" "MFG_ITEM_CMPNY_ID","A7"."ATTRIBUTE1" "ATTRIBUTE1","A7"."ATTRIBUTE2" "ATTRIBUTE2","A7"."ATTRIBUTE3" "ATTRIBUTE3" FROM "DDR"."DDR_R_MFG_ITEM" "A7","DDR"."DDR_R_MFG_ITEM_SBC" "A6","DDR"."DDR_R_MFG_ITEM_CLASS" "A5","DDR"."DDR_R_MFG_ITEM_GRP" "A4","DDR"."DDR_R_MFG_ITEM_DIV" "A3","DDR"."DDR_R_ORG" "A2", (SELECT "A8"."MFG_ORG_CD" "MFG_ORG_CD","A8"."LKUP_CD" "BRND_CD","A8"."LKUP_NAME" "BRND_NAME","A8"."LKUP_DESC" "BRND_DESC","A8".ROWID "ROWID" FROM "DDR"."DDR_R_LKUP_MST" "A8" WHERE "A8"."LKUP_TYP_CD"='BRND') "A1" WHERE "A7"."MFG_ITEM_SBC_ID"="A6"."MFG_ITEM_SBC_ID" AND "A6"."MFG_ITEM_CLASS_ID"="A5"."MFG_ITEM_CLASS_ID" AND "A5"."MFG_ITEM_GRP_ID"="A4"."MFG_ITEM_GRP_ID" AND "A4"."MFG_ITEM_DIV_ID"="A3"."MFG_ITEM_DIV_ID" AND "A2"."ORG_CD"="A7"."MFG_ORG_CD" AND "A7"."MFG_ORG_CD"="A1"."MFG_ORG_CD"(+) AND "A7"."MFG_BRND_CD"="A1"."BRND_CD"(+)