APPS.RCV_ROI_RETURN dependencies on PO_LINE_LOCATIONS

Line 304: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%TYPE;

300: x_first_trans BOOLEAN := TRUE;
301: x_sysdate DATE := SYSDATE;
302: current_n BINARY_INTEGER := 0;
303: insert_into_table BOOLEAN := FALSE;
304: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%TYPE;
305: tax_amount_factor NUMBER;
306: po_asn_uom_qty NUMBER;
307: po_primary_uom_qty NUMBER;
308: already_allocated_qty NUMBER := 0;

Line 962: FROM po_line_locations pll,

958: * default_return_rec.po_unit_price;
959: */
960: SELECT NVL(pll.price_override, pl.unit_price)
961: INTO x_cascaded_table(n).po_unit_price
962: FROM po_line_locations pll,
963: po_lines pl
964: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
965: AND pl.po_line_id = x_cascaded_table(n).po_line_id
966: AND pl.po_line_id = pll.po_line_id;