当前位置:我的异常网» Oracle开发 » oracle 报psl-00103 错 请大神帮帮忙 跪求解决方法
oracle 报psl-00103 错 请大神帮帮忙 跪求解决方法(3)
www.myexceptions.net 网友分享于:2013-12-17 浏览:93次
and b.m_product_id in(' || v_sql3 || ')
and s.id in(' || v_sql4 || ')
and ' || v_sql5 || '
union all
select get_sequences(''RP_TRANSFER001PROC''),a.AD_CLIENT_ID,a.AD_ORG_ID,a.OWNERID,a.MODIFIERID,a.CREATIONDATE,a.MODIFIEDDATE,a.ISACTIVE,
to_char(a.INTIME,'yyyymmdd') as changedate,
a.DOCNO,a.c_Orig_Id,a.C_DEST_ID,a.DESCRIPTION,b.M_PRODUCT_ID,
b.M_ATTRIBUTESETINSTANCE_ID,0 AS QTY,0 as QTYOUT,b.QTYIN,0 as preqtyin,(b.QTYOUT-b.QTYIN) as qtydiff,(select m.pricelist from m_product m where b.m_product_id=m.id) as PRICELIST,
0 as TOT_AMTQTY_LIST, 0 as TOT_AMTOUT_LIST,b.qtyin*(select m.pricelist from m_product m where b.m_product_id=m.id) TOT_AMTIN_LIST,0 as TOT_AMTPREIN_LIST,
(b.qtyout-b.qtyin)*(select m.pricelist from m_product m where b.m_product_id=m.id(+)) as TOT_AMTDIFF_LIST,
s.id as m_product_alias_id,
(select m.acost from m_product m where m.id=b.m_product_id) as ACOST,
0 as percost,
0 as tot_amtqty_acost,0 as tot_amtqty_percost,' ||
p_pi_id || '
from M_TRANSFER a,M_TRANSFERITEM b ,m_product_alias s
where a.ID=b.M_TRANSFER_ID
and a.IN_STATUS=2
and b.m_product_id=s.m_product_id
and b.m_attributesetinstance_id=s.m_attributesetinstance_id
and a.INTIME between ' || v_datebegin || '
and ' || v_dateend || '
and a.c_orig_id in(' || v_sql1 || ')
and a.c_dest_id in(' || v_sql2 || ')
and b.m_product_id in(' || v_sql3 ||
')
and s.id in(' || v_sql4 || ')
文章评论