12-06-2013, 01:05 AM
I have prepared the query to retrieve the Journal Approval Action History from Workflow tables. Below is the Query. This is the Form Personalization. In the Journal Screen i have attached the Menu Action History and placed this query for form personalization.
Now the problem is in GL_JE_BATCHES i have 80 thousand records. In the query which i have written i am getting only 1000 records. How can i achieve all the records.
SELECT DISTINCT gjb.NAME batch, default_period_name period,
'I', 'In Process',
'V', 'Validation Failed',
FROM wf_notifications wn, wf_items wi, gl_je_batches gjb
WHERE wn.CONTEXT LIKE
|| (SELECT item_key
FROM wf_items a
WHERE a.user_key = wi.user_key
AND a.item_type = 'GLBATCH'
AND ROWNUM = 1)
AND wi.item_type = wn.MESSAGE_TYPE
AND wi.user_key = gjb.NAME;
Can any one please suggest me how to proceed on this issue ASAP?