APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_DISTRIBUTIONS_ALL

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 855: , po_distributions_all pod

851: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
852: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
853: INTO l_return_val
854: FROM po_line_locations_all poll
855: , po_distributions_all pod
856: WHERE poll.po_line_id = p_line_id
857: AND pod.line_location_id = poll.line_location_id
858: AND pod.distribution_type = 'STANDARD'
859: ;

Line 1022: , po_distributions_all pod

1018: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1019: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1020: INTO l_return_val
1021: FROM po_line_locations_all poll
1022: , po_distributions_all pod
1023: WHERE poll.po_header_id = p_header_id
1024: AND pod.line_location_id = poll.line_location_id
1025: AND pod.distribution_type = 'STANDARD'
1026: ;

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 2647: FROM po_distributions_all

2643: , round((l_amount_ordered + nvl(nonrecoverable_tax,0))
2644: * nvl(rate,1)/l_mau) * l_mau
2645: , round((l_amount_ordered + nvl(nonrecoverable_tax,0)) * nvl(rate,1), l_precision))
2646: INTO l_return_val
2647: FROM po_distributions_all
2648: WHERE po_distribution_id = p_distribution_id;
2649:
2650: IF PO_LOG.d_proc THEN
2651: PO_LOG.proc_begin(d_mod,'Amount Ordered including Non Recoverable Tax ',l_return_val);

Line 3499: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

3495:
3496: l_distribution_id_tbl PO_TBL_NUMBER;
3497: l_distribution_rev_num_tbl po_tbl_number;
3498: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3499: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3500: BEGIN
3501:
3502: IF PO_LOG.d_proc THEN
3503: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 3589: PO_DISTRIBUTIONS_ALL POD

3585: SUM( nvl(POD.retainage_withheld_amount,0) ),
3586: SUM( nvl(POD.retainage_released_amount,0) )
3587: FROM
3588: PO_LINE_LOCATIONS_ALL POLL,
3589: PO_DISTRIBUTIONS_ALL POD
3590: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3591: AND POD.line_location_id = POLL.line_location_id
3592: GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,
3593: POLL.payment_type, POLL.price_override, POLL.quantity_received, POLL.quantity_shipped,