APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 2575: FROM PO_LINE_LOCATIONS_ALL PLL

2571: , g_order_type_RATE, 'Y'
2572: , 'N'
2573: )
2574: INTO l_amt_based_line_flag
2575: FROM PO_LINE_LOCATIONS_ALL PLL
2576: , PO_DISTRIBUTIONS_ALL POD
2577: WHERE POD.po_distribution_id = p_distribution_id
2578: AND PLL.line_location_id = POD.line_location_id
2579: ;

Line 3333: SELECT po_header_id into l_po_document_id FROM po_line_locations_all

3329: ELSIF p_doc_level='LINE' THEN
3330: SELECT po_header_id into l_po_document_id FROM po_lines_all
3331: WHERE po_line_id = p_doc_level_id ;
3332: ELSIF p_doc_level='SHIPMENT' THEN
3333: SELECT po_header_id into l_po_document_id FROM po_line_locations_all
3334: WHERE line_location_id = p_doc_level_id ;
3335: ELSIF p_doc_level='DISTRIBUTION' THEN
3336: SELECT po_header_id into l_po_document_id FROM po_distributions_all
3337: WHERE po_distribution_id = p_doc_level_id ;

Line 3343: SELECT po_header_id into l_rel_document_id FROM po_line_locations_all

3339: END IF;
3340:
3341: IF p_doc_type ='RELEASE' THEN
3342: IF p_doc_level='SHIPMENT' THEN
3343: SELECT po_header_id into l_rel_document_id FROM po_line_locations_all
3344: WHERE line_location_id = p_doc_level_id ;
3345: ELSIF p_doc_level='DISTRIBUTION' THEN
3346: SELECT po_header_id into l_rel_document_id FROM po_distributions_all
3347: WHERE po_distribution_id = p_doc_level_id ;

Line 4894: , PO_LINE_LOCATIONS_ALL POLL

4890: /* <> */
4891: , POD.amount_changed_flag -- <13503748>
4892: FROM
4893: PO_DISTRIBUTIONS_ALL POD
4894: , PO_LINE_LOCATIONS_ALL POLL
4895: , PO_LINES_ALL POL
4896: , PO_HEADERS_ALL POH
4897: , PO_SESSION_GT DIST_IDS
4898: WHERE POH.po_header_id = POD.po_header_id --JOIN