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.

[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKC_K_LINES_B

Line 4267: OKC_K_LINES_B CLE

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
4271: AND TL.CATEGORY_ID = OTAB.DEPRECIATION_ID

Line 4297: OKC_K_LINES_B CLE ,

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
4301: AND CLE.CLE_ID = KLE_TOP.ID

Line 4325: OKC_K_LINES_B CLE,

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,
4329: OKC_K_LINES_B ITEM_CLE,

Line 4329: OKC_K_LINES_B ITEM_CLE,

4325: OKC_K_LINES_B CLE,
4326: OKC_LINE_STYLES_B LS,
4327: OKC_K_ITEMS CIM,
4328: OKC_K_LINES_TL OTL,
4329: OKC_K_LINES_B ITEM_CLE,
4330: OKC_LINE_STYLES_B ITEM_LS,
4331: OKC_K_ITEMS MODEL ,
4332: OKX_ASST_CATGRS_V TL,
4333: OKL_INS_CLASS_CATS OICC,

Line 4335: OKC_K_LINES_B FINAC_CLE,

4331: OKC_K_ITEMS MODEL ,
4332: OKX_ASST_CATGRS_V TL,
4333: OKL_INS_CLASS_CATS OICC,
4334: FA_ADDITIONS_B FAd,
4335: OKC_K_LINES_B FINAC_CLE,
4336: OKC_LINE_STYLES_B FINAC_LS
4337: WHERE FINAC_LS.LTY_CODE = 'FREE_FORM1'
4338: AND FINAC_CLE.LSE_ID = FINAC_LS.ID
4339: AND FINAC_CLE.ID = KLE.ID

Line 4372: OKC_K_LINES_B CLE,

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,
4374: OKC_LINE_STYLES_B LS,
4375: OKC_K_LINES_B ITEM_CLE,
4376: OKC_LINE_STYLES_B ITEM_LS,

Line 4375: OKC_K_LINES_B ITEM_CLE,

4371: OKL_INS_CLASS_CATS OICC,
4372: OKC_K_LINES_B CLE,
4373: OKC_K_LINES_TL OTL,
4374: OKC_LINE_STYLES_B LS,
4375: OKC_K_LINES_B ITEM_CLE,
4376: OKC_LINE_STYLES_B ITEM_LS,
4377: OKC_K_ITEMS MODEL ,
4378: OKL_K_HEADERS KHR ,
4379: OKC_K_LINES_B FINAN_CLE ,

Line 4379: OKC_K_LINES_B FINAN_CLE ,

4375: OKC_K_LINES_B ITEM_CLE,
4376: OKC_LINE_STYLES_B ITEM_LS,
4377: OKC_K_ITEMS MODEL ,
4378: OKL_K_HEADERS KHR ,
4379: OKC_K_LINES_B FINAN_CLE ,
4380: OKC_K_LINES_TL FINAN_CLET
4381: WHERE MODEL.cle_id = ITEM_CLE.ID
4382: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID
4383: AND ITEM_LS.LTY_CODE = 'ITEM'

Line 4429: OKC_K_LINES_B CLE,

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
4433: AND CLE.ID = KLE.ID

Line 4441: OKC_K_LINES_B CLE,

4437: and OTAB.DEPRECIATION_ID IS NULL
4438: UNION
4439: SELECT 'x', FAD.ASSET_NUMBER
4440: from
4441: OKC_K_LINES_B CLE,
4442: OKC_LINE_STYLES_B LS,
4443: OKC_K_ITEMS CIM,
4444: FA_ADDITIONS_B FAD
4445: where

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 4486: OKC_K_LINES_B CLE

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
4490: AND NOT EXISTS

Line 4503: OKC_K_LINES_B CLE ,

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
4507: AND CLE.CLE_ID = KLE_TOP.ID

Line 4522: OKC_K_LINES_B CLE,

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,
4526: OKC_LINE_STYLES_B ITEM_LS,

Line 4525: OKC_K_LINES_B ITEM_CLE,

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,
4526: OKC_LINE_STYLES_B ITEM_LS,
4527: OKC_K_ITEMS MODEL ,
4528: FA_ADDITIONS_B FAd,
4529: OKC_K_LINES_B FINAC_CLE,

Line 4529: OKC_K_LINES_B FINAC_CLE,

4525: OKC_K_LINES_B ITEM_CLE,
4526: OKC_LINE_STYLES_B ITEM_LS,
4527: OKC_K_ITEMS MODEL ,
4528: FA_ADDITIONS_B FAd,
4529: OKC_K_LINES_B FINAC_CLE,
4530: OKC_LINE_STYLES_B FINAC_LS
4531: where FINAC_LS.LTY_CODE = 'FREE_FORM1'
4532: AND FINAC_CLE.LSE_ID = FINAC_LS.ID
4533: AND FINAC_CLE.ID = KLE.ID

Line 4555: OKC_K_LINES_B CLE,

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,
4559: OKC_K_ITEMS MODEL ,

Line 4557: OKC_K_LINES_B ITEM_CLE,

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,
4559: OKC_K_ITEMS MODEL ,
4560: OKL_K_HEADERS KHR ,
4561: OKC_K_LINES_B FINAN_CLE ,

Line 4561: OKC_K_LINES_B FINAN_CLE ,

4557: OKC_K_LINES_B ITEM_CLE,
4558: OKC_LINE_STYLES_B ITEM_LS,
4559: OKC_K_ITEMS MODEL ,
4560: OKL_K_HEADERS KHR ,
4561: OKC_K_LINES_B FINAN_CLE ,
4562: OKC_K_LINES_TL FINAN_CLET
4563: WHERE MODEL.cle_id = ITEM_CLE.ID
4564: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID
4565: AND ITEM_LS.LTY_CODE = 'ITEM'

Line 4690: OKC_K_LINES_B MODEL,

4686: SELECT mtl.ASSET_CATEGORY_ID, MTL.DESCRIPTION
4687: FROM
4688: MTL_SYSTEM_ITEMS MTL,
4689: OKC_K_items FA_ITEM ,
4690: OKC_K_LINES_B MODEL,
4691: OKC_LINE_STYLES_B LS_MODEL
4692: WHERE
4693: MTL.INVENTORY_ITEM_ID = FA_ITEM.object1_id1
4694: AND MTL.ORGANIZATION_ID = FA_ITEM.object1_id2

Line 6818: OKC_K_LINES_B CLE

6814: OTAB.ASSET_NUMBER ASSET_NUMBER
6815: FROM OKL_TXL_ASSETS_B OTAB,
6816: OKL_K_LINES KLE,
6817: OKL_K_LINES KLE_TOP,
6818: OKC_K_LINES_B CLE
6819: WHERE KLE.ID = OTAB.KLE_ID
6820: AND KLE.ID = CLE.ID
6821: AND CLE.CLE_ID = KLE_TOP.ID
6822: AND NOT EXISTS

Line 6835: OKC_K_LINES_B CLE ,

6831: OTAB.ASSET_NUMBER ASSET_NUMBER
6832: FROM OKL_TXL_ASSETS_B OTAB,
6833: OKL_K_LINES KLE ,
6834: OKL_K_LINES KLE_TOP ,
6835: OKC_K_LINES_B CLE ,
6836: OKL_K_HEADERS KHR
6837: WHERE KLE.ID = OTAB.KLE_ID
6838: AND KLE.ID = CLE.ID
6839: AND CLE.CLE_ID = KLE_TOP.ID

Line 6854: OKC_K_LINES_B CLE,

6850: select CLE.DNZ_CHR_ID CONTRACT_ID,
6851: KLE.OEC OEC,
6852: FAD.ASSET_NUMBER ASSET_NUMBER
6853: from OKL_K_LINES KLE ,
6854: OKC_K_LINES_B CLE,
6855: OKC_LINE_STYLES_B LS,
6856: OKC_K_ITEMS CIM,
6857: OKC_K_LINES_B ITEM_CLE,
6858: OKC_LINE_STYLES_B ITEM_LS,

Line 6857: OKC_K_LINES_B ITEM_CLE,

6853: from OKL_K_LINES KLE ,
6854: OKC_K_LINES_B CLE,
6855: OKC_LINE_STYLES_B LS,
6856: OKC_K_ITEMS CIM,
6857: OKC_K_LINES_B ITEM_CLE,
6858: OKC_LINE_STYLES_B ITEM_LS,
6859: OKC_K_ITEMS MODEL ,
6860: FA_ADDITIONS_B FAd,
6861: OKC_K_LINES_B FINAC_CLE,

Line 6861: OKC_K_LINES_B FINAC_CLE,

6857: OKC_K_LINES_B ITEM_CLE,
6858: OKC_LINE_STYLES_B ITEM_LS,
6859: OKC_K_ITEMS MODEL ,
6860: FA_ADDITIONS_B FAd,
6861: OKC_K_LINES_B FINAC_CLE,
6862: OKC_LINE_STYLES_B FINAC_LS
6863: where FINAC_LS.LTY_CODE = 'FREE_FORM1'
6864: AND FINAC_CLE.LSE_ID = FINAC_LS.ID
6865: AND FINAC_CLE.ID = KLE.ID

Line 6887: OKC_K_LINES_B CLE,

6883: SELECT CLE.DNZ_CHR_ID CONTRACT_ID,
6884: KLE.OEC OEC,
6885: FINAN_CLET.NAME ASSET_NUMBER
6886: FROM OKL_K_LINES KLE,
6887: OKC_K_LINES_B CLE,
6888: OKC_LINE_STYLES_B LS,
6889: OKC_K_LINES_B ITEM_CLE,
6890: OKC_LINE_STYLES_B ITEM_LS,
6891: OKC_K_ITEMS MODEL ,

Line 6889: OKC_K_LINES_B ITEM_CLE,

6885: FINAN_CLET.NAME ASSET_NUMBER
6886: FROM OKL_K_LINES KLE,
6887: OKC_K_LINES_B CLE,
6888: OKC_LINE_STYLES_B LS,
6889: OKC_K_LINES_B ITEM_CLE,
6890: OKC_LINE_STYLES_B ITEM_LS,
6891: OKC_K_ITEMS MODEL ,
6892: OKL_K_HEADERS KHR ,
6893: OKC_K_LINES_B FINAN_CLE ,

Line 6893: OKC_K_LINES_B FINAN_CLE ,

6889: OKC_K_LINES_B ITEM_CLE,
6890: OKC_LINE_STYLES_B ITEM_LS,
6891: OKC_K_ITEMS MODEL ,
6892: OKL_K_HEADERS KHR ,
6893: OKC_K_LINES_B FINAN_CLE ,
6894: OKC_K_LINES_TL FINAN_CLET
6895: WHERE MODEL.cle_id = ITEM_CLE.ID
6896: AND MODEL.DNZ_CHR_ID = ITEM_CLE.DNZ_CHR_ID
6897: AND ITEM_LS.LTY_CODE = 'ITEM'