DBA Data[Home] [Help]

APPS.PO_SERVICES_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 678: FROM po_line_locations_all

674: SELECT sum(nvl(amount_received,0)),
675: sum(nvl(amount_billed,0))
676: INTO x_amount_received,
677: x_amount_billed
678: FROM po_line_locations_all
679: WHERE po_line_id = p_po_line_id
680: AND shipment_type = 'STANDARD';
681:
682: EXCEPTION

Line 857: FROM po_line_locations_all POLL,

853: l_count := 0;
854:
855: SELECT count(*)
856: INTO l_count
857: FROM po_line_locations_all POLL,
858: po_lines_all POL,
859: po_distributions_all POD
860: WHERE POLL.line_location_id = p_po_line_location_id
861: AND POL.po_line_id = POLL.po_line_id