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