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 ...

  • AP Invoice Interface
    This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications. Interface t...
  • ACCOUNT PAYABLES (AP) TABLES IN ORACLE APPS
    ACCOUNT PAYABLES (AP) TABLES  Payables: Defining Bank accounts (supplier bank a/c and our internal bank a/c) Defining Supplier D...