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

Line 887: FROM okc_k_lines_b cle

883: CURSOR l_cle_csr(p_cle_id IN NUMBER)
884: IS
885: SELECT cle.sts_code,
886: cle.dnz_chr_id
887: FROM okc_k_lines_b cle
888: WHERE cle.id = p_cle_id;
889:
890: l_cle_rec l_cle_csr%ROWTYPE;
891: l_chk_rebook_chr VARCHAR2(1);

Line 960: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

956: p_api_type => G_API_TYPE);
957: END check_line_update_allowed;
958: --Bug# 4959361
959: --added by asawanka
960: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
961: -- p_khr_id is contract id
962: FUNCTION get_asset_location(
963: p_kle_id IN NUMBER,
964: p_khr_id IN NUMBER)

Line 1074: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

1070: WHEN OTHERS THEN
1071: RETURN NULL;
1072: END get_asset_location;
1073: --added by asawanka
1074: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
1075: -- p_khr_id is contract id
1076: FUNCTION get_ast_install_loc_id(
1077: p_kle_id IN NUMBER,
1078: p_khr_id IN NUMBER)

Line 1189: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

1185: WHEN OTHERS THEN
1186: RETURN NULL;
1187: END get_ast_install_loc_id;
1188: --added by asawanka
1189: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
1190: -- p_khr_id is contract id
1191: FUNCTION get_booked_asset_number(
1192: p_kle_id IN NUMBER,
1193: p_khr_id IN NUMBER)

Line 1204: , OKC_K_LINES_B CLE_FA

1200: CURSOR l_get_booked_astnum_csr IS
1201: SELECT FAV.ASSET_NUMBER ASSETNUMBER
1202: FROM OKC_K_LINES_V CLE_FIN
1203: , OKC_LINE_STYLES_B LSE_FIN
1204: , OKC_K_LINES_B CLE_FA
1205: , OKC_LINE_STYLES_B LSE_FA
1206: , OKC_K_ITEMS CIM_FA
1207: , FA_ADDITIONS_B FAV
1208: WHERE CLE_FIN.CLE_ID IS NULL

Line 1612: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1608: x_return_status OUT NOCOPY VARCHAR2) IS
1609:
1610: cursor get_line_details_csr(p_chr_id in number) IS
1611: SELECT KLE.ID ID
1612: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1613: WHERE CLE.DNZ_CHR_ID = p_chr_id
1614: AND CLE.ID = KLE.ID
1615: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1616: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED')

Line 1623: okc_k_lines_b cle,

1619: cursor get_vendor_extid_csr(p_chr_id in number) is
1620: SELECT vDtls.ID
1621: FROM okl_party_payment_hdr vHdr,
1622: okl_party_payment_dtls vDtls,
1623: okc_k_lines_b cle,
1624: okl_k_lines kle
1625: WHERE vDtls.payment_hdr_id = vHdr.id
1626: AND vHdr.CLE_ID = cle.id
1627: AND vHdr.DNZ_CHR_ID = p_chr_id

Line 1728: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1724: x_return_status OUT NOCOPY VARCHAR2) IS
1725:
1726: cursor get_line_details_csr(p_chr_id in number) IS
1727: SELECT KLE.ID ID
1728: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1729: WHERE CLE.DNZ_CHR_ID = p_chr_id
1730: AND CLE.ID = KLE.ID
1731: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1732: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED')

Line 1737: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1733: AND kle.orig_contract_line_id is null;
1734:
1735: cursor get_upg_line_details_csr(p_orig_chr_id in number) IS
1736: SELECT kle.id, kle.orig_contract_line_id
1737: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1738: WHERE CLE.DNZ_CHR_ID = p_orig_chr_id
1739: AND CLE.ID = KLE.ID
1740: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1741: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED');

Line 1748: okc_k_lines_b cle,

1744: cursor get_vendor_extid_csr(p_chr_id in number) is
1745: SELECT vDtls.ID
1746: FROM okl_party_payment_hdr vHdr,
1747: okl_party_payment_dtls vDtls,
1748: okc_k_lines_b cle,
1749: okl_k_lines kle,
1750: okc_k_headers_all_b chr
1751: WHERE vDtls.payment_hdr_id = vHdr.id
1752: AND vHdr.CLE_ID = cle.id

Line 1774: okc_k_lines_b cle,

1770: cursor get_orig_vendor_dtls(p_orig_chr_id in number) IS
1771: SELECT vDtls.orig_contract_line_id, vDtls.vendor_id, cle.id
1772: FROM okl_party_payment_hdr vHdr,
1773: okl_party_payment_dtls vDtls,
1774: okc_k_lines_b cle,
1775: okl_k_lines kle
1776: WHERE vDtls.payment_hdr_id = vHdr.id
1777: AND vHdr.CLE_ID = cle.id
1778: AND vHdr.PASSTHRU_TERM = 'BASE'

Line 1871: where id in (select id FROM okc_k_lines_b b

1867: if t_extr_id_tbl.count > 0 then
1868: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1869: update okl_k_lines a
1870: set orig_contract_line_id = t_extr_id_tbl(i)
1871: where id in (select id FROM okc_k_lines_b b
1872: where orig_system_id1 = t_orig_cle_id_tbl(i)
1873: and dnz_chr_id = p_chr_id)
1874: and orig_contract_line_id is null;
1875: end if;

Line 1926: okc_k_lines_b cle

1922: where id in (
1923: SELECT vDtls.id
1924: FROM okl_party_payment_hdr vHdr,
1925: okl_party_payment_dtls vDtls,
1926: okc_k_lines_b cle
1927: WHERE vDtls.payment_hdr_id = vHdr.id
1928: AND vHdr.CLE_ID = cle.id
1929: AND vHdr.PASSTHRU_TERM = 'BASE'
1930: AND vHdr.DNZ_CHR_ID = cle.dnz_chr_id