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.

VIEW: APPS.OKL_INS_POLICY_ASSETS_UV

Source

View Text - Preformatted


SELECT CLE.DNZ_CHR_ID CONTRACT_ID ,INA.IPY_ID POLICY_ID ,OTL.ITEM_DESCRIPTION ASSET_DESCRIPTION ,FDH.UNITS_ASSIGNED QUANTITY ,( KLE.OEC /TXLA.CURRENT_UNITS )* FDH.UNITS_ASSIGNED OEC ,TL.NAME ASSET_CATEGORY ,fnl.MEANING INSURANCE_CLASS ,OICC.IAC_CODE INSURANCE_CLASS_code ,FAL.SEGMENT1 COUNTRY , INA.ASSET_PREMIUM ,INA.KLE_ID FROM OKL_INS_ASSETS_ALL INA,OKL_K_LINES KLE,OKX_ASST_CATGRS_V TL,FND_LOOKUPS FNL,FA_LOCATIONS FAL,OKL_INS_CLASS_CATS OICC,FA_DISTRIBUTION_HISTORY FDH,FA_ADDITIONS_B FAD,OKL_TXL_ASSETS_B TXLA,OKC_K_LINES_B CLE,OKC_K_LINES_TL OTL,OKC_LINE_STYLES_B LS WHERE KLE.ID = INA.KLE_ID AND CLE.CLE_ID = KLE.ID AND TXLA.ASSET_NUMBER = FAD.ASSET_NUMBER AND TL.CATEGORY_ID = FAD.ASSET_CATEGORY_ID AND + OICC.IAY_ID = FAD.ASSET_CATEGORY_ID AND fnl.LOOKUP_CODE =+ OICC.IAC_CODE AND FDH.LOCATION_ID = FAL.LOCATION_ID AND FDH.ASSET_ID = FAD.ASSET_ID AND OTL.ID = CLE.ID AND OTL.LANGUAGE = USERENV('LANG') AND LS.ID = CLE.LSE_ID AND LS.LTY_CODE = 'FIXED_ASSET' AND TXLA.KLE_ID = CLE.ID AND KLE.KLE_ID IS NULL

View Text - HTML Formatted

SELECT CLE.DNZ_CHR_ID CONTRACT_ID
, INA.IPY_ID POLICY_ID
, OTL.ITEM_DESCRIPTION ASSET_DESCRIPTION
, FDH.UNITS_ASSIGNED QUANTITY
, ( KLE.OEC /TXLA.CURRENT_UNITS )* FDH.UNITS_ASSIGNED OEC
, TL.NAME ASSET_CATEGORY
, FNL.MEANING INSURANCE_CLASS
, OICC.IAC_CODE INSURANCE_CLASS_CODE
, FAL.SEGMENT1 COUNTRY
, INA.ASSET_PREMIUM
, INA.KLE_ID
FROM OKL_INS_ASSETS_ALL INA
, OKL_K_LINES KLE
, OKX_ASST_CATGRS_V TL
, FND_LOOKUPS FNL
, FA_LOCATIONS FAL
, OKL_INS_CLASS_CATS OICC
, FA_DISTRIBUTION_HISTORY FDH
, FA_ADDITIONS_B FAD
, OKL_TXL_ASSETS_B TXLA
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL OTL
, OKC_LINE_STYLES_B LS
WHERE KLE.ID = INA.KLE_ID
AND CLE.CLE_ID = KLE.ID
AND TXLA.ASSET_NUMBER = FAD.ASSET_NUMBER
AND TL.CATEGORY_ID = FAD.ASSET_CATEGORY_ID
AND + OICC.IAY_ID = FAD.ASSET_CATEGORY_ID
AND FNL.LOOKUP_CODE =+ OICC.IAC_CODE
AND FDH.LOCATION_ID = FAL.LOCATION_ID
AND FDH.ASSET_ID = FAD.ASSET_ID
AND OTL.ID = CLE.ID
AND OTL.LANGUAGE = USERENV('LANG')
AND LS.ID = CLE.LSE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND TXLA.KLE_ID = CLE.ID
AND KLE.KLE_ID IS NULL