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_INS_QUOTE_PVT dependencies on OKL_K_LINES

Line 1894: FROM OKL_K_LINES

1890: l_kle_id NUMBER := p_ipyv_rec.kle_id;
1891: l_dummy_var VARCHAR2(1) := '?';
1892: CURSOR okc_kle_csr IS
1893: SELECT 'x'
1894: FROM OKL_K_LINES
1895: WHERE OKL_K_LINES.ID = l_kle_id;
1896: BEGIN
1897: OPEN okc_kle_csr;
1898: FETCH okc_kle_csr INTO l_dummy_var ;

Line 1895: WHERE OKL_K_LINES.ID = l_kle_id;

1891: l_dummy_var VARCHAR2(1) := '?';
1892: CURSOR okc_kle_csr IS
1893: SELECT 'x'
1894: FROM OKL_K_LINES
1895: WHERE OKL_K_LINES.ID = l_kle_id;
1896: BEGIN
1897: OPEN okc_kle_csr;
1898: FETCH okc_kle_csr INTO l_dummy_var ;
1899: CLOSE okc_kle_csr ;

Line 4265: OKL_K_LINES KLE,

4261: FROM OKL_TXL_ASSETS_B OTAB,
4262: OKL_TXL_ASSETS_TL OTAT,
4263: OKX_ASST_CATGRS_V TL,
4264: OKL_INS_CLASS_CATS OICC,
4265: OKL_K_LINES KLE,
4266: OKL_K_LINES KLE_TOP,
4267: OKC_K_LINES_B CLE
4268: WHERE KLE.ID = OTAB.KLE_ID
4269: AND KLE.ID = CLE.ID

Line 4266: OKL_K_LINES KLE_TOP,

4262: OKL_TXL_ASSETS_TL OTAT,
4263: OKX_ASST_CATGRS_V TL,
4264: OKL_INS_CLASS_CATS OICC,
4265: OKL_K_LINES KLE,
4266: OKL_K_LINES KLE_TOP,
4267: OKC_K_LINES_B CLE
4268: WHERE KLE.ID = OTAB.KLE_ID
4269: AND KLE.ID = CLE.ID
4270: AND CLE.CLE_ID = KLE_TOP.ID

Line 4295: OKL_K_LINES KLE ,

4291: FROM OKL_TXL_ASSETS_B OTAB,
4292: OKL_TXL_ASSETS_TL OTAT,
4293: OKX_ASST_CATGRS_V TL,
4294: OKL_INS_CLASS_CATS OICC,
4295: OKL_K_LINES KLE ,
4296: OKL_K_LINES KLE_TOP ,
4297: OKC_K_LINES_B CLE ,
4298: OKL_K_HEADERS KHR
4299: WHERE KLE.ID = OTAB.KLE_ID

Line 4296: OKL_K_LINES KLE_TOP ,

4292: OKL_TXL_ASSETS_TL OTAT,
4293: OKX_ASST_CATGRS_V TL,
4294: OKL_INS_CLASS_CATS OICC,
4295: OKL_K_LINES KLE ,
4296: OKL_K_LINES KLE_TOP ,
4297: OKC_K_LINES_B CLE ,
4298: OKL_K_HEADERS KHR
4299: WHERE KLE.ID = OTAB.KLE_ID
4300: AND KLE.ID = CLE.ID

Line 4324: FROM OKL_K_LINES KLE ,

4320: TL.NAME ASSET_CATEGORY,
4321: OICC.IAC_CODE INSURANCE_CLASS_code,
4322: KLE.ID KLE_ID,
4323: FAD.ASSET_NUMBER ASSET_NUMBER
4324: FROM OKL_K_LINES KLE ,
4325: OKC_K_LINES_B CLE,
4326: OKC_LINE_STYLES_B LS,
4327: OKC_K_ITEMS CIM,
4328: OKC_K_LINES_TL OTL,

Line 4369: FROM OKL_K_LINES KLE,

4365: TL.NAME ASSET_CATEGORY,
4366: OICC.IAC_CODE INSURANCE_CLASS_code,
4367: KLE.ID KLE_ID,
4368: FINAN_CLET.NAME ASSET_NUMBER
4369: FROM OKL_K_LINES KLE,
4370: OKX_ASST_CATGRS_V TL,
4371: OKL_INS_CLASS_CATS OICC,
4372: OKC_K_LINES_B CLE,
4373: OKC_K_LINES_TL OTL,

Line 4428: OKL_K_LINES KLE,

4424: --- Cursor to check ASSET_CATEGORY
4425: cursor c_asset_category_valid (p_khr_id NUMBER) IS
4426: select 'x',OTAB.ASSET_NUMBER
4427: from OKL_TXL_ASSETS_B OTAB,
4428: OKL_K_LINES KLE,
4429: OKC_K_LINES_B CLE,
4430: OKC_LINE_STYLES_B LS
4431: WHERE OTAB.DNZ_KHR_ID = p_khr_id AND
4432: KLE.ID = OTAB.KLE_ID

