Search This Blog

Sunday, December 12, 2010

How to Use FND_STANDARD_DATE value set

Let’s take example of report – AP Invoices Paid in Time
Here GL_Date in Date parameter.
SELECT api.invoice_id, api.invoice_num, invoice_date, api.invoice_amount,
       api.vendor_name, api.vendor_number, apc.check_number, aps.due_date,
       apc.check_date
  FROM ap_invoices_v api,
       ap_payment_schedules_all aps,
       ap_invoice_payments_all aip,
       ap_checks_all apc
 WHERE api.invoice_id = aps.invoice_id
   AND aip.invoice_id = api.invoice_id
   AND aip.check_id = apc.check_id
   AND apc.check_date <= aps.due_date
   --and api.gl_date >= nvl(:p_gl_date,api.gl_date)
   AND api.gl_date >=
          NVL (TO_DATE (SUBSTR (:p_gl_date, 1, 10), 'YYYY/MM/DD'),
               api.gl_date)

That's it. Test the report through SRS window.

Stock Market in India Development of Stock Market in India 
 

4 comments:

  1. It's impressive that you are getting thoughts from this paragraph as well as from our argument made here.

    Feel free to surf to my page: knowabouteyes.Com

    ReplyDelete
  2. Nice effort, very informative, this will help me to complete my task. Thanks for share it keeps posting more blogs.
    Oracle Fusion HCM Technical Online Coaching

    ReplyDelete
  3. I have just read your site Your blog is so interesting,thanks for sharing.If you are looking for best Oracle financials Online Training institute.
    Oracle fusion financials training`

    ReplyDelete