Payables and Cash Management - EBS (MOSC)

MOSC Banner

Displaying Multiple Columns in a LOV based on table type Value Set..??

edited May 4, 2011 1:06AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
 
Ho to display multiple columns returned from a query in a LOV which is based on a table type Value Set ?

I have to display Payment_Batch, Payment_Date and Pay_Group from the following query

Select Cpa.Name     Payment_Batch
      ,Cpa.Pay_Date Payment_Date
      ,Cpga.Name    Pay_Group
  From Cn_Payruns_All    Cpa
      ,Cn_Pay_Groups_All Cpga
 Where Cpa.Status = 'PAID'
   And Cpa.Pay_Group_Id = Cpga.Pay_Group_Id
   And Not Exists (Select 1
          From Cn_Payment_Transactions_All Cpta
         Where Cpta.Payrun_Id = Cpa.Payrun_Id
           And Nvl(Cpta.Attribute15, 0) = 'INTERFACED');


Please suggest a possible way.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center