Line 4464: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE

4460:
4461: -- To get capital amount of contarct
4462: CURSOR okl_k_capital_amt_csr (p_khr_id NUMBER) IS
4463: SELECT SUM(KLE.CAPITAL_AMOUNT) --,SUM(KLE.OEC)
4464: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE
4465: WHERE CLEB.ID = KLE.ID
4466: AND CLEB.DNZ_CHR_ID = p_khr_id
4467: AND CLEB.CLE_ID IS NULL
4468: GROUP BY CLEB.DNZ_CHR_ID ;

Line 4484: OKL_K_LINES KLE,

4480: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,
4481: KLE_TOP.OEC OEC,
4482: OTAB.ASSET_NUMBER ASSET_NUMBER
4483: FROM OKL_TXL_ASSETS_B OTAB,
4484: OKL_K_LINES KLE,
4485: OKL_K_LINES KLE_TOP,
4486: OKC_K_LINES_B CLE
4487: WHERE KLE.ID = OTAB.KLE_ID
4488: AND KLE.ID = CLE.ID

Line 4485: OKL_K_LINES KLE_TOP,

4481: KLE_TOP.OEC OEC,
4482: OTAB.ASSET_NUMBER ASSET_NUMBER
4483: FROM OKL_TXL_ASSETS_B OTAB,
4484: OKL_K_LINES KLE,
4485: OKL_K_LINES KLE_TOP,
4486: OKC_K_LINES_B CLE
4487: WHERE KLE.ID = OTAB.KLE_ID
4488: AND KLE.ID = CLE.ID
4489: AND CLE.CLE_ID = KLE_TOP.ID

Line 4501: OKL_K_LINES KLE ,

4497: UNION
4498: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,KLE_TOP.OEC OEC,
4499: OTAB.ASSET_NUMBER ASSET_NUMBER
4500: FROM OKL_TXL_ASSETS_B OTAB,
4501: OKL_K_LINES KLE ,
4502: OKL_K_LINES KLE_TOP ,
4503: OKC_K_LINES_B CLE ,
4504: OKL_K_HEADERS KHR
4505: WHERE KLE.ID = OTAB.KLE_ID

Line 4502: OKL_K_LINES KLE_TOP ,

4498: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,KLE_TOP.OEC OEC,
4499: OTAB.ASSET_NUMBER ASSET_NUMBER
4500: FROM OKL_TXL_ASSETS_B OTAB,
4501: OKL_K_LINES KLE ,
4502: OKL_K_LINES KLE_TOP ,
4503: OKC_K_LINES_B CLE ,
4504: OKL_K_HEADERS KHR
4505: WHERE KLE.ID = OTAB.KLE_ID
4506: AND KLE.ID = CLE.ID

Line 4521: from OKL_K_LINES KLE ,

4517: UNION
4518: select CLE.DNZ_CHR_ID CONTRACT_ID,
4519: KLE.OEC OEC,
4520: FAD.ASSET_NUMBER ASSET_NUMBER
4521: from OKL_K_LINES KLE ,
4522: OKC_K_LINES_B CLE,
4523: OKC_LINE_STYLES_B LS,
4524: OKC_K_ITEMS CIM,
4525: OKC_K_LINES_B ITEM_CLE,

Line 4554: FROM OKL_K_LINES KLE,

4550: union
4551: SELECT CLE.DNZ_CHR_ID CONTRACT_ID,
4552: KLE.OEC OEC,
4553: FINAN_CLET.NAME ASSET_NUMBER
4554: FROM OKL_K_LINES KLE,
4555: OKC_K_LINES_B CLE,
4556: OKC_LINE_STYLES_B LS,
4557: OKC_K_LINES_B ITEM_CLE,
4558: OKC_LINE_STYLES_B ITEM_LS,

Line 4676: from OKL_K_LINES KLE,

4672:
4673: --- Loan Contract
4674: CURSOR c_loan_asset_category(p_khr_id NUMBER) IS
4675: select 'x',CLE.NAME , cle.id
4676: from OKL_K_LINES KLE,
4677: OKC_K_LINES_V CLE, OKC_LINE_STYLES_B LS
4678: WHERE CLE.ID = KLE.ID
4679: and CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
4680: and KLE.ITEM_INSURANCE_CATEGORY IS NULL

Line 4831: ELSE -- need to poplate value in okl_k_lines (financial)

4827:
4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829:
4830:
4831: ELSE -- need to poplate value in okl_k_lines (financial)
4832: -- If asset_category in inventory setup, populate it in OKL_K_LINES
4833: l_clev_rec.ID := l_financial_line_id ;
4834: l_klev_rec.ID := l_financial_line_id ;
4835: l_klev_rec.ITEM_INSURANCE_CATEGORY := l_item_category ;

Line 4832: -- If asset_category in inventory setup, populate it in OKL_K_LINES

