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 543: OKC_LINE_STYLES_B OKS_COV_PD_LSE,

539: -- Check if the Financial asset is serviced thru OKS - Will return the OKL Contract
540: CURSOR link_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
541: SELECT KREL.chr_id okl_contract_id
542: FROM OKC_K_HEADERS_B OKS_CHRB,
543: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
544: OKC_K_LINES_B OKS_COV_PD_CLEB,
545: OKC_K_REL_OBJS KREL,
546: OKC_LINE_STYLES_B LNK_SRV_LSE,
547: OKC_STATUSES_B LNK_SRV_STS,

Line 546: OKC_LINE_STYLES_B LNK_SRV_LSE,

542: FROM OKC_K_HEADERS_B OKS_CHRB,
543: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
544: OKC_K_LINES_B OKS_COV_PD_CLEB,
545: OKC_K_REL_OBJS KREL,
546: OKC_LINE_STYLES_B LNK_SRV_LSE,
547: OKC_STATUSES_B LNK_SRV_STS,
548: OKC_K_LINES_B LNK_SRV_CLEB,
549: OKC_K_ITEMS LNK_SRV_CIM
550: WHERE OKS_CHRB.scs_code = 'SERVICE'

Line 691: OKC_LINE_STYLES_B LSE,

687: -- get assets with same status as contract
688: CURSOR get_contract_assets_no_csr (p_khr_id IN NUMBER) IS
689: SELECT COUNT(CLE.id) no_of_contract_assets
690: FROM OKC_K_LINES_B CLE,
691: OKC_LINE_STYLES_B LSE,
692: --OKC_STATUSES_B STS,
693: OKC_K_HEADERS_B CHR
694: WHERE CLE.lse_id = LSE.id
695: AND LSE.lty_code = 'FREE_FORM1'

Line 822: OKC_LINE_STYLES_B LSE,

818: -- get any additional assets on contract which are non terminated and not in quote
819: CURSOR get_additional_assets_csr (p_khr_id IN NUMBER, p_qte_id IN NUMBER) IS
820: SELECT 1
821: FROM OKC_K_LINES_B CLE,
822: OKC_LINE_STYLES_B LSE,
823: OKC_K_HEADERS_B CHR
824: WHERE CLE.lse_id = LSE.id
825: AND LSE.lty_code = 'FREE_FORM1'
826: AND CLE.sts_code = CHR.sts_code

Line 3496: OKC_LINE_STYLES_B LS1,

3492: cle1.id subsidy_line_id, -- smoduga ***
3493: nvl(kle1.subsidy_override_amount,nvl(kle1.amount,0)) subsidy_amount -- RMUNJULU 3280473
3494: from OKL_K_LINES KLE1,
3495: OKC_K_LINES_B CLE1,
3496: OKC_LINE_STYLES_B LS1,
3497: okl_subsidies_b SUB,
3498: okl_subsidies_tl subt,
3499: OKC_STATUSES_V STS1
3500: -- ,okl_sgn_translations sgn --RMUNJULU *** --rmunjulu bug 4399352

Line 4845: OKC_LINE_STYLES_B LTY

4841: -- rmunjulu TNA Get the FEE and SERVICE Top Lines
4842: CURSOR p_chr_lines_csr(p_chr_id IN NUMBER) IS
4843: SELECT CLE.ID
4844: FROM OKC_k_LINES_B CLE,
4845: OKC_LINE_STYLES_B LTY
4846: WHERE CLE.LSE_ID = LTY.ID
4847: AND LTY.LTY_CODE IN ('FEE', 'SOLD_SERVICE') -- rmunjulu TNA Give the proper Alias
4848: AND CLE.CHR_ID = p_chr_id; -- rmunjulu TNA Give the proper Alias
4849: