APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 477: , po_requisition_headers_all PRH

473: SET ( PRS.record_status
474: , PRS.new_req_line_id ) = ( SELECT 'T'
475: , PRL.requisition_line_id
476: FROM po_requisition_lines_all PRL
477: , po_requisition_headers_all PRH
478: WHERE PRL.requisition_line_id = PRS.requisition_line_id
479: AND PRH.requisition_header_id = PRS.requisition_header_id
480: AND Nvl(PRH.FEDERAL_FLAG,'N') = 'Y'
481: )

Line 484: FROM po_requisition_headers_all PRH1

480: AND Nvl(PRH.FEDERAL_FLAG,'N') = 'Y'
481: )
482: WHERE nvl(PRS.record_status, 'NOVAL') <> 'C'
483: AND EXISTS (SELECT 'Y'
484: FROM po_requisition_headers_all PRH1
485: where PRH1.requisition_header_id = PRS.requisition_header_id
486: AND Nvl(PRH1.FEDERAL_FLAG,'N') = 'Y');
487:
488: l_progress :='039';

Line 2662: FROM po_requisition_headers_all

2658: -- SQL Why: Need to set org context to the OU where the
2659: -- requisition line is raised
2660: SELECT distinct org_id bulk collect
2661: INTO l_req_org_id
2662: FROM po_requisition_headers_all
2663: WHERE requisition_header_id IN
2664: (SELECT DISTINCT requisition_header_id
2665: FROM po_req_split_lines_gt);
2666: