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_VENDORS

Line 436: ,po_vendors pv

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
440: AND ico.object_id =opr.dnz_chr_id

Line 730: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

726: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
727: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
728:
729: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
730: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
731: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
732: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
733: l_subject VARCHAR2(2000);
734: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;

Line 731: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

727: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
728:
729: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
730: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
731: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
732: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
733: l_subject VARCHAR2(2000);
734: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
735: l_from VARCHAR2(2000);

Line 1131: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

1127: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1128:
1129: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
1130: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
1131: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
1132: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
1133: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1134: l_subject VARCHAR2(2000);
1135: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;

Line 1132: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

1128:
1129: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
1130: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
1131: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
1132: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
1133: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
1134: l_subject VARCHAR2(2000);
1135: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
1136: l_from VARCHAR2(2000);

Line 1486: ,po_vendors pv

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
1490: AND ico.object_id =opr.dnz_chr_id

Line 1495: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

1491: AND opr.rle_code = 'OKL_VENDOR'
1492: AND opr.object1_id1 = pv.vendor_id
1493: AND pv.vendor_id = pvs.vendor_id;
1494:
1495: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
1496: BEGIN
1497: FOR cur IN l_vendor_csr(p_case_number) LOOP
1498: l_vendor_name := cur.vendor_name;
1499: exit;