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.OKL_STRY_CALL_CO_PUB dependencies on PO_VENDOR_SITES_ALL

Line 171: --,po_vendor_sites_all pvs

167: FROM iex_cases_all_b ica
168: ,iex_case_objects ico
169: ,okc_k_party_roles_v opr
170: ,po_vendors pv
171: --,po_vendor_sites_all pvs
172: WHERE ica.case_number = cp_case_number
173: AND ica.cas_id = ico.cas_id
174: AND ico.object_id =opr.dnz_chr_id
175: AND opr.rle_code = 'OKL_VENDOR'

Line 212: FROM po_vendor_sites_all pvs

208:
209: --get vendor email address
210: CURSOR l_email_csr(cp_vendor_site_code IN VARCHAR2) IS
211: SELECT pvs.email_address
212: FROM po_vendor_sites_all pvs
213: WHERE pvs.vendor_site_code = cp_vendor_site_code;
214:
215: l_id1 VARCHAR2(200) := NULL;
216: l_id2 VARCHAR2(200) := NULL;