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_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_LINE_STYLES_B

Line 565: OKC_LINE_STYLES_B OKS_COV_PD_LSE,

561: -- Check if the Financial asset is serviced thru OKS - Will return the OKL Contract
562: CURSOR link_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
563: SELECT KREL.chr_id okl_contract_id
564: FROM OKC_K_HEADERS_B OKS_CHRB,
565: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
566: OKC_K_LINES_B OKS_COV_PD_CLEB,
567: OKC_K_REL_OBJS KREL,
568: OKC_LINE_STYLES_B LNK_SRV_LSE,
569: OKC_STATUSES_B LNK_SRV_STS,

Line 568: OKC_LINE_STYLES_B LNK_SRV_LSE,

564: FROM OKC_K_HEADERS_B OKS_CHRB,
565: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
566: OKC_K_LINES_B OKS_COV_PD_CLEB,
567: OKC_K_REL_OBJS KREL,
568: OKC_LINE_STYLES_B LNK_SRV_LSE,
569: OKC_STATUSES_B LNK_SRV_STS,
570: OKC_K_LINES_B LNK_SRV_CLEB,
571: OKC_K_ITEMS LNK_SRV_CIM
572: WHERE OKS_CHRB.scs_code = 'SERVICE'

Line 713: OKC_LINE_STYLES_B LSE,

709: -- get assets with same status as contract
710: CURSOR get_contract_assets_no_csr (p_khr_id IN NUMBER) IS
711: SELECT COUNT(CLE.id) no_of_contract_assets
712: FROM OKC_K_LINES_B CLE,
713: OKC_LINE_STYLES_B LSE,
714: --OKC_STATUSES_B STS,
715: OKC_K_HEADERS_B CHR
716: WHERE CLE.lse_id = LSE.id
717: AND LSE.lty_code = 'FREE_FORM1'

Line 844: OKC_LINE_STYLES_B LSE,

840: -- get any additional assets on contract which are non terminated and not in quote
841: CURSOR get_additional_assets_csr (p_khr_id IN NUMBER, p_qte_id IN NUMBER) IS
842: SELECT 1
843: FROM OKC_K_LINES_B CLE,
844: OKC_LINE_STYLES_B LSE,
845: OKC_K_HEADERS_B CHR
846: WHERE CLE.lse_id = LSE.id
847: AND LSE.lty_code = 'FREE_FORM1'
848: AND CLE.sts_code = CHR.sts_code

Line 3518: OKC_LINE_STYLES_B LS1,

3514: cle1.id subsidy_line_id, -- smoduga ***
3515: nvl(kle1.subsidy_override_amount,nvl(kle1.amount,0)) subsidy_amount -- RMUNJULU 3280473
3516: from OKL_K_LINES KLE1,
3517: OKC_K_LINES_B CLE1,
3518: OKC_LINE_STYLES_B LS1,
3519: okl_subsidies_b SUB,
3520: okl_subsidies_tl subt,
3521: OKC_STATUSES_V STS1
3522: -- ,okl_sgn_translations sgn --RMUNJULU *** --rmunjulu bug 4399352

Line 4867: OKC_LINE_STYLES_B LTY

4863: -- rmunjulu TNA Get the FEE and SERVICE Top Lines
4864: CURSOR p_chr_lines_csr(p_chr_id IN NUMBER) IS
4865: SELECT CLE.ID
4866: FROM OKC_k_LINES_B CLE,
4867: OKC_LINE_STYLES_B LTY
4868: WHERE CLE.LSE_ID = LTY.ID
4869: AND LTY.LTY_CODE IN ('FEE', 'SOLD_SERVICE') -- rmunjulu TNA Give the proper Alias
4870: AND CLE.CHR_ID = p_chr_id; -- rmunjulu TNA Give the proper Alias
4871: