DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on OKC_K_PARTY_ROLES_V

Line 435: ,okc_k_party_roles_v opr

431: ,pv.vendor_name
432: --,pvs.email_address
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

Line 1485: ,okc_k_party_roles_v opr

1481: --how to obtain the vendor site
1482: CURSOR l_vendor_csr(cp_case_number in varchar2) IS SELECT pv.vendor_name
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