APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 384: , po_distributions_merge_v pod -- Changed from po_distributions_all

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
388: AND poll.draft_id = p_draft_id;

Line 2479: FROM po_distributions_merge_v pod -- Changed from po_distributions_all

2475:
2476: BEGIN
2477: SELECT SUM(pod.quantity_ordered)
2478: INTO l_return_val
2479: FROM po_distributions_merge_v pod -- Changed from po_distributions_all
2480: WHERE pod.line_location_id = p_line_loc_id
2481: AND pod.draft_id = p_draft_id;
2482: EXCEPTION
2483: WHEN NO_DATA_FOUND THEN

Line 2550: FROM po_distributions_merge_v pod -- Changed from po_distributions_all

2546:
2547: BEGIN
2548: SELECT SUM(pod.amount_ordered)
2549: INTO l_return_val
2550: FROM po_distributions_merge_v pod -- Changed from po_distributions_all
2551: WHERE pod.line_location_id = p_line_loc_id
2552: AND pod.draft_id = p_draft_id;
2553: EXCEPTION
2554: WHEN NO_DATA_FOUND THEN

Line 2759: FROM po_distributions_merge_v pod

2755:
2756: d_position := 50;
2757: SELECT Min(pod.po_header_id)
2758: INTO l_header_id
2759: FROM po_distributions_merge_v pod
2760: WHERE pod.po_distribution_id = p_doc_level_id;
2761:
2762: END IF;
2763: