[Home] [Help]
View: OKL_INS_POLICY_ASSETS_UV
View Text
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
Columns
Name |
CONTRACT_ID |
POLICY_ID |
ASSET_DESCRIPTION |
QUANTITY |
OEC |
ASSET_CATEGORY |
INSURANCE_CLASS |
INSURANCE_CLASS_CODE |
COUNTRY |
PREMIUM |
KLE_ID |