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

    How to query po details

    the past

      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
        • 1. Re: How to query po details



          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