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_TXL_ASSETS_B

Line 4261: FROM OKL_TXL_ASSETS_B OTAB,

4257: TL.NAME ASSET_CATEGORY,
4258: OICC.IAC_CODE INSURANCE_CLASS_code,
4259: KLE_TOP.ID KLE_ID,
4260: OTAB.ASSET_NUMBER ASSET_NUMBER
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,

Line 4291: FROM OKL_TXL_ASSETS_B OTAB,

4287: TL.NAME ASSET_CATEGORY,
4288: OICC.IAC_CODE INSURANCE_CLASS_code,
4289: KLE_TOP.ID KLE_ID,
4290: OTAB.ASSET_NUMBER ASSET_NUMBER
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 ,

Line 4427: from OKL_TXL_ASSETS_B OTAB,

4423:
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

Line 4483: FROM OKL_TXL_ASSETS_B OTAB,

4479: (
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

Line 4500: FROM OKL_TXL_ASSETS_B OTAB,

4496: AND OTAB.DNZ_KHR_ID = p_khr_id
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

Line 6822: FROM OKL_TXL_ASSETS_B OTAB,

6818: (
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

Line 6839: FROM OKL_TXL_ASSETS_B OTAB,

6835: AND OTAB.DNZ_KHR_ID = p_khr_id
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