Records with null value not in output

5 pts.
SQL Query
See query: select distinct f2.description Business_Unit, f3.description Department, f4.description Function, a.segment5 Account, f5.description Account_Description, sum(nvl(d.entered_dr,0) - nvl(d.entered_cr,0)) Actual, (Select sum(nvl(dd.entered_dr,0) - nvl(dd.entered_cr,0)) from apps.gl_je_headers_v cc, APPS.GL_JE_LINES_V dd, apps.gl_code_combinations aa, apps.fnd_flex_values_vl ff2, apps.fnd_flex_values_vl ff3, apps.fnd_flex_values_vl ff4, apps.fnd_flex_values_vl ff5, apps.gl_budget_versions ee where dd.code_combination_id = aa.CODE_COMBINATION_ID and dd.code_combination_id = d.code_combination_id and cc.JE_HEADER_ID = dd.JE_HEADER_ID and cc.BUDGET_VERSION_ID = ee.BUDGET_VERSION_ID AND aa.segment2 = ff2.flex_value AND aa.segment3 = ff3.flex_value AND aa.segment4 = ff4.flex_value AND aa.segment5 = ff5.flex_value and ee.BUDGET_NAME = '&Budget_Name' and aa.segment5 in ( '34001', '34002', '34011', '34012', '34013', '34014', '34015', '34016', '34051', '34052', '34053', '34054') and cc.actual_flag = 'B' AND ff2.flex_value_set_id = 1009628 AND ff3.flex_value_set_id = 1009629 AND ff4.flex_value_set_id = 1009630 AND ff5.flex_value_set_id = 1009631) Budget from apps.gl_je_headers_v c, APPS.GL_JE_LINES_V d, apps.gl_code_combinations a, apps.fnd_flex_values_vl f2, apps.fnd_flex_values_vl f3, apps.fnd_flex_values_vl f4, apps.fnd_flex_values_vl f5 where c.JE_HEADER_ID = d.JE_HEADER_ID and d.code_combination_id = a.CODE_COMBINATION_ID AND a.segment2 = f2.flex_value AND a.segment3 = f3.flex_value AND a.segment4 = f4.flex_value AND a.segment5 = f5.flex_value and c.actual_flag = 'A' and d.effective_Date between TO_CHAR(TO_DATE('01-APR-2007', 'DD-MON-YYYY')) and TO_CHAR(TO_DATE('31-MAR-2008', 'DD-MON-YYYY')) AND f2.flex_value_set_id = 1009628 AND f3.flex_value_set_id = 1009629 AND f4.flex_value_set_id = 1009630 AND f5.flex_value_set_id = 1009631 and a.segment5 in ( '34001', '34002', '34011', '34012', '34013', '34014', '34015', '34016', '34051', '34052', '34053', '34054') group by d.code_combination_id, f2.description, f3.description, f4.description, a.segment5, f5.description order by f2.description, f3.description, f4.description, f5.DESCRIPTION; My query is not showing the records where actual is null but budget has values. Please can you assist? Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.


Have a look at this website…


Hope this helps…


Discuss This Question:  

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: