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_VENDORS

Line 220: FROM po_vendors pv,

216: SUM(DECODE(type_lookup_code, 'CONTRACT', 1,0)) total_cpa
217: INTO l_total_spo,
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

Line 276: FROM po_vendors pv,

272: SUM(DECODE(type_lookup_code, 'CONTRACT', 1,0)) total_cpa
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

Line 321: FROM po_vendors pv,

317:
318: -- Fetch the total purchasing releases
319: SELECT COUNT(*) total_po_releases
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

Line 369: FROM po_vendors pv,

365:
366: -- Fetch the total purchasing releases
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