DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PO_REQUISITION_HEADERS_ALL

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

1635: BEGIN
1636: SELECT prh.requisition_header_id, prh.segment1, prl.requisition_line_id, prl.line_num
1637: INTO l_material_rec.document_id, l_material_rec.document_number
1638: , l_material_rec.document_line_id, l_material_rec.document_line_num
1639: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl
1640: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1641: AND prh.requisition_header_id = prl.requisition_header_id
1642: AND prl.requisition_line_id = rsl.requisition_line_id;
1643: EXCEPTION