DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 1568: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl

1564: BEGIN
1565: SELECT prh.requisition_header_id, prh.segment1, prl.requisition_line_id, prl.line_num
1566: INTO l_material_rec.document_id, l_material_rec.document_number
1567: , l_material_rec.document_line_id, l_material_rec.document_line_num
1568: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl
1569: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1570: AND prh.requisition_header_id = prl.requisition_header_id
1571: AND prl.requisition_line_id = rsl.requisition_line_id;
1572: EXCEPTION