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
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
2 comments:
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Post a Comment