Second parameter should depend on first parameter

When i am running my report in apps i have to pass two parameters second parameter should be depend on first parameter. and in first parameter it consist two list of values
ex:1. approve 2. in process
when i pass approve in first parameter then second parameter should be enable and when i pass in process second parameter should be disabled. How this can be possible . i would appreciate if u people suggest correct answer.

Questions by kiran.sreesailam

Showing Answers 1 - 6 of 6 Answers

winalone3k

  • Mar 6th, 2008
 

second parameter should depend on first parameter because we have to specifie the parameters according to the required range. So what ever paremeter we specified first according to that we have to specifie second parameter, so thats why second parameter should depend on first parameter.

  Was this answer useful?  Yes

praveena challa

  • Feb 1st, 2009
 

For example take two parameters operating_unit and org_id.
IF ORG_ID is dependant on OPERATING_UNIT then we have to specify the following condition ($flex$operatins_unit value set name) in the where clause

ex:
WHERE order by org_id=$flex$operatins_unit value set name

  Was this answer useful?  Yes

selvaspak

  • Dec 28th, 2010
 

         For that you have to use the $FLEX$ command in the VALUE SET for Example

Parameters
1st  ORAGANIZATION_ID
                  Value set : XXSSG_ORG_ID

2nd INVENTORY_ITEM_ID
                 Value set : XXSSG_INV_ITM_ID

      In the 2nd value set you select the MTL_SYSTEM_ITEMS_B table and put the values too now you want to map with the 1st parameter for that you have to write the following command in the Where Clause of the 2nd parameter value set

                                   ORGANIZATION_ID = :$FLEX$.XXSSG_ORG_ID

     Now the 2nd parameter is depend on the 1st parameter

  Was this answer useful?  Yes

selvaspak

  • Dec 28th, 2010
 

In this senario we unable to disable the parameter for that what you can do like this

     In the 2nd parameter value set you have to hardcore in the where caluse like

                  'approve' = :$FLEX$.1st parameter value set

if you give like this means the 2nd parameter is enable but in the LOV it shows blank.

Manivasagam

  • Jul 9th, 2014
 

:$FLEX$.Value_ Set_Name

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions