Query For find Last Query executed on the form

List the invoices for Trading Partner 'CDS, Inc' from the application.

Payables Manager > Invoices > Inquiry > Invoices > give "CDS, Inc" in the Trading Partner Name field > Find

Now we want to find the database query executed in the backend to show this data for you. Then goto

NAVIGATION:

 Help > Diagnostics > Examine
Enter the following values:
Block: SYSTEM
Field: LAST_QUERY

Value filed displays the Query for you.
Copy the query and executed in SQL Developer/TOAD/SQL Plus to check the same data!


Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...

  • OM INTERFACES
                                  OM INTERFACES Order Import Interface (Sales Order Conversion) Order Import enables you to import S...
  • PO INTERFACES
                                 PO INTERFACES The Purchasing Document Open Interface concurrent program was replaced by two new concurrent...