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 OKC_K_ITEMS

Line 4278: from okc_k_items cim

4274: AND SYSDATE BETWEEN OICC.DATE_FROM AND NVL(OICC.DATE_TO, SYSDATE +1)
4275: AND OTAT.LANGUAGE = USERENV ('LANG')
4276: AND NOT EXISTS
4277: (Select '1'
4278: from okc_k_items cim
4279: where cim.cle_id = otab.kle_id
4280: AND cim.object1_id1 is not null)
4281: AND CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
4282: AND OTAB.DNZ_KHR_ID = p_k_id

Line 4309: from okc_k_items cim

4305: AND SYSDATE BETWEEN OICC.DATE_FROM AND NVL(OICC.DATE_TO, SYSDATE +1)
4306: AND OTAT.LANGUAGE = USERENV('LANG')
4307: AND NOT EXISTS
4308: (Select '1'
4309: from okc_k_items cim
4310: where cim.cle_id = otab.kle_id
4311: AND cim.object1_id1 is not null)
4312: AND khr.id = CLE.DNZ_CHR_ID
4313: AND khr.deal_type = 'LOAN'

Line 4327: OKC_K_ITEMS CIM,

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,
4330: OKC_LINE_STYLES_B ITEM_LS,
4331: OKC_K_ITEMS MODEL ,

Line 4331: OKC_K_ITEMS MODEL ,

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,
4334: FA_ADDITIONS_B FAd,
4335: OKC_K_LINES_B FINAC_CLE,

Line 4377: OKC_K_ITEMS MODEL ,

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 ,
4380: OKC_K_LINES_TL FINAN_CLET
4381: WHERE MODEL.cle_id = ITEM_CLE.ID

Line 4443: OKC_K_ITEMS CIM,

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
4446: FAD.ASSET_CATEGORY_ID IS NULL
4447: AND FAD.ASSET_ID = CIM.OBJECT1_ID1

Line 4492: from okc_k_items cim

4488: AND KLE.ID = CLE.ID
4489: AND CLE.CLE_ID = KLE_TOP.ID
4490: AND NOT EXISTS
4491: (Select '1'
4492: from okc_k_items cim
4493: where cim.cle_id = otab.kle_id
4494: AND cim.object1_id1 is not null)
4495: AND CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
4496: AND OTAB.DNZ_KHR_ID = p_khr_id

Line 4510: from okc_k_items cim

4506: AND KLE.ID = CLE.ID
4507: AND CLE.CLE_ID = KLE_TOP.ID
4508: AND NOT EXISTS
4509: (Select '1'
4510: from okc_k_items cim
4511: where cim.cle_id = otab.kle_id
4512: AND cim.object1_id1 is not null)
4513: AND khr.id = CLE.DNZ_CHR_ID
4514: AND khr.deal_type = 'LOAN'

Line 4524: OKC_K_ITEMS CIM,

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,
4527: OKC_K_ITEMS MODEL ,
4528: FA_ADDITIONS_B FAd,

Line 4527: OKC_K_ITEMS MODEL ,

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,
4530: OKC_LINE_STYLES_B FINAC_LS
4531: where FINAC_LS.LTY_CODE = 'FREE_FORM1'

Line 4559: OKC_K_ITEMS MODEL ,

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 ,
4562: OKC_K_LINES_TL FINAN_CLET
4563: WHERE MODEL.cle_id = ITEM_CLE.ID

Line 4689: OKC_K_items FA_ITEM ,

4685: CURSOR c_loan_item_category(p_financial_line_id NUMBER) IS
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

Line 6824: from okc_k_items cim

6820: AND KLE.ID = CLE.ID
6821: AND CLE.CLE_ID = KLE_TOP.ID
6822: AND NOT EXISTS
6823: (Select '1'
6824: from okc_k_items cim
6825: where cim.cle_id = otab.kle_id
6826: AND cim.object1_id1 is not null)
6827: AND CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
6828: AND OTAB.DNZ_KHR_ID = p_khr_id

Line 6842: from okc_k_items cim

6838: AND KLE.ID = CLE.ID
6839: AND CLE.CLE_ID = KLE_TOP.ID
6840: AND NOT EXISTS
6841: (Select '1'
6842: from okc_k_items cim
6843: where cim.cle_id = otab.kle_id
6844: AND cim.object1_id1 is not null)
6845: AND khr.id = CLE.DNZ_CHR_ID
6846: AND khr.deal_type = 'LOAN'

Line 6856: OKC_K_ITEMS CIM,

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,
6859: OKC_K_ITEMS MODEL ,
6860: FA_ADDITIONS_B FAd,

Line 6859: OKC_K_ITEMS MODEL ,

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,
6862: OKC_LINE_STYLES_B FINAC_LS
6863: where FINAC_LS.LTY_CODE = 'FREE_FORM1'

Line 6891: OKC_K_ITEMS MODEL ,

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 ,
6894: OKC_K_LINES_TL FINAN_CLET
6895: WHERE MODEL.cle_id = ITEM_CLE.ID