Hi Team,
We are using R12.2.3
Is there any way to write UNION in valueset WHERE Clause?
We have a requirement on JE Line DFF as:
Line DFF is with 3 segments Vendor Name, PO# and Invoice#
PO# is dependent on Vendor Name(Which means system has to show only POs under that Vendor)
Here, entering PO# is not mandatory
Invoice# is dependent on PO#. Here,
If user provided PO# then system has to show only Invoices under that PO
If no PO# is given, then system has to show all the Invoices under that Vendor
So, I created a valueset XX_VENDOR_NAME_VS for vendor names and XX_PO_NUMBER_VS for PO Numbers. Now, the issue comes on how to create XX_INVOICE_NUMBER_VS as PO# is not mandatory.
Can anyone please help me on this.
Thanks in Advance,
Srivathsava