APPS.POA_SAVINGS_SAV dependencies on PO_LINE_LOCATIONS_ALL

Line 298: FROM po_line_locations_all psc

294: LOOP
295:
296: SELECT MIN(price_override) INTO v_price_override FROM (
297: SELECT price_override
298: FROM po_line_locations_all psc
299: WHERE psc.shipment_type = 'PRICE BREAK'
300: and psc.po_line_id = v_line_id
301: and psc.ship_to_location_id = p_ship_to_location_id
302: and psc.po_release_id is null

Line 312: FROM po_line_locations_all psc

308: psc.price_override ASC) WHERE ROWNUM = 1;
309:
310: SELECT MIN(price_override) INTO v_price_override_null FROM (
311: SELECT price_override
312: FROM po_line_locations_all psc
313: WHERE psc.shipment_type = 'PRICE BREAK'
314: and psc.po_line_id = v_line_id
315: and psc.ship_to_location_id IS null
316: and psc.po_release_id is null

Line 423: , po_line_locations_all psc

419: open v_cursor_blk for
420: SELECT distinct psc.po_header_id, phc.currency_code
421: FROM po_headers_all phc
422: , po_lines_all plc
423: , po_line_locations_all psc
424: WHERE psc.shipment_type = 'PRICE BREAK'
425: and phc.po_header_id = plc.po_header_id
426: and plc.po_line_id = psc.po_line_id
427: and psc.po_header_id = phc.po_header_id

Line 450: , po_line_locations_all psc

446: OPEN v_cursor_blk FOR
447: SELECT distinct psc.po_header_id, phc.currency_code
448: FROM po_headers_all phc
449: , po_lines_all plc
450: , po_line_locations_all psc
451: WHERE psc.shipment_type = 'PRICE BREAK'
452: and phc.po_header_id = plc.po_header_id
453: and plc.po_line_id = psc.po_line_id
454: and psc.po_header_id = phc.po_header_id

Line 519: FROM po_line_locations_all psc

515:
516: BEGIN
517: IF (v_match_location) then
518: SELECT min(psc.price_override) INTO v_lowest_price
519: FROM po_line_locations_all psc
520: WHERE Nvl(psc.quantity,0) <= Nvl(v_total_qty_released,0) + p_quantity
521: and psc.po_release_id is null
522: AND psc.ship_to_location_id = p_ship_to_location_id
523: and psc.po_line_id = v_po_line_id;

Line 526: FROM po_line_locations_all psc

522: AND psc.ship_to_location_id = p_ship_to_location_id
523: and psc.po_line_id = v_po_line_id;
524: else
525: SELECT min(psc.price_override) INTO v_lowest_price
526: FROM po_line_locations_all psc
527: WHERE Nvl(psc.quantity,0) <= Nvl(v_total_qty_released,0) + p_quantity
528: and psc.po_release_id is null
529: AND psc.ship_to_location_id IS NULL
530: and psc.po_line_id = v_po_line_id;