View: OKL_INS_CLAIM_ASSETS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_INS_CLAIM_ASSETS_UV

View Text

SELECT ACD.CLM_ID CLAIM_ID
, FLPA.MEANING LINE_STATUS
, FLPC.MEANING CLAIM_TYPE
, FLPCN.MEANING CONDITION_STATUS
, ACNT.DAMAGE_DESCRIPTION
, ACNT.CLAIM_DESCRIPTION
, KLET.ITEM_DESCRIPTION ASSET_DESCRIPTION
, KLET.NAME ASSET_NUMBER
FROM FND_LOOKUPS FLPA
, FND_LOOKUPS FLPC
, FND_LOOKUPS FLPCN
, OKL_ASSET_CNDTNS ACD
, OKL_AST_CNDTN_LNS_ALL_B ACNB
, OKL_ASSET_CNDTN_LNS_TL ACNT
, OKC_K_LINES_TL KLET
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSE
WHERE ACNB.ACD_ID = ACD.ID
AND ACNB.ID = ACNT.ID
AND ACNT.LANGUAGE = USERENV('LANG')
AND ACD.KLE_ID = CLEB.ID
AND CLEB.CLE_ID = KLET.ID
AND CLEB.LSE_ID = LSE.ID
AND ACD.CDN_CODE = FLPA.LOOKUP_CODE
AND FLPA.LOOKUP_TYPE = 'OKL_ASSET_CONDITION'
AND ACNB.CTP_CODE =FLPC.LOOKUP_CODE
AND FLPC.LOOKUP_TYPE = 'OKL_CLAIM_TYPE'
AND ACNB.ACS_CODE =FLPCN.LOOKUP_CODE
AND FLPCN.LOOKUP_TYPE = 'OKL_ASSET_CNDN_LINE_STATUS'
AND ACD.CLM_ID IS NOT NULL
AND KLET.LANGUAGE = USERENV('LANG')

Columns