APPS.POA_SAVINGS_SAV dependencies on PO_LINES_ALL

Line 89: , po_lines_all plc

85: )
86: )
87: INTO v_lowest_price
88: FROM po_headers_all phc
89: , po_lines_all plc
90: WHERE phc.type_lookup_code = 'BLANKET'
91: and phc.po_header_id = plc.po_header_id
92: and plc.unit_meas_lookup_code = p_unit_meas_lookup_code
93: and p_creation_date between nvl(phc.start_date, p_creation_date)

Line 226: FROM po_lines_all plc,

222: p_edw_global_currency_code,
223: p_rate_date,
224: p_edw_global_rate_type
225: ) conv_rate
226: FROM po_lines_all plc,
227: po_headers_all phc
228: WHERE phc.po_header_id = plc.po_header_id
229: and plc.unit_meas_lookup_code = p_unit_meas_lookup_code
230: and p_creation_date between nvl(phc.start_date, p_creation_date)

Line 422: , po_lines_all plc

418:
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

Line 449: , po_lines_all plc

445:
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

Line 486: FROM po_lines_all plc

482:
483: x_progress := '070';
484: OPEN v_cursor_po_line for
485: SELECT plc.po_line_id
486: FROM po_lines_all plc
487: WHERE plc.po_header_id = v_blanket_id
488: and plc.item_id = p_item_id
489: and plc.price_break_lookup_code = 'CUMULATIVE'
490: and plc.unit_meas_lookup_code = p_unit_meas_lookup_code

Line 538: FROM po_lines_all plc

534: x_progress := '110';
535: v_lowest_price := NULL;
536: /*
537: SELECT min(plc.unit_price) INTO v_lowest_price
538: FROM po_lines_all plc
539: WHERE plc.po_line_id = v_po_line_id;
540: */
541: END;
542: