eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_SAVINGS_SAV dependencies on PO_HEADERS_ALL

Line 88: FROM po_headers_all phc

84: )
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

Line 227: po_headers_all phc

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)
231: and nvl(phc.end_date, p_creation_date)

Line 421: FROM po_headers_all phc

417: BEGIN
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

Line 448: FROM po_headers_all phc

444: v_match_location := FALSE;
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