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_LINE_STYLES_B

Line 2928: FROM OKC_LINE_STYLES_b

2924: lx_cvmv_rec okl_version_pub.cvmv_rec_type;
2925: l_khr_status VARCHAR2(30) ;
2926: CURSOR l_okl_lse_id IS
2927: SELECT id
2928: FROM OKC_LINE_STYLES_b
2929: WHERE LTY_CODE = 'INSURANCE' ;
2930:
2931: -- Added for currency code
2932: CURSOR l_currency_code(p_khr_id NUMBER) IS

Line 4326: OKC_LINE_STYLES_B LS,

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

Line 4330: OKC_LINE_STYLES_B ITEM_LS,

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

Line 4336: OKC_LINE_STYLES_B FINAC_LS

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
4340: AND OICC.IAY_ID = FAD.ASSET_CATEGORY_ID

Line 4374: OKC_LINE_STYLES_B LS,

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,
4377: OKC_K_ITEMS MODEL ,
4378: OKL_K_HEADERS KHR ,

Line 4376: OKC_LINE_STYLES_B ITEM_LS,

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 ,
4380: OKC_K_LINES_TL FINAN_CLET

Line 4430: OKC_LINE_STYLES_B LS

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
4434: AND LS.ID = CLE.LSE_ID

Line 4442: OKC_LINE_STYLES_B LS,

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
4446: FAD.ASSET_CATEGORY_ID IS NULL

Line 4523: OKC_LINE_STYLES_B LS,

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

Line 4526: OKC_LINE_STYLES_B ITEM_LS,

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,
4530: OKC_LINE_STYLES_B FINAC_LS

Line 4530: OKC_LINE_STYLES_B FINAC_LS

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
4534: AND FAD.ASSET_ID = CIM.OBJECT1_ID1

Line 4556: OKC_LINE_STYLES_B LS,

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 ,
4560: OKL_K_HEADERS KHR ,

Line 4558: OKC_LINE_STYLES_B ITEM_LS,

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 ,
4562: OKC_K_LINES_TL FINAN_CLET

Line 4677: OKC_K_LINES_V CLE, OKC_LINE_STYLES_B LS

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
4681: AND LS.LTY_CODE = 'FREE_FORM1'

Line 4691: OKC_LINE_STYLES_B LS_MODEL

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
4695: AND FA_ITEM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'

Line 6855: OKC_LINE_STYLES_B LS,

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

Line 6858: OKC_LINE_STYLES_B ITEM_LS,

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,
6862: OKC_LINE_STYLES_B FINAC_LS

Line 6862: OKC_LINE_STYLES_B FINAC_LS

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
6866: AND FAD.ASSET_ID = CIM.OBJECT1_ID1

Line 6888: OKC_LINE_STYLES_B LS,

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 ,
6892: OKL_K_HEADERS KHR ,

Line 6890: OKC_LINE_STYLES_B ITEM_LS,

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 ,
6894: OKC_K_LINES_TL FINAN_CLET