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 = prha.requisition_header_id
       AND action_code = 'CANCEL'
       AND pah.object_type_code = 'REQUISITION';


Labels: ,

3 comments:

  1. cardoormirrorsDecember 8, 2016 at 12:39 PM

    good

    ReplyDelete
  2. sudhakarJanuary 23, 2017 at 6:43 PM

    Hi technicaly you are so genius Can you provide the code inbound interface using best example by following steps 1) sql loader control file transfer data from flat file to staging table 2)how to transfer data from staging to interface tables using plsql program 3) how to transfer data from interface tables to apps base tables using apps std program 4)validations
    please send me the best example code

    thanks a lot
    sudhakar
    sudhakar.kadiri@gmail.com

    ReplyDelete
  3. NeeleshDecember 5, 2023 at 6:21 PM

    Thanks for sharing this blog.
    Budget family rooms in Ooty

    ReplyDelete

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