APPS.PO_AUTOCREATE_DOC dependencies on PO_REQUISITION_HEADERS

Line 136: from po_requisition_headers

132: if (req_header_id is NOT NULL) then
133:
134: select org_id
135: into x_org_id
136: from po_requisition_headers
137: where requisition_header_id = req_header_id;
138:
139: end if;
140:

Line 291: from po_requisition_headers poh, po_requisition_lines pol

287: the same and change the cursor c1 to increase the performance
288:
289: cursor c1 is x_req_header_id is a parameter
290: select pol.requisition_line_id
291: from po_requisition_headers poh, po_requisition_lines pol
292: where line_location_id is null AND
293: nvl(pol.cancel_flag,'N') ='N' AND
294: nvl(pol.closed_code,'OPEN') <> 'FINALLY CLOSED' AND
295: nvl(modified_by_agent_flag,'N') ='N' AND

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:

Line 5553: FROM po_requisition_headers

5549: aname => 'REQ_HEADER_ID');
5550: BEGIN
5551: SELECT emergency_po_num
5552: INTO x_emergency_po_num
5553: FROM po_requisition_headers
5554: WHERE requisition_header_id=x_req_header_id;
5555: EXCEPTION
5556: WHEN OTHERS THEN
5557:

Line 5975: from po_requisition_headers hd,

5971: l_req_num,
5972: l_org_id,
5973: l_preparer_id,
5974: doc_subtype
5975: from po_requisition_headers hd,
5976: po_lookup_codes ty,
5977: po_lookup_codes st
5978: where hd.requisition_header_id = p_req_header_id
5979: and ty.lookup_type = 'DOCUMENT TYPE'

Line 6001: from po_requisition_headers hd,

5997: l_org_id,
5998: l_preparer_id,
5999: doc_subtype,
6000: ItemType
6001: from po_requisition_headers hd,
6002: po_document_types ty
6003: where hd.requisition_header_id = p_req_header_id
6004: and ty.document_type_code = 'REQUISITION'
6005: and ty.document_subtype = hd.TYPE_LOOKUP_CODE;