Dependent value Set: ==================== This is another LOV which will be used to displays the list of values which are depending on the previous parameter value. Before going to create Dependent first we have to create Independent then we have to create Dependent First parameter will be Independent Second parameter will be Dependent. Note:Without Independent we can not create Dependent Value set. Country IND US UK City Banglore Chennai Delhi Mumbai Pune Chikago California Anderson London Hungrant 1)We have to create Independent value set and enter the values. 2)Create Dependent value set attach independent and then enter values. Job Manager Developer Programmer Position Delivery Manager Project manager Financce manager Software Developer Test Developer Trainee Fresher Table Value set : Table value set will be used to displays the list of values from the oracle apps base tables. we have to give the table name and column name which will automatically displays the values. Note: If values are not stored in the database table then we have to go for Independent value set. If values are there in the table then we will create table value set. 1.Open the value set form Select validation type as table select the button called Edit Information enter table name and column name in the value field 2.Use where/Order By clause to implement Where/Order By clause. 3.Use Additional Columns field to displays extra columns for reference purpose. 4.Use the ID column to pass the ineternally other columns data for ex displaying username to the user and pass userID internally. 5.If multiple tables are required then enter the table names in the table name field with alias name and enter the Join Condition in the Where clause field. 6.If we know the table name we can find the Table application name from Application Developer responsibility Application Developer => Application => Database => table Query the records based on the table Name. Translated Independent and Translated Dependent: ================================================ Both value sets will work like Independent and Dependent value sets will be used to displays the transalation values which will be enabled if there is multilanguage implementation. Special and Pair: ================= Both Value sets will be used to displays the Flexfield data as LOV to the User.
No comments:
Post a Comment