0 Replies Latest reply on Mar 28, 2013 2:20 PM by 999301

    Query for PO receipts distribution

    999301
      I am working on R12 PO Receipts and the issue is that there are 3780 instances where the PO_Distribution_ID is NULL and the rest of the PO information is available on the receiving transaction including the PO_ Line_location_id.
      In some cases, there are multiple distributions per receipt (it looks as if it might be split based on requisition distribution ids) and so the distribution ID could not hold a single value. The PO_Distribution_ID is not always populated and, in some cases, based on requisition distributions, there will be MULTIPLE PO_Distributions for the same receiving transactions. These can be found by using the rest of the PO_info -> line location ID to retrieve the Distribution row(s).

      Can i get a query to get a value for CCID for the null values?

      Edited by: 996298 on Mar 28, 2013 7:13 AM

      Edited by: 996298 on Mar 28, 2013 7:18 AM