2 Replies Latest reply on Sep 18, 2015 10:59 AM by Bashar.

    Concurrent Program Parameters

    2795332

      Hi,

       

      Could you suggest on below.

       

      I have Select statement for sales orders, as shown below the WHERE clause has Order Number & Line Number.

      When user submits concurrent program, user will input multiple Sales Orders and its associated line and these input values will be from the value set.

      Could you let me know how I should setup the parameters for the concurrent program.

       

       

      Sales Order # 1345
      Line #1
      Sales Order # 2567
      Line #3
      Sales Order # 3234
      Line #2
      Sales Order # 4899
      Line #

      1

       

      ##########################################################

      WHERE 1 = 1

          AND ola.order_number     = oha.order_number

          AND sha.order_number    = oha.order_number

          AND sla.order_number     = sha.order_number

          AND sla.delivery_number = sha.delivery_number

          AND sla.so_line_number  = ola.line_number

          AND oha.order_number    = p_order_number

         AND ola.line_number        = p_line_number

       

       

      Thanks

        • 1. Re: Concurrent Program Parameters
          Jagadekara

          Hi,

           

          Provide value set queries, because we don't know how they gave multiple values?

          • 2. Re: Concurrent Program Parameters
            Bashar.

            Hi,

             

            If you are using 4 parameters for the sales order# and 4 parameters for the line# then just modify the where clause as follows:

             

            AND ((oha.order_number    = p_order_number1

                  AND ola.line_number        = p_line_number1)

                 or

                 (oha.order_number    = p_order_number2

                  AND ola.line_number        = p_line_number2)

                 or

                 (oha.order_number    = p_order_number3

                  AND ola.line_number        = p_line_number3)

                 or

                 (oha.order_number    = p_order_number4

                  AND ola.line_number        = p_line_number4))

             

            Regards,

            Bashar

            1 person found this helpful