APPS.POS_TOTALS_PO_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 613: FROM PO_LINE_LOCATIONS_ALL PLL

609: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)),
610: x_precision)
611: INTO p_amount_received,
612: p_amount_billed
613: FROM PO_LINE_LOCATIONS_ALL PLL
614: WHERE PLL.line_location_id = p_po_line_location_id;
615:
616: else
617: select round((DECODE(PLLA.matching_basis,

Line 642: FROM PO_LINE_LOCATIONS_ALL PLL

638: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0))
639: / x_min_unit) * x_min_unit)
640: INTO p_amount_received,
641: p_amount_billed
642: FROM PO_LINE_LOCATIONS_ALL PLL
643: WHERE pll.line_location_id = p_po_line_location_id;
644:
645: end if;
646:

Line 727: FROM po_line_locations_all pll

723: 'AMOUNT', NVL(PLL.amount_received, 0),
724: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0)),
725: x_precision))
726: INTO x_total_received
727: FROM po_line_locations_all pll
728: WHERE pll.po_header_id = p_po_header_id
729: AND pll.po_release_id is null;
730:
731: elsif (p_po_release_id is not null) then

Line 738: FROM po_line_locations_all pll

734: 'AMOUNT', NVL(PLL.amount_received, 0),
735: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0)),
736: x_precision))
737: INTO x_total_received
738: FROM po_line_locations_all pll
739: WHERE pll.po_release_id = p_po_release_id;
740:
741: end if;
742:

Line 751: FROM po_line_locations_all pll

747: 'AMOUNT', NVL(PLL.amount_received, 0),
748: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0))
749: / x_min_unit) * x_min_unit)
750: INTO x_total_received
751: FROM po_line_locations_all pll
752: WHERE pll.po_header_id = p_po_header_id
753: AND pll.po_release_id is null;
754:
755: elsif (p_po_release_id is not null) then

Line 762: FROM po_line_locations_all pll

758: 'AMOUNT', NVL(PLL.amount_received, 0),
759: 'QUANTITY', NVL(PLL.quantity_received, 0)*NVL(PLL.price_override, 0))
760: / x_min_unit) * x_min_unit)
761: INTO x_total_received
762: FROM po_line_locations_all pll
763: WHERE pll.po_release_id = p_po_release_id;
764:
765: end if;
766: END IF;

Line 814: FROM po_line_locations_all pll

810: 'AMOUNT', NVL(PLL.amount_billed, 0),
811: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)),
812: x_precision))
813: INTO x_total_invoiced
814: FROM po_line_locations_all pll
815: WHERE pll.po_header_id = p_po_header_id
816: AND pll.po_release_id is null;
817:
818: elsif (p_po_release_id is not null) then

Line 824: FROM po_line_locations_all pll

820: 'AMOUNT', NVL(PLL.amount_billed, 0),
821: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0)),
822: x_precision))
823: INTO x_total_invoiced
824: FROM po_line_locations_all pll
825: WHERE pll.po_release_id = p_po_release_id;
826:
827: end if;
828:

Line 837: FROM po_line_locations_all pll

833: 'AMOUNT', NVL(PLL.amount_billed, 0),
834: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0))
835: / x_min_unit) * x_min_unit)
836: INTO x_total_invoiced
837: FROM po_line_locations_all pll
838: WHERE pll.po_header_id = p_po_header_id
839: AND pll.po_release_id is null;
840:
841: elsif (p_po_release_id is not null) then

Line 848: FROM po_line_locations_all pll

844: 'AMOUNT', NVL(PLL.amount_billed, 0),
845: 'QUANTITY', NVL(PLL.quantity_billed, 0)*NVL(PLL.price_override, 0))
846: / x_min_unit) * x_min_unit)
847: INTO x_total_invoiced
848: FROM po_line_locations_all pll
849: WHERE pll.po_release_id = p_po_release_id;
850:
851: end if;
852: END IF;