APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 3301: FROM po_requisition_lines_all

3297: IF p_doc_level ='HEADER' THEN
3298: l_req_document_id := p_doc_level_id;
3299: ELSIF p_doc_level='LINE' THEN
3300: SELECT requisition_header_id into l_req_document_id
3301: FROM po_requisition_lines_all
3302: WHERE requisition_line_id = p_doc_level_id ;
3303: ELSIF p_doc_level='DISTRIBUTION' THEN
3304: SELECT requisition_header_id into l_req_document_id
3305: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD

Line 3305: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD

3301: FROM po_requisition_lines_all
3302: WHERE requisition_line_id = p_doc_level_id ;
3303: ELSIF p_doc_level='DISTRIBUTION' THEN
3304: SELECT requisition_header_id into l_req_document_id
3305: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD
3306: WHERE POL.REQUISITION_LINE_ID = POD.REQUISITION_LINE_ID
3307: AND POD.DISTRIBUTION_ID =p_doc_level_id;
3308: END IF;
3309: END IF;

Line 4528: , PO_REQUISITION_LINES_ALL PRL

4524: , PRD.expenditure_item_date
4525: , PRL.vendor_id
4526: FROM
4527: PO_REQ_DISTRIBUTIONS_ALL PRD
4528: , PO_REQUISITION_LINES_ALL PRL
4529: , PO_REQUISITION_HEADERS_ALL PRH
4530: , PO_SESSION_GT DIST_IDS
4531: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN
4532: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN

Line 5225: po_requisition_lines_all prl,

5221: BEGIN
5222: select nvl(pod.encumbered_flag, 'N')
5223: into l_found
5224: from po_req_distributions_all prd,
5225: po_requisition_lines_all prl,
5226: po_distributions_all pod
5227: where prd.distribution_id = p_req_dist_id
5228: and prl.requisition_line_id = prd.requisition_line_id
5229: and prl.document_type_code = 'BLANKET'