Join Requisitions and Purchase Orders
Hi I need to join requisitions and purchase orders.
I know that the PO_DISTRIBUTIONS_ALL has the REQ_DISTRIBUTION_ID column which joins with PO_REQ_DISTRIBUTIONS_ALL column DISTRIBUTION_ID. But the REQ_DISTRIBUTION_ID is not null only in the first distribution line. In all other lines it is null. In this scenario only one shipment line( the first line ) is joined with requisitions. How can I join all the lines of the PO to the requisition ?
I will explain the exact scenario below:
A single line requisition which is auto-created into a Purchase order having one line and three shipment lines. Each shipment line has 1 distribution. Therefore there are 3 distribution lines.
I know that the PO_DISTRIBUTIONS_ALL has the REQ_DISTRIBUTION_ID column which joins with PO_REQ_DISTRIBUTIONS_ALL column DISTRIBUTION_ID. But the REQ_DISTRIBUTION_ID is not null only in the first distribution line. In all other lines it is null. In this scenario only one shipment line( the first line ) is joined with requisitions. How can I join all the lines of the PO to the requisition ?
I will explain the exact scenario below:
A single line requisition which is auto-created into a Purchase order having one line and three shipment lines. Each shipment line has 1 distribution. Therefore there are 3 distribution lines.
0