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_BPD_CNTR_LVLNG_SUMRY_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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