APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_REQUISITION_LINES_ALL

Line 156: FROM po_requisition_lines_all prl

152: FROM po_requisition_headers_all
153: -- Bug 16778189- Use column_value instaed of requisition_header_id
154: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
155: AND NOT EXISTS (SELECT par_line_id
156: FROM po_requisition_lines_all prl
157: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl))
158: -- Use Exists clause instead of Not in
159: AND EXISTS (SELECT po_line_id FROM po_lines_draft_all plda WHERE prl.par_line_id = plda.po_line_id
160: AND mod_draft_id IS NOT NULL)) ;

Line 171: FROM po_requisition_lines_all

167: --Update the line status to returned for PAR document,if the par line doesnt exists on any mod.
168: UPDATE po_lines_draft_all
169: SET DRAFT_LINE_STATUS ='RETURNED'
170: WHERE po_line_id IN (SELECT par_line_id
171: FROM po_requisition_lines_all
172: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
173: --Bug 16778189 - Include draftId condition
174: AND draft_id IN (SELECT par_draft_id
175: FROM po_requisition_headers_all