2017-12-19 14:31:13 UTC LOG:  duration: 128567.169 ms  execute <unnamed>:
SELECT orgname, 
       c_bpartner_id, 
       bpartnername, 
       c_order_id, 
       documentno, 
       dateordered, 
       grandtotal, 
       convgrandtotal, 
       invoicerule, 
       line, 
       product, 
       price, 
       convprice, 
       qtyordered, 
       uomsymbol, 
       tax, 
       taxbase, 
       convtaxbase, 
       linenetamt, 
       convlinenetamt, 
       ordercurrencysym, 
       transcurrencyidorder, 
       transdateorder, 
       transclientidorder, 
       transorgidorder, 
       linecurrencysym, 
       transcurrencyidline, 
       transdateline, 
       transclientidline, 
       transorgidline, 
       C_currency_symbol('100', 0, 'Y') AS CONVSYM, 
       C_currency_isosym('100')         AS CONVISOSYM 
FROM   (SELECT ad_org.NAME                                                AS 
               ORGNAME, 
               c_bpartner.c_bpartner_id, 
               c_bpartner.NAME                                            AS 
                       BPARTNERNAME, 
               c_order.c_order_id, 
               c_order.documentno, 
               c_order.dateordered, 
               c_order.grandtotal, 
               C_currency_convert(c_order.grandtotal, c_order.c_currency_id, '100', 
               To_date 
               ( 
               COALESCE(c_order.dateordered, Now())), NULL, 
               c_order.ad_client_id, 
               c_order.ad_org_id)                                         AS 
                       CONVGRANDTOTAL, 
               ( CASE c_order.invoicerule 
                   WHEN 'S' THEN COALESCE(ad_ref_list_trl.NAME, 
                                 ad_ref_list.NAME) 
                                 || ' (' 
                                 || c_invoiceschedule.NAME 
                                 || ')' 
                   ELSE COALESCE(ad_ref_list_trl.NAME, ad_ref_list.NAME) 
                 END )                                                    AS 
                      INVOICERULE 
                       , 
               c_orderline.line 
                       AS LINE, 
               COALESCE(m_product.NAME, m_product.description)            AS 
               PRODUCT, 
               c_orderline.priceactual                                    AS 
               PRICE, 
               C_currency_convert(c_orderline.priceactual, 
               COALESCE(c_orderline.c_currency_id, c_order.c_currency_id), '100', 
               To_date(COALESCE(c_order.dateordered, Now())), NULL, 
               c_orderline.ad_client_id, 
               c_orderline.ad_org_id)                                     AS 
               CONVPRICE, 
               c_orderline.qtyordered - c_orderline.qtyinvoiced           AS 
               QTYORDERED 
                      , 
               c_uom.uomsymbol, 
               NULL                                                       AS TAX 
               , 
               NULL 
               AS TAXBASE, 
               NULL                                                       AS 
                      CONVTAXBASE 
                       , 
               c_orderline.linenetamt, 
               C_currency_convert(c_orderline.linenetamt, 
               COALESCE(c_orderline.c_currency_id, c_order.c_currency_id), '100', 
               To_date(COALESCE(c_order.dateordered, Now())), NULL, 
               c_orderline.ad_client_id, 
               c_orderline.ad_org_id)                                     AS 
                       CONVLINENETAMT, 
               C_currency_symbol(c_order.c_currency_id, 0, 'Y')           AS 
                       ORDERCURRENCYSYM, 
               c_order.c_currency_id                                      AS 
                       TRANSCURRENCYIDORDER, 
               c_order.dateordered                                        AS 
                       TRANSDATEORDER, 
               c_order.ad_client_id                                       AS 
                       TRANSCLIENTIDORDER, 
               c_order.ad_org_id                                          AS 
                       TRANSORGIDORDER, 
               C_currency_symbol(COALESCE(c_orderline.c_currency_id, 
                                 c_order.c_currency_id), 0, 
               'Y')                                                       AS 
                       LINECURRENCYSYM, 
               COALESCE(c_orderline.c_currency_id, c_order.c_currency_id) AS 
               TRANSCURRENCYIDLINE, 
               To_date(COALESCE(c_order.dateordered, Now()))              AS 
                       TRANSDATELINE, 
               c_orderline.ad_client_id                                   AS 
                       TRANSCLIENTIDLINE, 
               c_orderline.ad_org_id                                      AS 
                       TRANSORGIDLINE 
        FROM   c_bpartner 
               LEFT JOIN c_invoiceschedule 
                      ON c_bpartner.c_invoiceschedule_id = 
                         c_invoiceschedule.c_invoiceschedule_id, 
               ad_ref_list 
               LEFT JOIN ad_ref_list_trl 
                      ON ad_ref_list.ad_ref_list_id = 
                         ad_ref_list_trl.ad_ref_list_id 
                         AND ad_ref_list_trl.ad_language = 'en_US', 
               c_orderline 
               LEFT JOIN m_product 
                      ON c_orderline.m_product_id = m_product.m_product_id, 
               c_order, 
               ad_org, 
               c_uom, 
               c_currency 
        WHERE  c_order.c_order_id = c_orderline.c_order_id 
               AND c_order.c_bpartner_id = c_bpartner.c_bpartner_id 
               AND c_order.invoicerule = ad_ref_list.value 
               AND c_order.invoicerule <> 'N' 
               AND c_orderline.c_uom_id = c_uom.c_uom_id 
               AND c_order.ad_org_id = ad_org.ad_org_id 
               AND c_order.c_currency_id = c_currency.c_currency_id 
               AND ad_ref_list.ad_reference_id = '150' 
               AND c_order.processed = 'Y' 
               AND c_order.docstatus NOT IN ( 'CJ', 'UE', 'CA' ) 
               AND c_order.issotrx = 'Y' 
               AND c_orderline.qtyordered <> c_orderline.qtyinvoiced 
               AND c_order.ad_client_id IN ( '0', 
                   '8B72EA2C5B444DE291849E37F2F86DBA' ) 
               AND c_order.ad_org_id IN ( 
                       '0', '306D3B3010FB47C8830A3CD6544CB71D', 
                       'A25CF246A7B94A4A92B0C0D74878D227', 
                                            'CBC7D0B4DEB04192ABA391687EAE0F61', 
                                          '3F52F6C378274F8EA1A9A1A10D15E21E', 
                       'C14CFAB09B594263AB5C99A82937E427', 
                       'E453C89517DD4FB3A2EBB9EF79808E3A', 
                       'E3ADD08E7A344BC4AA0E5271A00EE1AB', 
                                          '48C21BE2F1A449A8AD397A7D1B3F2C18', 
                       '318A3152361C46959E07EC1393D1C7CE', 
                       'E3353FB57805410D9515EFA23737C399', 
                       'AB40EE591DBE44F093E4C5B606D354C6', 
                                          'A31788F217B448728321DDB7800D1808', 
                       '3CB045196B7547DFAE80DC60193B687A', 
                       '362AAC83D0D94AB5B802E2FDDA49A8E0', 
                       '5F7B6E84D15843E69C4ED7D97444D478', 
                                          '40C5CBF3762A4BDA85058E1D837E03E4', 
                       '8BD961208E0244D99F31700FFAC12341', 
                       '6D3322D0CEFE40FBB5ADCE995C9A5E18', 
                       'D2FF042B470147AB81BC7B993D63214C', 
                                          'B31B3BFBBE154ACB93897A42C9FF351C', 
                       '2DE44FC9B33847FEB69C2908E1FBC1C2', 
                       'E7F4AC1093684F15B5954A5818076653', 
                       '3A1097E45C4243F6BBE926EA3D947E3F', 
                                          '5F0B6579C951489A936A683A426A132E', 
                       '9FC6900EC6D04B55B3F831FA09121E32', 
                       'D46CCA95EB5542A5973BAEEF312F6A0D', 
                       'EC9580A5DE2F4AADA9ECC42D34702571', 
                                          '25E8B7AA299A492D9EF6B2B99B864419', 
                       '316DC99A97B844CDBE9E20003A16C0F3', 
                       '5F49108E9AA24990A0EBC198DF40CE54', 
                       '5305CF0416744873BB2DF46386354A31', 
                                          '9A3DA17921AD4C52A79C2359B0BBC981', 
                       'BADC1A86EB20423FA958DE0B65CC381F', 
                       'A8B01CD45FDA490AA2FBF2A857249345', 
                       '63022951ABB74A86B790E95F52E40F58', 
                                          'FAF808E5C3F349248230456BFC11C6B8', 
                       '53D2871ECE304BB09604AF4D0FF3D7F1', 
                       'A892B2A07E2643C1845C99F4E687862B', 
                       'D8CF30DCA6AB43F69021C95005E6BD13', 
                                          'D9AD12FC3BBA499DA29BDB45ADCE6D5A', 
                       'FB5802AE5E284CCE8B1AEF307089595B', 
                       'A5112471313A4F0199F10514E5DF2BBE', 
                       '4B67D434A6DD44A69A1EAE1D74C83562', 
                                          '18B60CB5A6174D169BA790216E002B4D', 
                       '7BCCA05C769C44E395EDA1AC27A56A03', 
                       'E6EAD13FC35445AE9BD81901F0624172', 
                       '6F67E7FC52C444CFA0D7B7E95F5FEDB8', 
                                          '158F30646EE949ABB8B637F09BC79AED', 
                       '327EF8CB2F564BA99F20687CD8AA35F1', 
                       '53479AE940E744B5B3624BE316062075', 
                       '325EDF84AA9C4395AAD33A14F59BE6A1', 
                                          'E43A0CFA32F044C6B381E8771ED0DD7C', 
                       '2F3F3D5938D84A67811FBF8A27162690', 
                       '7EBDA22E5A664C56A56C28C3D26DC092', 
                       'E70FD5E6A6B04477A2200D9C43E78A24', 
                                          '98C02C1EB0224902AAE5171D347AC76B', 
                       '1CDFEC4B6E2140D6843D25ADB328128E', 
                       '2653FE69D1DE43C8ADC3D1E20505B430', 
                       '0C6AAE6CBB6842739797E8E20048E91A', 
                                          'D96638F06E794FA5825D23E36EFFB9D1', 
                       '8EA4BA1E749B4C388AB7A8F976788D56', 
                       '6A2500E55D034D7B8EB13D06878A1D9B', 
                       'A0CA35EECA0F42229D8410545ACB68E3', 
                                          'C34B8B66DDF244B8A3A908C53EBB16F6', 
                       '1FCF5E2FDCB2450F806A675AB07193A7', 
                       'F788E977C5B64ED7A85169BA5236589E', 
                       'E4B776F73C724DD7A5B323E0B2E841BA', 
                                          '08189B9A7D844CBCAFE14A7FB9B96913', 
                       'B147B3EC7A8D42A4A608053D0BBDA16A', 
                       'D47DAC0B366F483BAA194C5343D319C0', 
                       'E279CA67D8CA43F5AEC3F4CA84214406', 
                                          'CCBEF4528C9A42BD9DB5DD3BF8173728', 
                       '55477A2045D3473B8F4206A86698E6D2', 
                       '5FAE4EEA12BD4A688A15C8E37EE3EBD7', 
                       '67D855B636114782AD040B50B7228692', 
                                          '103BEA21E8E542D2A034A31770ADE05F', 
                       'AF4BA739CCEA492B833CD43A77A33C6D', 
                       '66FE8861B05B4347A044EDFF1014A288', 
                       '092B255D7EC74A3FA5525FC569B3F71E', 
                                          '4D9E8560D45A460480F4A1149D08606E', 
                       'E058BB072CFA44B2B6C100566EAADEED', 
                       '319E8635613743318EA26DBD03BC882C', 
                       '19F0E53F8AA44F4A8C0B61C1A747688D', 
                                          '2133FE47A7324CDA80EE68FF45E61E05', 
                       '8FBFE61810E4454F8E1246C7981F1551', 
                       '7A31597C9469404EB6F07F8DDDC6DE3E', 
                       '70361055E36D43EAABBE36524BCEF26D', 
                                          '4F3851920A7449BA903F88A3136A7F17', 
                       '87652CFFDAD949FABD8B9C568435E3EF', 
                       '2D104264E8E74EA58549EE603BCD8AEA', 
                       'A6D118067C8B403985AD754E3AFD075A', 
                                          'A67CC53B0AD04B07B9419AE42A731707', 
                       '9C6267A300964551B8EB72221E0E6D33', 
                       '4531AF4A7F3A422DA80ABA2B6B45E657', 
                       '309E9A1B24C6496B9D79AC17C0886209', 
                                          '993AA85D1C7747E09823747874BCC4F3', 
                       '469016B267C84C208442E2696C9D400A', 
                       '1B693F0BE60F4C56A0BA89BDE1DC55B1', 
                       '3BA5DBAB24F6422580F083DA3776FD08', 
                                          '3794C31D03A643EE928C8A5358E12853', 
                       '76A2DDBEC2224AEDBF71A320A6667987', 
                       'DFE5315B13BB4F8F821774FE4A49D46C', 
                       '78F45D18B38048E9901DE1F0102384DC', 
                                          'C984287036394AF6943C8F93B78E4506', 
                       'F71E03783E794EA6B72CF90DF5B7DBA5', 
                       'D0B0F660DF9A4F609C00BD619EBB0F51', 
                       'AD55542CD1F54C208E7F7B58EC65C008', 
                                          '2432C0FB102D4451908EDA04A6642190', 
                       '535C96CDB35F49BB801321F522FB2B96', 
                       'C853ABFC80E74DC4BB82967F029D42E2', 
                       '2324EF6B39E54D17BACC2684CF4F16AA', 
                                          'E340A0C8A88C443BB8FAB9FCDF844FD8', 
                       '6D005AF435DA48C183ACA2B0E81EDD8F', 
                       '2C743FE937A9485492069A2DFD5C1503', 
                       'C82D39BA61EE465E95EB5D9C16B5A5F8', 
                                          '975DDFA55BAD4CB9AF9B8435DD12D7A0', 
                       '8D2AAA7E604C47DE81535132E0E6C48B', 
                       '2644B64E7DC843C1A49EEED5C9AD8861', 
                       'C4E159A41C614709867FD47F8455B218', 
                                          'CD18CEA3A5F6443E9B47DA2076F03C03', 
                       '09868DD506E044AEB71468EA45014280', 
                       'FFC21A886B7B442A8939CF67950E815A', 
                       '783B64B7E16E4469BDAD56E05AF5403B', 
                                          '806B5D2219004E21AD2EA379FE966670', 
                       '0598DB73327A4B4CBE02684086122065', 
                       '16ACC38D0A22432E80DD09FF717B6224', 
                       'EFB204879DDD41D396B2FB3A5E029323', 
                                          'C774409334DC43FDBC3FE3687D9DDE69', 
                       'FF0C52506A3945EFB25591C780D8EB98', 
                       '5D047A3692B840F58CBCDA2F54D8CF7D', 
                       '82BBDFEC32274B72AB27A8E1D453F514', 
                                          '2ED7CF7C8C574B4BB9FA8AEA512D4D63', 
                       'FB83A1D3A97D4CE099FC66AB24FBFFCA', 
                       'B1D84FD139D84CB3AAB1A03CDFD6B579', 
                       'FA91DD8960124653AE9B01E2F8655687', 
                                          'A64FB0CB369043F29A1C20EC1E613F8A', 
                       '8280E4BDF99642E7A5FBFB6427D236FD', 
                       'BFBAC410E31D4DE3B2CB6CAA31341CEA', 
                       'DFCC55A6294C425F9E9A2776F0E0DC65', 
                                          '182152C8710A463CA2D015AB770F4193', 
                       '31825820459F42EEADBA2E15A3F1D1FA', 
                       'A1F5B06F460F4F67BBBC6AC3FE27AE85', 
                       'DF65A343ABA543CF88B7A6DCD52380A3', 
                                          'D9CC311BEE7B435EA13ED5359665FA1C', 
                       'A23C7BE09AA344D0BB7E8ACECCF84B9B', 
                       '092895CF76EA44FABC262980D8A156D9', 
                       '62CD82E1A1024DC8AB12DB0E4338674D', 
                                          '617419D69ADC49F0A5E84CE7807233EE', 
                       '64FF896979C74E799DDE3F383812E4F1', 
                       'CE80F7CD48AD494BA9C51D29CF2A8773', 
                       'D31CC43D89D242EFBAB45C84ABCE1FF4', 
                                          '4F376722D18F42DBB0E86866B7017F50', 
                       'F0D1C82A28DE4E0995FFD646E7A5A24D', 
                       'D4D7E44F737644069A7C8FFE2A577E7A', 
                       'DB90663FCEC343B6BDF99BB21C63C02F', 
                                          '6A3B7B0E57DD48CEACE2981F1C7C81ED', 
                       '04FFD14E863C427B9E95FDD273059339', 
                       '7A3EBF715DBB43258B29BFCBA7E8F8ED', 
                       '71329097F6AD4455A6193BA551993DF2', 
                                          '45F69D028C46421C9B2897B1EB3EDD4E', 
                       '26654E04FDD4405CBDB9334070DC2026', 
                       'AB585C50B9934FEE8D6DCC141AECA3EE', 
                       '2D288394D33F449F8C5BE09A23B5F97B', 
                                          '288B1466C1024455A5C80DE9944C275E', 
                       '16303BD6F5C74355A3E6ED4DB60B8A67', 
                       '469ACE6358FB4C0EA58058FA823EAFEC', 
                       '0D796DFE59D0443E93A2CA46F607886E', 
                                          '790BA1D65CA34B72AFA6ED87355A6337', 
                       '9228CFE725604EA0BF01C676B5C5E72A', 
                       'BF77D03787D84C9888FCFBD012BFDA02', 
                       '043D618911174C8D85F2B97407B3B652', 
                                          '08537956D91D40B69AE040254CAF341E', 
                       'DDDD4C61896142B78A1EA29105A082AD', 
                       'BDA0ECE46C39499491FD6149E787C9F4', 
                       '96B08A8DB32C49E2A809E156DB592842', 
                                          'D3E00B67031D4A309FE917292CF1F719', 
                       '77D3336DC2214AE6A7304A23FD35A805', 
                       'F04CEDB8E1FC4341958071416F24AD05', 
                       '2484267157304B488B71329DDB3D8421', 
                                          'D76C8E0696EA4C62B38DBD29ACB602E7', 
                       'F3CE6131A1674567ADC67FA3FD764B7E', 
                       '6B6A074DD75A415C958AC44CA5755B60', 
                       '38D225ED623B4E13B78C2C917579E440', 
                                          '6A247D9E877C4A5689C8A90BCBD8F957', 
                       '537C0C44F0C740CA917101B6413C9AB5', 
                       'C851613D607F47F99AAD8516BBA438F4', 
                       '1955B39FD1884AB180F1F69F45C0B1BE', 
                                          '43C4BA0AFB8B486B9AACBD519E403AD9', 
                       '1526521C6C704155A625CF21CE913BF4', 
                       '0917477F7B8B48228D2A13D8B5E5D0C7', 
                       'D1331BB2694840FD8B38D5857E4D8C05', 
                                          '317DAAB1CF49470CA3FD565D773666DD', 
                       '943596C335724B139171B9EDA473DA53', 
                       '9178C2F840EB4CD9B1098A333EBFA992', 
                       'B8184BF4838A4B4FA7809FDCBB25504E', 
                                          'AEDAF1F20FAF44FC93AB35D2DFD3E5C5', 
                       'B6E2D1B581464191AD48AFF6AED9B813', 
                       'C2BAA87926B14FCCB7B6C481EFAA395C', 
                       '972455AB23EC47A1A2C31B53F5C06E68', 
                                          '8969F75D79B6402BA45B7DF1EA54435D', 
                       '531F3B4C89EC4BF180B6616F94656FA1', 
                       'E853EC3DE4244365BE97935652115E35', 
                       '043739981A1D4C5BBACAC37926B2104C', 
                                          '9D1090AFC1D043B2A8086A4FFF8D31E4', 
                       '8DF1BD24A1EB4F4F918E75236873A402', 
                       '00FC5F98BDE047F99C062F6ABD2DCB9B', 
                       'F5CA78C4CDAC45758F3D3518EB2938C5', 
                                          '6027B0644E5E4A238FBD6CAC1F44DDE3', 
                       '15F7BFB3DA804535BDD03E216EB851B4', 
                       '2CD3172D63644694A19E7BE676B63362', 
                       '696A3525F40E4E01B538CF3E729CB410', 
                                          '68269B60854A41C48A55EC4FB363E5F3', 
                       'B54CFF4B5FED44A9853F2F6FA3FFC931', 
                       '11009FD31FA045C3910556DDB72C5817', 
                       '86B7EAE491FF4025946652B3423A4EB5', 
                                          'C83B8D6D3DBA455B8C4973F68D8E2F59', 
                       'FD8E0F9DA2124FCB954859AB6F48755F' ) 
               AND 1 = 1 
               AND c_order.dateordered >= To_date('10-08-2017') 
               AND c_order.dateordered < To_date('13-09-2017') 
        UNION ALL 
        SELECT ad_org.NAME                                          AS ORGNAME, 
               c_bpartner.c_bpartner_id, 
               c_bpartner.NAME                                      AS 
               BPARTNERNAME, 
               C.c_order_id, 
               C.documentno, 
               C.dateordered, 
               C.grandtotal, 
               C_currency_convert(C.grandtotal, C.c_currency_id, '100', To_date( 
               COALESCE(C.dateordered, Now())), NULL, 
               C.ad_client_id, C.ad_org_id)                         AS 
               CONVGRANDTOTAL, 
               ( CASE C.invoicerule 
                   WHEN 'S' THEN COALESCE(ad_ref_list_trl.NAME, 
                                 ad_ref_list.NAME) 
                                 || ' (' 
                                 || c_invoiceschedule.NAME 
                                 || ')' 
                   ELSE COALESCE(ad_ref_list_trl.NAME, ad_ref_list.NAME) 
                 END )                                              AS 
               INVOICERULE, 
               NULL                                                 AS LINE, 
               c_tax.NAME                                           AS PRODUCT, 
               NULL                                                 AS PRICE, 
               NULL                                                 AS CONVPRICE 
               , 
               NULL 
               AS QTYORDERED, 
               NULL                                                 AS UOMSYMBOL 
               , 
               c_tax.rate 
               AS TAX, 
               c_ordertax.taxbaseamt                                AS TAXBASE, 
               C_currency_convert(c_ordertax.taxbaseamt, C.c_currency_id, '100', 
               To_date(COALESCE(C.dateordered, Now())), NULL, 
               c_ordertax.ad_client_id, 
               c_ordertax.ad_org_id)                                AS 
               CONVTAXBASE, 
               c_ordertax.taxamt                                    AS 
               LINENETAMT, 
               C_currency_convert(c_ordertax.taxamt, C.c_currency_id, '100', 
               To_date( 
               COALESCE(C.dateordered, Now())), 
               NULL, c_ordertax.ad_client_id, c_ordertax.ad_org_id) AS 
               CONVLINENETAMT, 
               C_currency_symbol(C.c_currency_id, 0, 'Y')           AS 
               ORDERCURRENCYSYM 
               , 
               C.c_currency_id                                      AS 
               TRANSCURRENCYIDORDER, 
               C.dateordered                                        AS 
               TRANSDATEORDER, 
               C.ad_client_id                                       AS 
               TRANSCLIENTIDORDER, 
               C.ad_org_id                                          AS 
               TRANSORGIDORDER, 
               C_currency_symbol(C.c_currency_id, 0, 'Y')           AS 
               LINECURRENCYSYM, 
               C.c_currency_id                                      AS 
               TRANSCURRENCYIDLINE, 
               To_date(COALESCE(C.dateordered, Now()))              AS 
               TRANSDATELINE, 
               c_ordertax.ad_client_id                              AS 
               TRANSCLIENTIDLINE 
               , 
               c_ordertax.ad_org_id                                 AS 
               TRANSORGIDLINE 
        FROM   c_bpartner 
               LEFT JOIN c_invoiceschedule 
                      ON c_bpartner.c_invoiceschedule_id = 
                         c_invoiceschedule.c_invoiceschedule_id, 
               ad_ref_list 
               LEFT JOIN ad_ref_list_trl 
                      ON ad_ref_list.ad_ref_list_id = 
                         ad_ref_list_trl.ad_ref_list_id 
                         AND ad_ref_list_trl.ad_language = 'en_US', 
               c_order C, 
               c_ordertax, 
               ad_org, 
               c_tax, 
               c_currency 
        WHERE  C.c_order_id = c_ordertax.c_order_id 
               AND C.c_bpartner_id = c_bpartner.c_bpartner_id 
               AND C.c_currency_id = c_currency.c_currency_id 
               AND C.invoicerule = ad_ref_list.value 
               AND C.invoicerule <> 'N' 
               AND ad_ref_list.ad_reference_id = '150' 
               AND c_ordertax.c_tax_id = c_tax.c_tax_id 
               AND C.ad_org_id = ad_org.ad_org_id 
               AND C.processed = 'Y' 
               AND C.docstatus NOT IN ( 'CJ', 'UE', 'CA' ) 
               AND C.issotrx = 'Y' 
               AND EXISTS (SELECT 1 
                           FROM   c_order C2, 
                                  c_orderline CL 
                           WHERE  C2.c_order_id = C.c_order_id 
                                  AND c2.c_order_id = cl.c_order_id 
                                  AND cl.qtyordered <> cl.qtyinvoiced) 
               AND C.ad_client_id IN ( '0', '8B72EA2C5B444DE291849E37F2F86DBA' ) 
               AND C.ad_org_id IN ( '0', '306D3B3010FB47C8830A3CD6544CB71D', 
                                    'A25CF246A7B94A4A92B0C0D74878D227', 
                                    'CBC7D0B4DEB04192ABA391687EAE0F61', 
                                    '3F52F6C378274F8EA1A9A1A10D15E21E', 
                                        'C14CFAB09B594263AB5C99A82937E427', 
                                    'E453C89517DD4FB3A2EBB9EF79808E3A', 
                                    'E3ADD08E7A344BC4AA0E5271A00EE1AB', 
                                    '48C21BE2F1A449A8AD397A7D1B3F2C18', 
                                        '318A3152361C46959E07EC1393D1C7CE', 
                                    'E3353FB57805410D9515EFA23737C399', 
                                    'AB40EE591DBE44F093E4C5B606D354C6', 
                                    'A31788F217B448728321DDB7800D1808', 
                                        '3CB045196B7547DFAE80DC60193B687A', 
                                    '362AAC83D0D94AB5B802E2FDDA49A8E0', 
                                    '5F7B6E84D15843E69C4ED7D97444D478', 
                                    '40C5CBF3762A4BDA85058E1D837E03E4', 
                                        '8BD961208E0244D99F31700FFAC12341', 
                                    '6D3322D0CEFE40FBB5ADCE995C9A5E18', 
                                    'D2FF042B470147AB81BC7B993D63214C', 
                                    'B31B3BFBBE154ACB93897A42C9FF351C', 
                                        '2DE44FC9B33847FEB69C2908E1FBC1C2', 
                                    'E7F4AC1093684F15B5954A5818076653', 
                                    '3A1097E45C4243F6BBE926EA3D947E3F', 
                                    '5F0B6579C951489A936A683A426A132E', 
                                        '9FC6900EC6D04B55B3F831FA09121E32', 
                                    'D46CCA95EB5542A5973BAEEF312F6A0D', 
                                    'EC9580A5DE2F4AADA9ECC42D34702571', 
                                    '25E8B7AA299A492D9EF6B2B99B864419', 
                                        '316DC99A97B844CDBE9E20003A16C0F3', 
                                    '5F49108E9AA24990A0EBC198DF40CE54', 
                                    '5305CF0416744873BB2DF46386354A31', 
                                    '9A3DA17921AD4C52A79C2359B0BBC981', 
                                        'BADC1A86EB20423FA958DE0B65CC381F', 
                                    'A8B01CD45FDA490AA2FBF2A857249345', 
                                    '63022951ABB74A86B790E95F52E40F58', 
                                    'FAF808E5C3F349248230456BFC11C6B8', 
                                        '53D2871ECE304BB09604AF4D0FF3D7F1', 
                                    'A892B2A07E2643C1845C99F4E687862B', 
                                    'D8CF30DCA6AB43F69021C95005E6BD13', 
                                    'D9AD12FC3BBA499DA29BDB45ADCE6D5A', 
                                        'FB5802AE5E284CCE8B1AEF307089595B', 
                                    'A5112471313A4F0199F10514E5DF2BBE', 
                                    '4B67D434A6DD44A69A1EAE1D74C83562', 
                                    '18B60CB5A6174D169BA790216E002B4D', 
                                        '7BCCA05C769C44E395EDA1AC27A56A03', 
                                    'E6EAD13FC35445AE9BD81901F0624172', 
                                    '6F67E7FC52C444CFA0D7B7E95F5FEDB8', 
                                    '158F30646EE949ABB8B637F09BC79AED', 
                                        '327EF8CB2F564BA99F20687CD8AA35F1', 
                                    '53479AE940E744B5B3624BE316062075', 
                                    '325EDF84AA9C4395AAD33A14F59BE6A1', 
                                    'E43A0CFA32F044C6B381E8771ED0DD7C', 
                                        '2F3F3D5938D84A67811FBF8A27162690', 
                                    '7EBDA22E5A664C56A56C28C3D26DC092', 
                                    'E70FD5E6A6B04477A2200D9C43E78A24', 
                                    '98C02C1EB0224902AAE5171D347AC76B', 
                                        '1CDFEC4B6E2140D6843D25ADB328128E', 
                                    '2653FE69D1DE43C8ADC3D1E20505B430', 
                                    '0C6AAE6CBB6842739797E8E20048E91A', 
                                    'D96638F06E794FA5825D23E36EFFB9D1', 
                                        '8EA4BA1E749B4C388AB7A8F976788D56', 
                                    '6A2500E55D034D7B8EB13D06878A1D9B', 
                                    'A0CA35EECA0F42229D8410545ACB68E3', 
                                    'C34B8B66DDF244B8A3A908C53EBB16F6', 
                                        '1FCF5E2FDCB2450F806A675AB07193A7', 
                                    'F788E977C5B64ED7A85169BA5236589E', 
                                    'E4B776F73C724DD7A5B323E0B2E841BA', 
                                    '08189B9A7D844CBCAFE14A7FB9B96913', 
                                        'B147B3EC7A8D42A4A608053D0BBDA16A', 
                                    'D47DAC0B366F483BAA194C5343D319C0', 
                                    'E279CA67D8CA43F5AEC3F4CA84214406', 
                                    'CCBEF4528C9A42BD9DB5DD3BF8173728', 
                                        '55477A2045D3473B8F4206A86698E6D2', 
                                    '5FAE4EEA12BD4A688A15C8E37EE3EBD7', 
                                    '67D855B636114782AD040B50B7228692', 
                                    '103BEA21E8E542D2A034A31770ADE05F', 
                                        'AF4BA739CCEA492B833CD43A77A33C6D', 
                                    '66FE8861B05B4347A044EDFF1014A288', 
                                    '092B255D7EC74A3FA5525FC569B3F71E', 
                                    '4D9E8560D45A460480F4A1149D08606E', 
                                        'E058BB072CFA44B2B6C100566EAADEED', 
                                    '319E8635613743318EA26DBD03BC882C', 
                                    '19F0E53F8AA44F4A8C0B61C1A747688D', 
                                    '2133FE47A7324CDA80EE68FF45E61E05', 
                                        '8FBFE61810E4454F8E1246C7981F1551', 
                                    '7A31597C9469404EB6F07F8DDDC6DE3E', 
                                    '70361055E36D43EAABBE36524BCEF26D', 
                                    '4F3851920A7449BA903F88A3136A7F17', 
                                        '87652CFFDAD949FABD8B9C568435E3EF', 
                                    '2D104264E8E74EA58549EE603BCD8AEA', 
                                    'A6D118067C8B403985AD754E3AFD075A', 
                                    'A67CC53B0AD04B07B9419AE42A731707', 
                                        '9C6267A300964551B8EB72221E0E6D33', 
                                    '4531AF4A7F3A422DA80ABA2B6B45E657', 
                                    '309E9A1B24C6496B9D79AC17C0886209', 
                                    '993AA85D1C7747E09823747874BCC4F3', 
                                        '469016B267C84C208442E2696C9D400A', 
                                    '1B693F0BE60F4C56A0BA89BDE1DC55B1', 
                                    '3BA5DBAB24F6422580F083DA3776FD08', 
                                    '3794C31D03A643EE928C8A5358E12853', 
                                        '76A2DDBEC2224AEDBF71A320A6667987', 
                                    'DFE5315B13BB4F8F821774FE4A49D46C', 
                                    '78F45D18B38048E9901DE1F0102384DC', 
                                    'C984287036394AF6943C8F93B78E4506', 
                                        'F71E03783E794EA6B72CF90DF5B7DBA5', 
                                    'D0B0F660DF9A4F609C00BD619EBB0F51', 
                                    'AD55542CD1F54C208E7F7B58EC65C008', 
                                    '2432C0FB102D4451908EDA04A6642190', 
                                        '535C96CDB35F49BB801321F522FB2B96', 
                                    'C853ABFC80E74DC4BB82967F029D42E2', 
                                    '2324EF6B39E54D17BACC2684CF4F16AA', 
                                    'E340A0C8A88C443BB8FAB9FCDF844FD8', 
                                        '6D005AF435DA48C183ACA2B0E81EDD8F', 
                                    '2C743FE937A9485492069A2DFD5C1503', 
                                    'C82D39BA61EE465E95EB5D9C16B5A5F8', 
                                    '975DDFA55BAD4CB9AF9B8435DD12D7A0', 
                                        '8D2AAA7E604C47DE81535132E0E6C48B', 
                                    '2644B64E7DC843C1A49EEED5C9AD8861', 
                                    'C4E159A41C614709867FD47F8455B218', 
                                    'CD18CEA3A5F6443E9B47DA2076F03C03', 
                                        '09868DD506E044AEB71468EA45014280', 
                                    'FFC21A886B7B442A8939CF67950E815A', 
                                    '783B64B7E16E4469BDAD56E05AF5403B', 
                                    '806B5D2219004E21AD2EA379FE966670', 
                                        '0598DB73327A4B4CBE02684086122065', 
                                    '16ACC38D0A22432E80DD09FF717B6224', 
                                    'EFB204879DDD41D396B2FB3A5E029323', 
                                    'C774409334DC43FDBC3FE3687D9DDE69', 
                                        'FF0C52506A3945EFB25591C780D8EB98', 
                                    '5D047A3692B840F58CBCDA2F54D8CF7D', 
                                    '82BBDFEC32274B72AB27A8E1D453F514', 
                                    '2ED7CF7C8C574B4BB9FA8AEA512D4D63', 
                                        'FB83A1D3A97D4CE099FC66AB24FBFFCA', 
                                    'B1D84FD139D84CB3AAB1A03CDFD6B579', 
                                    'FA91DD8960124653AE9B01E2F8655687', 
                                    'A64FB0CB369043F29A1C20EC1E613F8A', 
                                        '8280E4BDF99642E7A5FBFB6427D236FD', 
                                    'BFBAC410E31D4DE3B2CB6CAA31341CEA', 
                                    'DFCC55A6294C425F9E9A2776F0E0DC65', 
                                    '182152C8710A463CA2D015AB770F4193', 
                                        '31825820459F42EEADBA2E15A3F1D1FA', 
                                    'A1F5B06F460F4F67BBBC6AC3FE27AE85', 
                                    'DF65A343ABA543CF88B7A6DCD52380A3', 
                                    'D9CC311BEE7B435EA13ED5359665FA1C', 
                                        'A23C7BE09AA344D0BB7E8ACECCF84B9B', 
                                    '092895CF76EA44FABC262980D8A156D9', 
                                    '62CD82E1A1024DC8AB12DB0E4338674D', 
                                    '617419D69ADC49F0A5E84CE7807233EE', 
                                        '64FF896979C74E799DDE3F383812E4F1', 
                                    'CE80F7CD48AD494BA9C51D29CF2A8773', 
                                    'D31CC43D89D242EFBAB45C84ABCE1FF4', 
                                    '4F376722D18F42DBB0E86866B7017F50', 
                                        'F0D1C82A28DE4E0995FFD646E7A5A24D', 
                                    'D4D7E44F737644069A7C8FFE2A577E7A', 
                                    'DB90663FCEC343B6BDF99BB21C63C02F', 
                                    '6A3B7B0E57DD48CEACE2981F1C7C81ED', 
                                        '04FFD14E863C427B9E95FDD273059339', 
                                    '7A3EBF715DBB43258B29BFCBA7E8F8ED', 
                                    '71329097F6AD4455A6193BA551993DF2', 
                                    '45F69D028C46421C9B2897B1EB3EDD4E', 
                                        '26654E04FDD4405CBDB9334070DC2026', 
                                    'AB585C50B9934FEE8D6DCC141AECA3EE', 
                                    '2D288394D33F449F8C5BE09A23B5F97B', 
                                    '288B1466C1024455A5C80DE9944C275E', 
                                        '16303BD6F5C74355A3E6ED4DB60B8A67', 
                                    '469ACE6358FB4C0EA58058FA823EAFEC', 
                                    '0D796DFE59D0443E93A2CA46F607886E', 
                                    '790BA1D65CA34B72AFA6ED87355A6337', 
                                        '9228CFE725604EA0BF01C676B5C5E72A', 
                                    'BF77D03787D84C9888FCFBD012BFDA02', 
                                    '043D618911174C8D85F2B97407B3B652', 
                                    '08537956D91D40B69AE040254CAF341E', 
                                        'DDDD4C61896142B78A1EA29105A082AD', 
                                    'BDA0ECE46C39499491FD6149E787C9F4', 
                                    '96B08A8DB32C49E2A809E156DB592842', 
                                    'D3E00B67031D4A309FE917292CF1F719', 
                                        '77D3336DC2214AE6A7304A23FD35A805', 
                                    'F04CEDB8E1FC4341958071416F24AD05', 
                                    '2484267157304B488B71329DDB3D8421', 
                                    'D76C8E0696EA4C62B38DBD29ACB602E7', 
                                        'F3CE6131A1674567ADC67FA3FD764B7E', 
                                    '6B6A074DD75A415C958AC44CA5755B60', 
                                    '38D225ED623B4E13B78C2C917579E440', 
                                    '6A247D9E877C4A5689C8A90BCBD8F957', 
                                        '537C0C44F0C740CA917101B6413C9AB5', 
                                    'C851613D607F47F99AAD8516BBA438F4', 
                                    '1955B39FD1884AB180F1F69F45C0B1BE', 
                                    '43C4BA0AFB8B486B9AACBD519E403AD9', 
                                        '1526521C6C704155A625CF21CE913BF4', 
                                    '0917477F7B8B48228D2A13D8B5E5D0C7', 
                                    'D1331BB2694840FD8B38D5857E4D8C05', 
                                    '317DAAB1CF49470CA3FD565D773666DD', 
                                        '943596C335724B139171B9EDA473DA53', 
                                    '9178C2F840EB4CD9B1098A333EBFA992', 
                                    'B8184BF4838A4B4FA7809FDCBB25504E', 
                                    'AEDAF1F20FAF44FC93AB35D2DFD3E5C5', 
                                        'B6E2D1B581464191AD48AFF6AED9B813', 
                                    'C2BAA87926B14FCCB7B6C481EFAA395C', 
                                    '972455AB23EC47A1A2C31B53F5C06E68', 
                                    '8969F75D79B6402BA45B7DF1EA54435D', 
                                        '531F3B4C89EC4BF180B6616F94656FA1', 
                                    'E853EC3DE4244365BE97935652115E35', 
                                    '043739981A1D4C5BBACAC37926B2104C', 
                                    '9D1090AFC1D043B2A8086A4FFF8D31E4', 
                                        '8DF1BD24A1EB4F4F918E75236873A402', 
                                    '00FC5F98BDE047F99C062F6ABD2DCB9B', 
                                    'F5CA78C4CDAC45758F3D3518EB2938C5', 
                                    '6027B0644E5E4A238FBD6CAC1F44DDE3', 
                                        '15F7BFB3DA804535BDD03E216EB851B4', 
                                    '2CD3172D63644694A19E7BE676B63362', 
                                    '696A3525F40E4E01B538CF3E729CB410', 
                                    '68269B60854A41C48A55EC4FB363E5F3', 
                                        'B54CFF4B5FED44A9853F2F6FA3FFC931', 
                                    '11009FD31FA045C3910556DDB72C5817', 
                                    '86B7EAE491FF4025946652B3423A4EB5', 
                                    'C83B8D6D3DBA455B8C4973F68D8E2F59', 
                                        'FD8E0F9DA2124FCB954859AB6F48755F' ) 
               AND 2 = 2 
               AND C.dateordered >= To_date('10-08-2017') 
               AND C.dateordered < To_date('13-09-2017')) AAA 
ORDER  BY orgname, 
          bpartnername, 
          dateordered DESC, 
          documentno, 
          line