2015-02-26 16:00:16 CAT [26136-1] customer LOG: duration: 240036.724 ms execute : SELECT ID, ACCOUNT_ID, NAME, SUM(SALDO_INICIAL) AS SALDO_INICIAL, SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR, SUM(SALDO_INICIAL+AMTACCTDR-AMTACCTCR) AS SALDO_FINAL, groupbyid, CASE $1 WHEN 'BPartner' THEN CASE ad_column_identifier(TO_CHAR('C_BPARTNER'), TO_CHAR(groupbyid), TO_CHAR($2)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('C_BPARTNER'), TO_CHAR(groupbyid), TO_CHAR($3)) END WHEN 'Product' THEN CASE ad_column_identifier(TO_CHAR('M_PRODUCT'), TO_CHAR(groupbyid), TO_CHAR($4)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('M_PRODUCT'), TO_CHAR(groupbyid), TO_CHAR($5)) END WHEN 'Project' THEN CASE ad_column_identifier(TO_CHAR('C_PROJECT'), TO_CHAR(groupbyid), TO_CHAR($6)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('C_PROJECT'), TO_CHAR(groupbyid), TO_CHAR($7)) END ELSE '' END AS groupbyname FROM ((SELECT ID, ACCOUNT_ID, NAME, 0 AS AMTACCTDR, 0 AS AMTACCTCR, COALESCE(SUM(AMTACCTDR-AMTACCTCR), 0) AS SALDO_INICIAL, groupbyname, groupbyid FROM ((SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, F.DATEACCT, CASE $8 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $9 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $10 AND f.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 1=1 AND EV.VALUE <= $11 AND F.DATEACCT < TO_DATE($12) AND F.C_ACCTSCHEMA_ID = $13 AND F.ISACTIVE = 'Y') UNION ALL (SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, F.DATEACCT, CASE $14 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $15 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $16 AND f.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 3=3 AND EV.VALUE <= $17 AND F.DATEACCT = TO_DATE($18) AND F.C_ACCTSCHEMA_ID = $19 AND F.FACTACCTTYPE = $20 AND F.ISACTIVE = 'Y' )) A GROUP BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ) UNION (SELECT ID, ACCOUNT_ID, NAME, SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR, 0 AS SALDO_INICIAL, groupbyname, groupbyid FROM (SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, CASE $21 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $22 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $23 AND f.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('AED0DD28A32C4FE3AC56EC12998BC337','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 2=2 AND EV.VALUE <= $24 AND DATEACCT >= TO_DATE($25) AND DATEACCT < TO_DATE($26) AND F.C_ACCTSCHEMA_ID = $27 AND F.FACTACCTTYPE <> $28 AND F.FACTACCTTYPE <> 'R' AND F.FACTACCTTYPE <> 'C' AND F.ISACTIVE = 'Y') B GROUP BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME HAVING SUM(AMTACCTDR) <> 0 OR SUM(AMTACCTCR) <> 0 )) C GROUP BY ACCOUNT_ID, ID, groupbyid, groupbyname, NAME ORDER BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME 2015-02-26 16:00:16 CAT [26136-2] customer DETAIL: parameters: $1 = NULL, $2 = 'en_US', $3 = 'en_US', $4 = 'en_US', $5 = 'en_US', $6 = 'en_US', $7 = 'en_US', $8 = NULL, $9 = NULL, $10 = 'S', $11 = '91700', $12 = '24-02-2015', $13 = 'FA251676C4A94502970CBBDCE2FD3873', $14 = NULL, $15 = NULL, $16 = 'S', $17 = '91700', $18 = '24-02-2015', $19 = 'FA251676C4A94502970CBBDCE2FD3873', $20 = 'O', $21 = NULL, $22 = NULL, $23 = 'S', $24 = '91700', $25 = '24-02-2015', $26 = '27-02-2015', $27 = 'FA251676C4A94502970CBBDCE2FD3873', $28 = 'O' 2015-02-27 11:34:17 CAT [29720-1] customer LOG: duration: 402067.418 ms execute : SELECT ID, ACCOUNT_ID, NAME, SUM(SALDO_INICIAL) AS SALDO_INICIAL, SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR, SUM(SALDO_INICIAL+AMTACCTDR-AMTACCTCR) AS SALDO_FINAL, groupbyid, CASE $1 WHEN 'BPartner' THEN CASE ad_column_identifier(TO_CHAR('C_BPARTNER'), TO_CHAR(groupbyid), TO_CHAR($2)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('C_BPARTNER'), TO_CHAR(groupbyid), TO_CHAR($3)) END WHEN 'Product' THEN CASE ad_column_identifier(TO_CHAR('M_PRODUCT'), TO_CHAR(groupbyid), TO_CHAR($4)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('M_PRODUCT'), TO_CHAR(groupbyid), TO_CHAR($5)) END WHEN 'Project' THEN CASE ad_column_identifier(TO_CHAR('C_PROJECT'), TO_CHAR(groupbyid), TO_CHAR($6)) WHEN '**' THEN '' ELSE ad_column_identifier(TO_CHAR('C_PROJECT'), TO_CHAR(groupbyid), TO_CHAR($7)) END ELSE '' END AS groupbyname FROM ((SELECT ID, ACCOUNT_ID, NAME, 0 AS AMTACCTDR, 0 AS AMTACCTCR, COALESCE(SUM(AMTACCTDR-AMTACCTCR), 0) AS SALDO_INICIAL, groupbyname, groupbyid FROM ((SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, F.DATEACCT, CASE $8 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $9 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $10 AND f.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01','2577FC4107D04AC18B5C8C29F464D179','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 1=1 AND EV.VALUE <= $11 AND F.DATEACCT < TO_DATE($12) AND F.C_ACCTSCHEMA_ID = $13 AND F.ISACTIVE = 'Y') UNION ALL (SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, F.DATEACCT, CASE $14 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $15 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $16 AND f.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01','2577FC4107D04AC18B5C8C29F464D179','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 3=3 AND EV.VALUE <= $17 AND F.DATEACCT = TO_DATE($18) AND F.C_ACCTSCHEMA_ID = $19 AND F.FACTACCTTYPE = $20 AND F.ISACTIVE = 'Y' )) A GROUP BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0 ) UNION (SELECT ID, ACCOUNT_ID, NAME, SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR, 0 AS SALDO_INICIAL, groupbyname, groupbyid FROM (SELECT F.ACCOUNT_ID AS ID, EV.VALUE AS ACCOUNT_ID, EV.NAME AS NAME, F.AMTACCTDR, F.AMTACCTCR, F.FACTACCTTYPE, CASE $21 WHEN 'BPartner' THEN c_bpartner.c_bpartner_id WHEN 'Product' THEN m_product.m_product_id WHEN 'Project' THEN c_project.c_project_id ELSE '' END AS groupbyid, CASE $22 WHEN 'BPartner' THEN to_char(c_bpartner.name) WHEN 'Product' THEN to_char(m_product.name) WHEN 'Project' THEN to_char(c_project.name) ELSE '' END AS groupbyname FROM C_ELEMENTVALUE EV, FACT_ACCT F LEFT JOIN C_BPARTNER ON f.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON f.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON f.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE F.ACCOUNT_ID = EV.C_ELEMENTVALUE_ID AND EV.ELEMENTLEVEL = $23 AND f.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01') AND F.AD_CLIENT_ID IN ('0','7B27EAB5E42841E0A0957AF0B16CCB3B') AND F.AD_ORG_ID IN('2D164FEBDD474277B5AE9858AD9CBA01','2577FC4107D04AC18B5C8C29F464D179','1A6DAE74F0D440DF919CA5FA5236F0FC','0') AND 2=2 AND EV.VALUE <= $24 AND DATEACCT >= TO_DATE($25) AND DATEACCT < TO_DATE($26) AND F.C_ACCTSCHEMA_ID = $27 AND F.FACTACCTTYPE <> $28 AND F.FACTACCTTYPE <> 'R' AND F.FACTACCTTYPE <> 'C' AND F.ISACTIVE = 'Y') B GROUP BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME HAVING SUM(AMTACCTDR) <> 0 OR SUM(AMTACCTCR) <> 0 )) C GROUP BY ACCOUNT_ID, ID, groupbyid, groupbyname, NAME ORDER BY ACCOUNT_ID, ID, groupbyname, groupbyid, NAME 2015-02-27 11:34:17 CAT [29720-2] customer DETAIL: parameters: $1 = NULL, $2 = 'en_US', $3 = 'en_US', $4 = 'en_US', $5 = 'en_US', $6 = 'en_US', $7 = 'en_US', $8 = NULL, $9 = NULL, $10 = 'S', $11 = '91700', $12 = '26-02-2015', $13 = 'FA251676C4A94502970CBBDCE2FD3873', $14 = NULL, $15 = NULL, $16 = 'S', $17 = '91700', $18 = '26-02-2015', $19 = 'FA251676C4A94502970CBBDCE2FD3873', $20 = 'O', $21 = NULL, $22 = NULL, $23 = 'S', $24 = '91700', $25 = '26-02-2015', $26 = '27-02-2015', $27 = 'FA251676C4A94502970CBBDCE2FD3873', $28 = 'O'