Oracle Fusion: Payables - AP Invoice URL Deep link Query

Requirement: User need to open AP Invoice Transaction from report output so need to provide a AP Invoice Deep link in the report output.

Solution:

 SELECT ('https://test.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId='

          || invoice_id)                                              --- URL

            url

from AP_INVOICES_ALL