APPS.PO_CONTROL_CHECKS dependencies on PO_REQUISITION_LINES_ALL

Line 69: FROM po_requisition_lines_all rl, po_line_locations_all s

65: --Rewrite, this procedure could now be called with these parameters passed
66: --as NULL instead of 0.
67: SELECT s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id, s.shipment_num
68: BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id, l_shipnum
69: FROM po_requisition_lines_all rl, po_line_locations_all s
70: WHERE rl.line_location_id = s.line_location_id
71: AND ( (p_doctyp = 'REQUISITION' and rl.requisition_header_id = p_docid)
72: OR (p_doctyp = 'PO' and s.po_header_id = p_docid)
73: OR (p_doctyp = 'RELEASE' and s.po_release_id = p_docid)