4828: RAISE OKC_API.G_EXCEPTION_ERROR;
4829:
4830:
4831: ELSE -- need to poplate value in okl_k_lines (financial)
4832: -- If asset_category in inventory setup, populate it in OKL_K_LINES
4833: l_clev_rec.ID := l_financial_line_id ;
4834: l_klev_rec.ID := l_financial_line_id ;
4835: l_klev_rec.ITEM_INSURANCE_CATEGORY := l_item_category ;
4836: Okl_Contract_Pub.update_contract_line

Line 6021: FROM OKL_K_LINES

6017: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6018: l_dummy_var VARCHAR2(1) := '?' ;
6019: CURSOR okl_k_line_csr(p_kle_id IN NUMBER) IS
6020: SELECT 'x'
6021: FROM OKL_K_LINES
6022: WHERE OKL_K_LINES.ID = p_kle_id;
6023: BEGIN
6024: OPEN okl_k_line_csr(p_kle_id);
6025: FETCH okl_k_line_csr INTO l_dummy_var ;

Line 6022: WHERE OKL_K_LINES.ID = p_kle_id;

6018: l_dummy_var VARCHAR2(1) := '?' ;
6019: CURSOR okl_k_line_csr(p_kle_id IN NUMBER) IS
6020: SELECT 'x'
6021: FROM OKL_K_LINES
6022: WHERE OKL_K_LINES.ID = p_kle_id;
6023: BEGIN
6024: OPEN okl_k_line_csr(p_kle_id);
6025: FETCH okl_k_line_csr INTO l_dummy_var ;
6026: CLOSE okl_k_line_csr ;

Line 6823: OKL_K_LINES KLE,

6819: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,
6820: KLE_TOP.OEC OEC,
6821: OTAB.ASSET_NUMBER ASSET_NUMBER
6822: FROM OKL_TXL_ASSETS_B OTAB,
6823: OKL_K_LINES KLE,
6824: OKL_K_LINES KLE_TOP,
6825: OKC_K_LINES_B CLE
6826: WHERE KLE.ID = OTAB.KLE_ID
6827: AND KLE.ID = CLE.ID

Line 6824: OKL_K_LINES KLE_TOP,

6820: KLE_TOP.OEC OEC,
6821: OTAB.ASSET_NUMBER ASSET_NUMBER
6822: FROM OKL_TXL_ASSETS_B OTAB,
6823: OKL_K_LINES KLE,
6824: OKL_K_LINES KLE_TOP,
6825: OKC_K_LINES_B CLE
6826: WHERE KLE.ID = OTAB.KLE_ID
6827: AND KLE.ID = CLE.ID
6828: AND CLE.CLE_ID = KLE_TOP.ID

Line 6840: OKL_K_LINES KLE ,

6836: UNION
6837: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,KLE_TOP.OEC OEC,
6838: OTAB.ASSET_NUMBER ASSET_NUMBER
6839: FROM OKL_TXL_ASSETS_B OTAB,
6840: OKL_K_LINES KLE ,
6841: OKL_K_LINES KLE_TOP ,
6842: OKC_K_LINES_B CLE ,
6843: OKL_K_HEADERS KHR
6844: WHERE KLE.ID = OTAB.KLE_ID

Line 6841: OKL_K_LINES KLE_TOP ,

6837: SELECT OTAB.DNZ_KHR_ID CONTRACT_ID,KLE_TOP.OEC OEC,
6838: OTAB.ASSET_NUMBER ASSET_NUMBER
6839: FROM OKL_TXL_ASSETS_B OTAB,
6840: OKL_K_LINES KLE ,
6841: OKL_K_LINES KLE_TOP ,
6842: OKC_K_LINES_B CLE ,
6843: OKL_K_HEADERS KHR
6844: WHERE KLE.ID = OTAB.KLE_ID
6845: AND KLE.ID = CLE.ID

Line 6860: from OKL_K_LINES KLE ,

6856: UNION
6857: select CLE.DNZ_CHR_ID CONTRACT_ID,
6858: KLE.OEC OEC,
6859: FAD.ASSET_NUMBER ASSET_NUMBER
6860: from OKL_K_LINES KLE ,
6861: OKC_K_LINES_B CLE,
6862: OKC_LINE_STYLES_B LS,
6863: OKC_K_ITEMS CIM,
6864: OKC_K_LINES_B ITEM_CLE,

Line 6893: FROM OKL_K_LINES KLE,

6889: union
6890: SELECT CLE.DNZ_CHR_ID CONTRACT_ID,
6891: KLE.OEC OEC,
6892: FINAN_CLET.NAME ASSET_NUMBER
6893: FROM OKL_K_LINES KLE,
6894: OKC_K_LINES_B CLE,
6895: OKC_LINE_STYLES_B LS,
6896: OKC_K_LINES_B ITEM_CLE,
6897: OKC_LINE_STYLES_B ITEM_LS,