View: OKL_BPD_CNTR_LVLNG_SUMRY_UV

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

View Text

SELECT CNTR_LVLNG.NAME COUNTER_GROUP
, CN.COUNTER_ID COUNTER_NUMBER
, CN.NAME COUNTER_NAME
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, TL.NAME ASSET_NUMBER
, ASS.SERIAL_NUMBER ASSET_SERIAL_NUMBER
, ASS.DESCRIPTION ASSET_DESCRIPTION
, CNTR_LVLNG.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, CNTR_LVLNG.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
FROM OKL_CNTR_LVLNG_GRPS_V CNTR_LVLNG
, OKL_CNTR_LVLNG_LNS_V CNTR_LVLNG_LNS
, OKX_ASSETS_V ASS
, OKC_K_HEADERS_B KHR
, OKC_K_LINES_B USAGE
, OKC_K_LINES_B OKS
, OKC_K_LINES_B ASSET
, OKC_K_ITEMS ITEMS2
, OKC_K_LINES_B ASSET_LINE
, OKC_K_ITEMS ITEMS
, OKC_K_LINES_B OKS_ASSET
, OKC_K_ITEMS ITEMS1
, OKC_K_ITEMS ITEMOKS
, CS_COUNTERS CN
, OKC_K_LINES_TL TL
WHERE USAGE.DNZ_CHR_ID = KHR.ID
AND USAGE.ID = ITEMS.CLE_ID
AND OKS.ID = ITEMS.OBJECT1_ID1
AND OKS.ID = ITEMS1.CLE_ID
AND USAGE.ID = ASSET.CLE_ID
AND ITEMS2.CLE_ID = ASSET.ID
AND ASSET_LINE.ID = ITEMS2.OBJECT1_ID1
AND TL.ID = ASSET_LINE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND OKS_ASSET.CLE_ID = OKS.ID
AND ITEMOKS.CLE_ID = OKS_ASSET.ID
AND ITEMOKS.OBJECT1_ID1 = CN.COUNTER_ID
AND TL.NAME = ASS.ASSET_NUMBER
AND CNTR_LVLNG.ID = CNTR_LVLNG_LNS.CLG_ID
AND CN.COUNTER_ID = CNTR_LVLNG_LNS.KLE_ID

Columns