问在日期参数处查询失败

EN

  FROM apps.ap_suppliers aps          ,
  apps.ap_invoices_all ai              ,
  apps.ap_invoice_lines_all ail        ,
  apps.ap_invoice_distributions_all aid,
  apps.AP_DISTRIBUTION_SETS_all ads    ,
  apps.gl_code_combinations_kfv gcc    ,
  apps.ap_checks_all aca               ,
  apps.ap_invoice_payments_all aipa    ,
  apps.FND_TERRITORIES_TL ft
  WHERE aps.vendor_id            = ai.vendor_id
AND ai.invoice_id                = ail.invoice_id
AND ai.invoice_id                = aid.invoice_id
AND ail.invoice_id               = aid.invoice_id
AND ai.DISTRIBUTION_SET_ID       = ads.DISTRIBUTION_SET_ID(+)
AND aid.dist_code_combination_id = gcc.code_combination_id
AND aca.check_id                 = aipa.check_id
AND aipa.invoice_id              = ai.invoice_id
AND aca.vendor_id                = aps.vendor_id
AND aca.vendor_id                = ai.vendor_id
AND aca.COUNTRY                  = ft.TERRITORY_CODE
AND ai.invoice_id =nvl(p_invoice_id,ai.invoice_id)
AND ai.last_update_date BETWEEN NVL(p_from_date,ai.last_update_date)
AND NVL(p_to_date,sysdate+1);