APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKX_VENDORS_V

Line 84: from okx_vendors_v

80: and item_name = p_item_name;
81:
82: CURSOR l_supp_name_csr IS
83: select id1
84: from okx_vendors_v
85: where name = p_supplier_name;
86:
87: CURSOR l_k_sts_csr IS
88: select k.sts_code, sts.ste_code

Line 110: l_supp_id okx_vendors_v.id1%type := null;

106:
107: l_chr_id okc_k_headers_b.id%type := null;
108: l_s_chr_id okc_k_headers_b.id%type := null;
109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;
114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;

Line 386: from okx_vendors_v

382: and item_name = p_item_name;
383:
384: CURSOR l_supp_name_csr IS
385: select id1
386: from okx_vendors_v
387: where name = p_supplier_name;
388:
389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;

Line 392: l_supp_id okx_vendors_v.id1%type := null;

388:
389: l_chr_id okc_k_headers_b.id%type := null;
390: l_s_chr_id okc_k_headers_b.id%type := null;
391: l_s_cle_id okc_k_lines_b.id%type := null;
392: l_supp_id okx_vendors_v.id1%type := null;
393: x_okl_cle_id okc_k_lines_b.id%type := null;
394: l_rel_vers_id number := null;
395:
396: lp_clev_rec OKL_SERVICE_INTEGRATION_PUB.clev_rec_type;