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

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