APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 3364: FROM po_requisition_lines_all

3360: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3361:
3362: ELSIF p_doc_level='LINE' THEN
3363: SELECT requisition_header_id into l_req_document_id
3364: FROM po_requisition_lines_all
3365: WHERE requisition_line_id = p_doc_level_id ;
3366:
3367:
3368: SELECT Nvl(par_flag,'N')

Line 3375: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD

3371: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3372:
3373: ELSIF p_doc_level='DISTRIBUTION' THEN
3374: SELECT requisition_header_id into l_req_document_id
3375: FROM PO_REQUISITION_LINES_ALL POL, PO_REQ_DISTRIBUTIONS_ALL POD
3376: WHERE POL.REQUISITION_LINE_ID = POD.REQUISITION_LINE_ID
3377: AND POD.DISTRIBUTION_ID =p_doc_level_id;
3378:
3379:

Line 4742: , PO_REQUISITION_LINES_ALL PRL

4738: , PRD.CHANGE_IN_FUNDED_VALUE
4739: /* <> */
4740: FROM
4741: PO_REQ_DISTRIBUTIONS_ALL PRD
4742: , PO_REQUISITION_LINES_ALL PRL
4743: , PO_REQUISITION_HEADERS_ALL PRH
4744: , PO_SESSION_GT DIST_IDS
4745: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN
4746: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN

Line 5472: po_requisition_lines_all prl,

5468: BEGIN
5469: select nvl(pod.encumbered_flag, 'N')
5470: into l_found
5471: from po_req_distributions_all prd,
5472: po_requisition_lines_all prl,
5473: po_distributions_all pod
5474: where prd.distribution_id = p_req_dist_id
5475: and prl.requisition_line_id = prd.requisition_line_id
5476: and prl.document_type_code = 'BLANKET'