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_CO_WF dependencies on PO_VENDOR_SITES_ALL

Line 437: --,po_vendor_sites_all pvs

433: FROM iex_cases_all_b ica
434: ,iex_case_objects ico
435: ,okc_k_party_roles_v opr
436: ,po_vendors pv
437: --,po_vendor_sites_all pvs
438: WHERE ica.case_number = cp_case_number
439: AND ica.cas_id = ico.cas_id
440: AND ico.object_id =opr.dnz_chr_id
441: AND opr.rle_code = 'OKL_VENDOR'

Line 478: FROM po_vendor_sites_all pvs

474:
475: --get vendor email address
476: CURSOR l_email_csr(cp_vendor_site_code IN VARCHAR2) IS
477: SELECT pvs.email_address
478: FROM po_vendor_sites_all pvs
479: WHERE pvs.vendor_site_code = cp_vendor_site_code;
480:
481: l_id1 VARCHAR2(200) := NULL;
482: l_id2 VARCHAR2(200) := NULL;

Line 1487: ,po_vendor_sites_all pvs

1483: FROM iex_cases_all_b ica
1484: ,iex_case_objects ico
1485: ,okc_k_party_roles_v opr
1486: ,po_vendors pv
1487: ,po_vendor_sites_all pvs
1488: WHERE ica.case_number = cp_case_number
1489: AND ica.cas_id = ico.cas_id
1490: AND ico.object_id =opr.dnz_chr_id
1491: AND opr.rle_code = 'OKL_VENDOR'