Thursday, June 28, 2012

Display Distinct Values in Oracle Apps Value Set

How to display distinct values in Oracle Apps valueset, below are possible options

1) Create a view to fetch distinct values from the TABLE and use the VIEW in the value-set

3) Write your query in such a way that it gives you a distinct value. You can make use of ROWID to meet the requirement.

  Example.      SELECT date_col
                      FROM   xx_custom_table xpr
                      WHERE  rowid = (select max(rowid) from  xx_custom_table xpr1
                                                    where xpr.date_col =xpr1.date_col)

at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

No comments: