Financials for India - EBS (MOSC)

MOSC Banner

Using internal variable in Report Builder using SQL, but not making it a User Parameter

edited Feb 20, 2016 2:30AM in Financials for India - EBS (MOSC) Question

Hello All,

I have a plane SQL code for generating report using Oracle Report Builder tool, as mentioned below:

Select t1.a, t2.b,t1.c, t1.d from t1, t2

where t2.e in (Select t4.g from t4 where t4.f  in (Select t6.k from t6

                                                                      where t6.m = 'expression'

                                                                       and condition6

                                                                       and condition7

                                                                      )

                                                  and condition3

                                                  and condition4

                     )

and condition1

and condition2

Union all

Select t1.a, t2.b,t1.c, t1.d from t1, t2

where t2.e in (Select t4.g from t4 where t4.f  in (Select t6.k from t6

                                                                      where t6.m =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center