APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINE_LOCATIONS_MERGE_V

Line 329: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

325: *poll.price_override/l_mau) * l_mau
326: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
327: *poll.price_override),l_precision) )) -- Bug# 5378134
328: INTO l_return_val
329: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
330: WHERE poll.line_location_id = p_doc_level_id
331: AND poll.draft_id = p_draft_id;
332:
333: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 383: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

379: *poll.price_override/l_mau) * l_mau
380: , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
381: *poll.price_override),l_precision) )) -- Bug# 5378134
382: INTO l_return_val
383: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
384: , po_distributions_merge_v pod -- Changed from po_distributions_all
385: WHERE pod.po_distribution_id = p_doc_level_id
386: AND poll.line_location_id = pod.line_location_id
387: AND poll.draft_id = pod.draft_id

Line 2295: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

2291:
2292: BEGIN
2293: SELECT SUM(poll.quantity)
2294: INTO l_return_val
2295: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2296: WHERE poll.po_line_id = p_line_id
2297: AND poll.draft_id = p_draft_id
2298: AND poll.shipment_type = 'STANDARD';
2299: EXCEPTION

Line 2406: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all

2402: *poll.price_override/l_mau) * l_mau
2403: , round(((poll.quantity-nvl(poll.quantity_cancelled,0))
2404: *poll.price_override),l_precision) ) )) --Bug5391045
2405: INTO l_return_val
2406: FROM po_line_locations_merge_v poll -- Changed from po_line_locations_all
2407: WHERE poll.po_line_id = p_line_id
2408: AND poll.draft_id = p_draft_id
2409: AND poll.shipment_type = 'STANDARD'
2410: ;

Line 2751: FROM po_line_locations_merge_v poll

2747:
2748: d_position := 40;
2749: SELECT Min(poll.po_header_id)
2750: INTO l_header_id
2751: FROM po_line_locations_merge_v poll
2752: WHERE poll.line_location_id = p_doc_level_id;
2753:
2754: ELSIF p_doc_level = g_doc_level_DISTRIBUTION THEN
2755: