30- HOW TO CREATE LOV
A List of Values can be referenced by page items as well as report fields' It controls the values displayed and limits the user's selection' Lists of Values can be static (based on values you enter) or dynamic (based on a SQL query)
While entering the data in the column, we get help through select list, list of values' There are two types of List values like creation from static values and creation from dynamic values' Now we will analyse two sets of List of values' There is a column Ledger-type in Ledger-master table' It can accept either 'BS, or 'PL' (two letter code )' Whenever we go to that particular column, list of values should be vertically displayed as
'Balance Sheet Item' , 'Profit and Loss Account Item'' On selecting these two descriptive values, Codes should be returned and get stored in that column' This can be achieved through creation of LOV using static values' While entering the voucher-details entry, system should provide
Ledger Names vertically, and should return the value to that specified column' As and when we add entry on ledger-master, the dynamic values should get accommodated in the list of values' Hence creation of LOV using dynamic type is another choice'
→ APEx HOME PAGE
→ APPLICATION BUILDER
→ APPLICATION 110
→ SHARED COMPONENTS
→ UNDER USER INTERFACE
→ LIST OF VALUES