ORACLE 报FROM keyword not found where expected错 求大神指点！

[ysq1515]

EXECUTE IMMEDIATE 'INSERT INTO RP_NC_HISSTORAGE01
(ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE,C_STORE_ID, M_PRODUCT_ID,
PRICELIST, PERCOST, TOTAL,PRECOST,PREAMT, AMT_LIST, amt_cost, PREQTYIN,
FEECHECKEDIN, M_ATTRIBUTESETINSTANCE_ID, OWNERID,
MODIFIERID, CREATIONDATE, MODIFIEDDATE, ad_pi_id,ACOST,PRICEDIS)
select get_sequences(''RP_NC_HISSTORAGE01''), t.ad_client_id,
t.AD_ORG_ID, ''Y'', t.C_STORE_ID, t.M_PRODUCT_ID,
a.pricelist, 0 as PERCOST,
t.total,a.precost,a.precost*t.total as preamt, t.total * a.pricelist as amt_list,
0 as amt_cost,
0, 0, t.M_ATTRIBUTESETINSTANCE_ID, ' ||
v_userid || ',' || v_userid ||
',SYSDATE, SYSDATE, ' || p_pi_id ||
',a.acost,a.PRICEDIS
from ( select sum(t.qtychange) as total, t.m_product_id, t.m_attributesetinstance_id, t.c_store_id,
t.ad_client_id, t.ad_org_idfrom fa_storage_ftp t where t.m_product_id in ( ' ||
v_sql2 || ') and t.C_STORE_ID = ' ||
r_store_id(i) || 'and t.changedate <=' ||
v_dateend || 'group by t.m_product_id, t.m_attributesetinstance_id,
t.c_store_id, t.ad_client_id, t.ad_org_id
union all
select sum(b.qtybegin)as total, b.m_product_id, b.m_attributesetinstance_id, a.c_store_id ,
a.ad_client_id, a.ad_org_id
from C_BEGIINNING a, C_BEGIINNINGITEM b, m_product c
where a.id = b.c_begiinning_id and b.m_product_id = c.id and
a.c_store_id = ' || r_store_id(i) ||
' and b.m_product_id in(' || v_sql2 ||
') group by b.m_product_id, b.m_attributesetinstance_id, a.c_store_id , a.ad_client_id,
a.ad_org_id ) t,m_product a, fa_product_cost b
where t.m_product_id = a.id and
t.m_product_id = b.m_product_id(+)';
COMMIT;

ELSE