Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct ol.em_sc_sell_price - (sum(od.em_Sc_fee_amount) + mpp.pricelist)
- from c_orderline ol
- join m_product mp on ol.m_product_id = mp.m_product_id
- join m_productprice mpp on mp.m_product_id = mpp.m_product_id
- join c_order o on ol.c_order_id = o.c_order_id
- join c_order_discount od on o.c_order_id = od.c_order_id
- join m_pricelist_version pv on pv.m_pricelist_version_id = mpp.m_pricelist_version_id
- join m_pricelist pl on pl.m_pricelist_id = pv.m_pricelist_id
- where ol.C_ORDERLINE_ID = 'FAEF4117F7754A10B7B633B5DF89C2E5'
- and mpp.isactive = 'Y'
- and o.documentno = '15036326'
- and pl.issopricelist = 'Y';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement