VIEW: APPS.OKL_BPD_CNTR_READING_UV

Source

View Text - Preformatted

SELECT CNTR_LVLNG.ID ID, 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, NULL, NULL, NULL, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE, CN.TYPE COUNTER_TYPE 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,MTL_UNITS_OF_MEASURE_TL UOM WHERE USAGE.DNZ_CHR_ID = KHR.ID AND USAGE.ID = ITEMS.CLE_ID AND to_char(OKS.ID) = ITEMS.OBJECT1_ID1 AND ITEMS.OBJECT1_ID2 = '#' AND ITEMS.JTOT_OBJECT1_CODE = 'OKL_USAGE' AND ITEMS.dnz_chr_id = USAGE.dnz_chr_id 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 ITEMS2.OBJECT1_ID2 = '#' AND ITEMS2.JTOT_OBJECT1_CODE = 'OKX_COVASST' AND ITEMS2.dnz_chr_id = ASSET.dnz_chr_id 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 = to_char(CN.COUNTER_ID) AND ITEMOKS.OBJECT1_ID2 = '#' AND ITEMOKS.JTOT_OBJECT1_CODE = 'OKX_COUNTER' AND ITEMOKS.dnz_chr_id = OKS_ASSET.DNZ_CHR_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 AND CN.UOM_CODE = UOM.UOM_CODE AND UOM.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CNTR_LVLNG.ID ID
, 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
, NULL
, NULL
, NULL
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CN.TYPE COUNTER_TYPE
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
, MTL_UNITS_OF_MEASURE_TL UOM
WHERE USAGE.DNZ_CHR_ID = KHR.ID
AND USAGE.ID = ITEMS.CLE_ID
AND TO_CHAR(OKS.ID) = ITEMS.OBJECT1_ID1
AND ITEMS.OBJECT1_ID2 = '#'
AND ITEMS.JTOT_OBJECT1_CODE = 'OKL_USAGE'
AND ITEMS.DNZ_CHR_ID = USAGE.DNZ_CHR_ID
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 ITEMS2.OBJECT1_ID2 = '#'
AND ITEMS2.JTOT_OBJECT1_CODE = 'OKX_COVASST'
AND ITEMS2.DNZ_CHR_ID = ASSET.DNZ_CHR_ID
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 = TO_CHAR(CN.COUNTER_ID)
AND ITEMOKS.OBJECT1_ID2 = '#'
AND ITEMOKS.JTOT_OBJECT1_CODE = 'OKX_COUNTER'
AND ITEMOKS.DNZ_CHR_ID = OKS_ASSET.DNZ_CHR_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
AND CN.UOM_CODE = UOM.UOM_CODE
AND UOM.LANGUAGE = USERENV('LANG')