LINE_LOCATION_ID in POR_REQUISITION_LINES_ALL

Summary

LINE_LOCATION_ID column is not populated for any requisition record

Content

As per requisition lines table structure in R12 i.e. PO_REQUISITION_LINES_ALL is having column as LINE_LOCATION_ID, which is for identifying the purchase order shipment line on which users have placed the requisition. LINE_LOCATION_ID is null if users have not placed the requisition line on a purchase order.

R12 Community Thread:

https://community.oracle.com/thread/3759046

In Oracle Self Service Procurement Cloud, under table POR_REQUISITION_LINES_ALL, we have the same column i.e. LINE_LOCATION_ID, which is suppose to capture the details for Document shipment schedule unique identifier, as per the following link.