CREATE TABLE "RATER"."TMP003"
(
"ITEM_ID" NUMBER(10,0)
);

CREATE MATERIALIZED VIEW "RATER"."TMP003" ("ITEM_ID")
ON PREBUILT TABLE
AS SELECT "COST_DETAIL_ITEMS"."ITEM_ID" "ITEM_ID" FROM "RATER"."COST_DETAIL_ITEMS"@EFLP2.EFLATBED.COM "COST_DETAIL_ITEMS";

SELECT count(1) as cnt FROM "RATER"."COST_DETAIL_ITEMS"@EFLP2.EFLATBED.COM "COST_DETAIL_ITEMS";

select count(1) cnt from "RATER"."TMP003"

exec DBMS_MVIEW.REFRESH('RATER.TMP003');

select count(1) cnt from "RATER"."TMP003"

I created table with only one column

"ITEM_ID" NUMBER(10,0)

then I created view with the same column "ITEM_ID" and query retrieves only this one column "ITEM_ID".