Displaying Multiple Columns in a LOV based on table type Value Set..??
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.
Tagged:
0