APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 380: , po_distributions_all pod

376: , round(((pod.quantity_ordered-nvl(pod.quantity_cancelled,0))
377: *poll.price_override),l_precision) )) -- Bug# 5378134
378: INTO l_return_val
379: FROM po_line_locations_all poll
380: , po_distributions_all pod
381: WHERE pod.po_distribution_id = p_doc_level_id
382: AND poll.line_location_id = pod.line_location_id
383: ;
384:

Line 846: , po_distributions_all pod

842: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
843: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
844: INTO l_return_val
845: FROM po_line_locations_all poll
846: , po_distributions_all pod
847: WHERE poll.po_line_id = p_line_id
848: AND pod.line_location_id = poll.line_location_id
849: AND pod.distribution_type = 'STANDARD'
850: ;

Line 1013: , po_distributions_all pod

1009: , round(pod.quantity_delivered*poll.price_override/l_mau) * l_mau
1010: , round((pod.quantity_delivered*poll.price_override),l_precision)) )) --Bug5391045
1011: INTO l_return_val
1012: FROM po_line_locations_all poll
1013: , po_distributions_all pod
1014: WHERE poll.po_header_id = p_header_id
1015: AND pod.line_location_id = poll.line_location_id
1016: AND pod.distribution_type = 'STANDARD'
1017: ;

Line 2463: FROM po_distributions_all pod

2459:
2460: BEGIN
2461: SELECT SUM(pod.quantity_ordered)
2462: INTO l_return_val
2463: FROM po_distributions_all pod
2464: WHERE pod.line_location_id = p_line_loc_id
2465: ;
2466: EXCEPTION
2467: WHEN NO_DATA_FOUND THEN

Line 2532: FROM po_distributions_all pod

2528:
2529: BEGIN
2530: SELECT SUM(pod.amount_ordered)
2531: INTO l_return_val
2532: FROM po_distributions_all pod
2533: WHERE pod.line_location_id = p_line_loc_id
2534: ;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN

Line 2640: FROM po_distributions_all pod

2636:
2637: d_position := 50;
2638: SELECT pod.po_header_id
2639: INTO l_header_id
2640: FROM po_distributions_all pod
2641: WHERE pod.po_distribution_id = p_doc_level_id;
2642:
2643: END IF;
2644:

Line 3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

3376:
3377: l_distribution_id_tbl PO_TBL_NUMBER;
3378: l_distribution_rev_num_tbl po_tbl_number;
3379: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3381: BEGIN
3382:
3383: IF PO_LOG.d_proc THEN
3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 3470: PO_DISTRIBUTIONS_ALL POD

3466: SUM( nvl(POD.retainage_withheld_amount,0) ),
3467: SUM( nvl(POD.retainage_released_amount,0) )
3468: FROM
3469: PO_LINE_LOCATIONS_ALL POLL,
3470: PO_DISTRIBUTIONS_ALL POD
3471: WHERE POD.po_distribution_id = l_distribution_id_tbl(i)
3472: AND POD.line_location_id = POLL.line_location_id
3473: GROUP BY POLL.line_location_id, POLL.value_basis, POLL.shipment_type,
3474: POLL.payment_type, POLL.price_override, POLL.quantity_received, POLL.quantity_shipped,