select unique UOM_CODE lookup_code ,xx_code from xx.xx_tbl
where xx_code = :1
In Controller PR method:
OAAdvancedTableBean tableBean=
(OAAdvancedTableBean)oawebbean.findIndexedChildRecursive("ConstAreaDtlsTable"); OAMessageChoiceBean k = (OAMessageChoiceBean)oawebbean.findIndexedChildRecursive("choiceList"); k.setListVOBoundContainerColumn(0, tableBean,"DepColvalue1"); k.setListVOBoundContainerColumn(1, tableBean,"DepColvalue2"); k.setPickListCacheEnabled(false); // "DepColvalue1","DepColvalue2" are the Item ID in the page Structure and the choice list query execute based on these values for each row in Table Region Dynamically.