BI Publisher (MOSC)

MOSC Banner

Defining parameters in a Concurrent Program with user parameters

edited Aug 15, 2013 4:19AM in BI Publisher (MOSC) 2 commentsAnswered
Hi all,

I'm a bit new to the technical side of EBS. I have a query which runs perfectly in Toad with the following parameters. Can someone tell me how i can link these parameters to a concurrent request which can be run from the application?

Thanks
Miranga


and :p_SEG1_1<= glcc.SEGMENT1 and :p_SEG1_2 >= glcc.SEGMENT1
and :p_SEG2_1<= glcc.SEGMENT2 and :p_SEG2_2 >= glcc.SEGMENT2
and :p_SEG3_1<= glcc.SEGMENT3 and :p_SEG3_2 >= glcc.SEGMENT3
and :p_SEG4_1<= glcc.SEGMENT4 and :p_SEG4_2 >= glcc.SEGMENT4
and :p_SEG5_1<= glcc.SEGMENT5 and :p_SEG5_2 >= glcc.SEGMENT5
and :p_SEG6_1<= glcc.SEGMENT6 and :p_SEG6_2 >= glcc.SEGMENT6

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