APPS.RCV_ROI_RETURN dependencies on PO_LINE_LOCATIONS

Line 305: x_qty_rcv_exception_code po_line_locations.qty_rcv_exception_code%TYPE;

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

Line 342: FROM po_line_locations pll

338: WHERE transaction_id = v_parent_trx_id
339: AND rt.shipment_line_id = rsl.shipment_line_id
340: -- bug 8640033
341: AND NOT EXISTS(SELECT 'purchase order shipment cancelled or fc'
342: FROM po_line_locations pll
343: WHERE pll.line_location_id = rt.po_line_location_id
344: AND ( NVL(pll.cancel_flag, 'N') = 'Y'
345: OR NVL(pll.closed_code, 'OPEN') = 'FINALLY CLOSED'));
346: -- end bug 8640033

Line 842: po_line_locations pll

838: -- bug 8640033
839: SELECT MAX('record_exist')
840: INTO l_exist
841: FROM rcv_transactions rt,
842: po_line_locations pll
843: WHERE pll.line_location_id = rt.po_line_location_id
844: AND transaction_id = x_cascaded_table(n).parent_transaction_id
845: AND ( NVL(pll.cancel_flag, 'N') = 'Y'
846: OR NVL(pll.closed_code, 'OPEN') = 'FINALLY CLOSED');

Line 1019: FROM po_line_locations pll,

1015: * default_return_rec.po_unit_price;
1016: */
1017: SELECT NVL(pll.price_override, pl.unit_price)
1018: INTO x_cascaded_table(n).po_unit_price
1019: FROM po_line_locations pll,
1020: po_lines pl
1021: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
1022: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1023: AND pl.po_line_id = pll.po_line_id;