SELECT ( CASE 
           WHEN B.m_inoutline_id IS NULL THEN A.qty 
           ELSE B.qty 
         END )          AS ID, 
       A.c_uom_id, 
       uom.uomsymbol, 
       A.m_product_id, 
       Ad_column_identifier(To_char('M_Product'), To_char(A.m_product_id), 
       To_char( 
       'en_US'))        AS NAME, 
       A.c_orderline_id, 
       A.line, 
       uom.stdprecision AS stdprecision, 
       cur.priceprecision, 
       B.m_inoutline_id, 
       A.description, 
       ( CASE 
           WHEN B.m_inoutline_id IS NULL THEN A.quantityorder 
           ELSE B.quantityorder 
         END )          AS quantityOrder, 
       ( CASE 
           WHEN B.m_inoutline_id IS NULL THEN A.m_product_uom_id 
           ELSE B.m_product_uom_id 
         END )          AS M_Product_UOM_ID, 
       A.m_attributesetinstance_id, 
       A.ad_org_id, 
       A.taxbaseamt, 
       A.a_asset_id, 
       A.c_project_id, 
       A.c_costcenter_id, 
       A.user1_id, 
       A.user2_id, 
       A.explode, 
       'Y'              AS isOrder 
FROM   c_currency cur, 
       c_uom uom, 
       m_product p, 
       (SELECT COALESCE(l.a_asset_id, o.a_asset_id)           AS A_Asset_ID, 
               COALESCE(l.c_project_id, o.c_project_id)       AS C_Project_ID, 
               COALESCE(l.c_costcenter_id, o.c_costcenter_id) AS C_Costcenter_ID 
               , 
               COALESCE(l.user1_id, o.user1_id)               AS 
               User1_ID, 
               COALESCE(l.user2_id, o.user2_id)               AS User2_ID, 
               l.explode, 
               l.ad_org_id, 
               l.c_currency_id, 
               l.c_uom_id, 
               l.m_product_id, 
               l.line, 
               l.description, 
               l.c_orderline_id, 
               ( l.qtyordered - Sum(COALESCE(mp.qty, 0)) - COALESCE((SELECT Sum( 
                 COALESCE(CI.qtyinvoiced, 0) 
                         ) 
                  FROM   c_orderline CO 
                         LEFT JOIN c_invoiceline CI 
                                ON CI.c_orderline_id = 
                                   CO.c_orderline_id 
                                 WHERE 
                 CI.c_invoice_id = '1660DF7FB4B94F818C45C3FC6CEE81B5' 
                 AND 
                   CO.c_orderline_id = l.c_orderline_id 
                       GROUP  BY CI.c_orderline_id, 
                                 CO.qtyordered), 0) )         AS QTY, 
               l.quantityorder * C_divide(( 
                                 l.qtyordered - Sum(COALESCE(mp.qty, 0)) 
                                 - COALESCE( 
                                 (SELECT Sum( 
                                         COALESCE(CI.qtyinvoiced, 
                                         0)) 
                                         FROM   c_orderline CO 
                                 LEFT JOIN c_invoiceline CI 
                                        ON CI.c_orderline_id = 
                                           CO.c_orderline_id 
                                                        WHERE 
               CI.c_invoice_id = '1660DF7FB4B94F818C45C3FC6CEE81B5' 
               AND CO.c_orderline_id = l.c_orderline_id 
                                      GROUP  BY CI.c_orderline_id, 
               CO.qtyordered), 0) ), l.qtyordered)            AS quantityOrder, 
               l.m_product_uom_id, 
               l.m_attributesetinstance_id, 
               l.taxbaseamt 
        FROM   c_orderline l 
               LEFT JOIN m_matchpo mp 
                      ON l.c_orderline_id = mp.c_orderline_id 
                         AND mp.c_invoiceline_id IS NOT NULL 
               LEFT JOIN c_order o 
                      ON l.c_order_id = o.c_order_id 
        GROUP  BY l.ad_org_id, 
                  l.c_currency_id, 
                  l.c_uom_id, 
                  l.m_product_id, 
                  l.line, 
                  l.description, 
                  l.c_orderline_id, 
                  l.qtyordered, 
                  l.quantityorder, 
                  l.m_product_uom_id, 
                  l.m_attributesetinstance_id, 
                  l.taxbaseamt, 
                  COALESCE(l.a_asset_id, o.a_asset_id), 
                  COALESCE(l.c_project_id, o.c_project_id), 
                  COALESCE(l.c_costcenter_id, o.c_costcenter_id), 
                  COALESCE(l.user1_id, o.user1_id), 
                  COALESCE(l.user2_id, o.user2_id), 
                  l.explode) A 
       LEFT JOIN (SELECT il.m_inoutline_id, 
                         il.c_orderline_id, 
                         ( il.movementqty - Sum(COALESCE(mi.qty, 0)) ) 
                                                           AS QTY, 
                         il.quantityorder * 
                         C_divide(( il.movementqty - Sum(COALESCE(mi.qty, 0)) ), 
                         ( il.movementqty )) AS 
                         quantityOrder, 
                         il.m_product_uom_id 
                  FROM   m_inoutline il 
                         LEFT JOIN m_matchinv mi 
                                ON il.m_inoutline_id = mi.m_inoutline_id, 
                         m_inout io 
                  WHERE  il.c_orderline_id IS NOT NULL 
                         AND io.m_inout_id = il.m_inout_id 
                         AND io.processed = 'Y' 
                  GROUP  BY il.m_inoutline_id, 
                            il.c_orderline_id, 
                            il.movementqty, 
                            il.quantityorder, 
                            il.m_product_uom_id 
                  HAVING ( il.movementqty - Sum(COALESCE(mi.qty, 0)) ) <> 0) B 
              ON A.c_orderline_id = B.c_orderline_id 
WHERE  A.c_uom_id = uom.c_uom_id 
       AND cur.c_currency_id = A.c_currency_id 
       AND A.m_product_id = p.m_product_id 
       AND A.c_orderline_id IN ( '632B1284EB114531A8FEAEACE488C0F3', 
                                 'C63CC19F80564EFFAE6901A556906DB5', 
                                 'E48F5E01236B4C52892E05E8EDE7B01B' 
                                   ) 
ORDER  BY A.line