Link from PO to Requisition: Table with related column:
PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID(Requisition distribution unique identifier)
If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the purchase order.
For Requisition: PO_REQ_DISTRIBUTIONS_ALL has REQ_DISTRIBUTION_ID
Link from Requisition to PO: PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID(Document shipment schedule unique identifier )
LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order.
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.
For Purchase Order: PO_LINE_LOCATIONS_ALL table has LINE_LOCATION_ID column.
PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID(Requisition distribution unique identifier)
If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the purchase order.
For Requisition: PO_REQ_DISTRIBUTIONS_ALL has REQ_DISTRIBUTION_ID
Link from Requisition to PO: PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID(Document shipment schedule unique identifier )
LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order.
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.
For Purchase Order: PO_LINE_LOCATIONS_ALL table has LINE_LOCATION_ID column.
