APPS.PO_AUTOCREATE_DOC dependencies on PO_REQUISITION_HEADERS_ALL

Line 312: from po_requisition_headers_all poh, --

308: */
309:
310: cursor c1 is /* x_req_header_id is a parameter*/
311: select pol.requisition_line_id
312: from po_requisition_headers_all poh, --
313: po_requisition_lines pol
314: where x_req_header_id is null AND
315: line_location_id is null AND
316: nvl(pol.cancel_flag,'N') ='N' AND

Line 324: from po_requisition_headers_all poh, --

320: authorization_status = 'APPROVED' AND
321: poh.requisition_header_id = pol.requisition_header_id
322: union all
323: select pol.requisition_line_id
324: from po_requisition_headers_all poh, --
325: po_requisition_lines pol
326: where x_req_header_id is not null AND
327: poh.requisition_header_id = x_req_header_id AND
328: line_location_id is null AND

Line 357: po_requisition_headers_all prh --

353: CURSOR C_ConsumeReqLines is
354: SELECT prl.requisition_line_id
355: FROM po_lines pol,
356: po_requisition_lines prl,
357: po_requisition_headers_all prh --
358: WHERE pol.po_header_id=l_consume_req_demand_doc_id
359: AND prl.auction_header_id = pol.auction_header_id
360: AND prl.bid_line_number = pol.bid_line_number
361: AND prl.bid_number = pol.bid_number

Line 787: from po_requisition_headers_all phs, --

783: x_suggested_vendor_id,
784: x_suggested_vendor_site_id,
785: l_job_id, --
786: l_labor_req_line_id --
787: from po_requisition_headers_all phs, --
788: po_requisition_lines pls
789: where pls.requisition_line_id = x_req_line_id
790: and phs.requisition_header_id = pls.requisition_header_id;
791: