APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_LINES_ALL

Line 3275: SELECT po_header_id into l_po_document_id FROM po_lines_all

3271: IF p_doc_type ='PO' OR p_doc_type='PA' THEN
3272: IF p_doc_level ='HEADER' THEN
3273: l_po_document_id := p_doc_level_id;
3274: ELSIF p_doc_level='LINE' THEN
3275: SELECT po_header_id into l_po_document_id FROM po_lines_all
3276: WHERE po_line_id = p_doc_level_id ;
3277: ELSIF p_doc_level='SHIPMENT' THEN
3278: SELECT po_header_id into l_po_document_id FROM po_line_locations_all
3279: WHERE line_location_id = p_doc_level_id ;

Line 4663: , PO_LINES_ALL POL

4659: , POH.vendor_id
4660: FROM
4661: PO_DISTRIBUTIONS_ALL POD
4662: , PO_LINE_LOCATIONS_ALL POLL
4663: , PO_LINES_ALL POL
4664: , PO_HEADERS_ALL POH
4665: , PO_SESSION_GT DIST_IDS
4666: WHERE POH.po_header_id = POD.po_header_id --JOIN
4667: AND POL.po_line_id(+) = POD.po_line_id --JOIN