DBA Data[Home] [Help]

APPS.POS_PO_RCV_QTY dependencies on PO_LINE_LOCATIONS_ALL

Line 221: Added this funtion to get the qty_received from po_line_locations_all table

217: end get_net_received_qty;
218:
219:
220: /* Code changes for bug - 9502912 - Start
221: Added this funtion to get the qty_received from po_line_locations_all table
222: if the value in po_line_locations_archive_all is zero.
223: */
224:
225: FUNCTION Get_qty_rcv (line_loc_id IN NUMBER)

Line 232: FROM po_line_locations_all

228: qty_rec NUMBER;
229: BEGIN
230: SELECT quantity_received
231: INTO qty_rec
232: FROM po_line_locations_all
233: WHERE line_location_id = line_loc_id;
234:
235: RETURN qty_rec;
236: END get_qty_rcv;