1 Reply Latest reply on Jun 24, 2020 12:27 PM by Bommi

    How to query po details

    the past
    the past May 5, 2020 6:54 PM

      Hi  I want select query   to select  data for purchase order

       

       

       

      S#PO #Created DateApproval DateStatusSupplierDescriptionPayment TypeDelivery DatePO TypeCurrencyPO AmountMRV AmountCommitted CostTolerance AmountTolerance %Un Billed AmountBilled AmountUn Paid AmountPaid Amount
      • 48 Views
      • Tags:
        • 1. Re: How to query po details
          Bommi
          Bommi Jun 24, 2020 12:27 PM (in response to the past)

          Hi,

           

          You have to join PO_HEADERS_ALL and PO_ACTION_HISTORY tables to find out the approval details (po_header_id is object_id in History table)

           

          For Supplier details you have to join PO_HEADERS_ALL with PO_VENDORS

           

          For PO Types, you have to use PO_DOCUMENT_TYPES_ALL_TL

           

          For details amounts, you have to join PO_LINES_ALL,PO_LINE_LOCATIONS_ALL and PO_DISTRIBUTIONS_ALL tables

           

           

          Please mark my answer as helpful if anyway helped you

           

           

          Regards,

          Bommi