Records with null value not in output

5 pts.
Tags:
NULL
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
ASKED: August 15, 2008  2:46 PM
UPDATED: August 15, 2008  6:05 PM

Answer Wiki

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

Hi,

Have a look at this website…

http://www.webmasterworld.com/forum88/6064.htm

or

http://www.spss.com/corpinfo/newsletter/0107_tip.htm

Hope this helps…

Regards,

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following