Dependent Parameters in oracle Concurrent Program
Hi Friends, We are going to discuss about Dependent Parameters in oracle Concurrent Program. Dependent parameter in concurrent program means , based on the value selected by the user in the first parameter , the second parameter list of value will be show. It means second parameter list of value will depend upon the value selected by user in the first parameter.Dependent parameters depends upon the parent parameter. What ever the input will be given in the parent parameter the other dependent parameter list of value will be affected. In this post , We will share the real time business example in which we will try to create the dependent parameters in oracle concurrent program. $FLEX$ is the oracle feature which helps to implement the dependent parameter in oracle concurrent program. Please find below the detail about Dependent Parameters in oracle Concurrent Program.
Real Time Example of Dependent Parameters in oracle Concurrent Program
In this Post , We are sharing one example in which we have the concurrent program. In concurrent program , we have two parameters. First Parameter is Supplier and second parameter is supplier site.
We want that the Second parameter Supplier site should depend upon the first parameter supplier.It means , What ever the supplier we will select in the supplier first parameter based on that only those supplier sites will be show in the second supplier site parameter.
Step by step to Implement Dependent Parameters in oracle Concurrent Program
Step 1:- For example , here below is the First Supplier Parameter. We have the value set "XX_VENDORS".
 |
| Dependent Parameters in oracle Concurrent Program |
Step 2:- Here below is the Value set(XX_VENDORS) we have created for first parameter "Supplier".
 |
| Dependent Parameters in oracle Concurrent Program |
 |
| Dependent Parameters in oracle Concurrent Program |
Step 3:-Here below is the Supplier Site Parameter for the report.But first we need to create the Supplier site valueset.
 |
| Dependent Parameters in oracle Concurrent Program |
Step 4:-
Here below is the Value set(XX SUPPLIER SITE) we have created for second parameter "Supplier Site".
Table Name : AP_SUPPLIERS A1,AP_SUPPLIER_SITES_ALL A2
Where Condition : WHERE A1.VENDOR_ID=A2.VENDOR_ID
AND A1.VENDOR_ID=:$FLEX$.XX_VENDORS
Column : A2.VENDOR_SITE_CODE
Step 5:-
 |
| Dependent Parameters in oracle Concurrent Program |
0 comments:
Post a Comment