Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternative function to WM_CONCAT

sliderrulesJun 18 2010 — edited Jun 18 2010
Hi,

I am using eBusiness Suite 11g containing an Oracle financials 10 database. The schema WMSYS is missing and I am unable to use WM_CONCAT function. Are there any other alternative functions or SQL that can help with cross-tabbing comma seperated values to avoid queries returning multiple lines.

For example:

JE_HEADER_ID SOURCE INVOICE_NUM DESC PO_NO AMOUNT

14055 Payables 38761 Paperchase 10145 461.55
14055 Payables 38761 Paperchase 10148 461.55

I would like the PO_NO to be concatenated on one line so that the query returns only one line as below:

JE_HEADER_ID SOURCE INVOICE_NUM DESC PO_NO AMOUNT

14055 Payables 38761 Paperchase 10145, 10148 461.55

Your feedback will be appreciated.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2010
Added on Jun 18 2010
4 comments
7,144 views