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


Unknown said...

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.