VIEW: APPS.OKL_INS_CLAIM_ASSETS_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')