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.PON_SUPPLIER_RESEARCH_PVT dependencies on PO_HEADERS

Line 222: po_headers poh

218: l_total_bpa,
219: l_total_cpa
220: FROM po_vendors pv,
221: hz_parties hp,
222: po_headers poh
223: WHERE hp.party_id = p_tp_id
224: AND poh.vendor_id = pv.vendor_id
225: AND poh.authorization_status NOT IN
226: ( 'IN PROCESS','INCOMPLETE','REQUIRES REAPPROVAL')

Line 277: po_headers poh

273: INTO l_total_spo,
274: l_total_bpa,
275: l_total_cpa
276: FROM po_vendors pv,
277: po_headers poh
278: WHERE pv.vendor_id = p_vendor_id
279: AND poh.vendor_id = pv.vendor_id
280: AND poh.authorization_status NOT IN
281: ( 'IN PROCESS','INCOMPLETE','REQUIRES REAPPROVAL')

Line 324: po_headers poh

320: INTO l_tot_po_rel
321: FROM po_vendors pv,
322: hz_parties hp,
323: po_releases_all por,
324: po_headers poh
325: WHERE hp.party_id = p_tp_id
326: AND poh.PO_HEADER_ID = por.PO_HEADER_ID
327: AND por.release_type = 'BLANKET'
328: AND poh.authorization_status NOT IN

Line 371: po_headers poh

367: SELECT COUNT(*) total_po_releases
368: INTO l_tot_po_rel
369: FROM po_vendors pv,
370: po_releases_all por,
371: po_headers poh
372: WHERE pv.vendor_id = p_vendor_id
373: AND poh.vendor_id = pv.vendor_id
374: AND poh.PO_HEADER_ID = por.PO_HEADER_ID
375: AND por.release_type = 'BLANKET'