APPS.OE_DROP_SHIP_PVT dependencies on PO_LINE_LOCATIONS

Line 57: if p_potableused = 'po_line_locations' then

53:
54:
55: soqty := p_so_ordered_qty - p_so_cancelled_qty - p_so_shipped_quantity;
56:
57: if p_potableused = 'po_line_locations' then
58: begin
59: select sum(nvl(poll.quantity,0) - nvl(poll.quantity_cancelled,0) -
60: nvl(poll.quantity_shipped,0))
61: into

Line 63: from po_line_locations poll,

59: select sum(nvl(poll.quantity,0) - nvl(poll.quantity_cancelled,0) -
60: nvl(poll.quantity_shipped,0))
61: into
62: poqty
63: from po_line_locations poll,
64: so_drop_ship_sources sodss
65: where sodss.line_id = p_lineid
66: and poll.line_location_id = sodss.line_location_id
67: and sodss.header_id = p_headerid