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 6831: from okc_k_items cim

6827: AND KLE.ID = CLE.ID
6828: AND CLE.CLE_ID = KLE_TOP.ID
6829: AND NOT EXISTS
6830: (Select '1'
6831: from okc_k_items cim
6832: where cim.cle_id = otab.kle_id
6833: AND cim.object1_id1 is not null)
6834: AND CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
6835: AND OTAB.DNZ_KHR_ID = p_khr_id

Line 6849: from okc_k_items cim

6845: AND KLE.ID = CLE.ID
6846: AND CLE.CLE_ID = KLE_TOP.ID
6847: AND NOT EXISTS
6848: (Select '1'
6849: from okc_k_items cim
6850: where cim.cle_id = otab.kle_id
6851: AND cim.object1_id1 is not null)
6852: AND khr.id = CLE.DNZ_CHR_ID
6853: AND khr.deal_type = 'LOAN'

Line 6863: OKC_K_ITEMS CIM,

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,
6865: OKC_LINE_STYLES_B ITEM_LS,
6866: OKC_K_ITEMS MODEL ,
6867: FA_ADDITIONS_B FAd,

Line 6866: OKC_K_ITEMS MODEL ,

6862: OKC_LINE_STYLES_B LS,
6863: OKC_K_ITEMS CIM,
6864: OKC_K_LINES_B ITEM_CLE,
6865: OKC_LINE_STYLES_B ITEM_LS,
6866: OKC_K_ITEMS MODEL ,
6867: FA_ADDITIONS_B FAd,
6868: OKC_K_LINES_B FINAC_CLE,
6869: OKC_LINE_STYLES_B FINAC_LS
6870: where FINAC_LS.LTY_CODE = 'FREE_FORM1'

Line 6898: OKC_K_ITEMS MODEL ,

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,
6898: OKC_K_ITEMS MODEL ,
6899: OKL_K_HEADERS KHR ,
6900: OKC_K_LINES_B FINAN_CLE ,
6901: OKC_K_LINES_TL FINAN_CLET
6902: WHERE MODEL.cle_id = ITEM_CLE.ID