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_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_LINES_B

Line 109: l_s_cle_id okc_k_lines_b.id%type := null;

105: and sty_name = p_item_name;
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;

Line 111: x_okl_cle_id okc_k_lines_b.id%type := null;

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;
115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;

Line 391: l_s_cle_id okc_k_lines_b.id%type := null;

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;
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:

Line 393: x_okl_cle_id okc_k_lines_b.id%type := null;

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;
397: lp_klev_rec OKL_SERVICE_INTEGRATION_PUB.klev_rec_type;

Line 973: FROM okc_k_lines_b cle

969:
970: -- Bug# 6438785
971: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS
972: SELECT cle.start_date
973: FROM okc_k_lines_b cle
974: WHERE cle.id = p_cle_id;
975:
976: l_orig_cle_rec c_orig_cle_csr%ROWTYPE;
977:

Line 1726: p_line_id OKC_K_LINES_B.ID%TYPE) IS

1722: FROM okc_k_headers_b head
1723: WHERE head.id = p_chr_id ;
1724:
1725: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1726: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1727: SELECT stream.capitalize_yn
1728: FROM okl_k_lines_full_v line,
1729: okc_k_items_v item,
1730: okl_strmtyp_source_v stream

Line 1744: l_start_date OKC_K_lineS_B.START_DATE%TYPE;

1740: AND status = 'A'
1741: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
1742: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
1743:
1744: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1745: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1746: l_amount NUMBER;
1747: l_capital_amount NUMBER;
1748: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

Line 1745: l_end_date OKC_K_lineS_B.END_DATE%TYPE;

1741: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
1742: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
1743:
1744: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1745: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1746: l_amount NUMBER;
1747: l_capital_amount NUMBER;
1748: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
1749: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE := null;

Line 2139: FROM okc_k_lines_b line,

2135: l_api_version NUMBER := 1.0;
2136:
2137: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2138: SELECT style.lty_code
2139: FROM okc_k_lines_b line,
2140: okc_line_styles_b style
2141: WHERE line.lse_id = style.id
2142: AND line.id = p_line_id;
2143: