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?