The screenshot shows the Show SQL page for a selected recommendation. The heading of the page is Show SQL. On the top, on the right-hand side of the page, is a button labeled Done.The SQL statement displayed is:

Rem SQL Access Advisor: Version 11.1.0.4.0 – Production
Rem
Rem Username:  SYS
Rem Task: SQLACCESS6607720
Rem Execution date:
Rem
CREATE MATERIALIZED VIEW LOG ON
"SH"."CUSTOMERS"
WITH ROWID, SEQUENCE("CUST_ID", "CUST_LAST_NAME","CUST_STATE
_PROVINCE")
INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON
"SH"."SALES"
WITH ROWID, SEQUENCE("PROD_ID", "CUST_ID", "QUANTITY_SOLD",
 "AMOUNT_SOLD")
INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW "SYS"."MV$$_00650002"
REFRESH FAST WITH ROWID
ENABLE QUERY REWRITE
AS SELECT SH.SALES.CUST_ID C1, SUM("SH"."SALES"."AMOUNT_SOLD") M1,
COUNT("SH"."SALES"."AMOUNT_SOLD")
M@, COUNT(*) M3 FROM SH.CUSTOMERS, SH.SALES WHERE SH.SALES.CUST_ID = SH.CUSTOMERS.CUST_ID 
GROUP BY SH.SALES.CUST_ID;
begin
dbms_stats.gather_table_stats('"SYS"'.'"MV$$_00650002"',NULL, dbms_stats.auto_sample_size);
end;
/

End of description.