VIEW: APPS.OKL_AM_ASSETS_UV

Source

View Text - Preformatted

SELECT OALV.ID ASSET_ID, OALV.STS_CODE STATUS, OALV.END_DATE END_DATE_ACTIVE, OALV.START_DATE START_DATE_ACTIVE, OALV.DATE_TERMINATED , OALV.ID ID, '#' ID2, OALV.NAME , OALV.ITEM_DESCRIPTION , OALV.ITEM_DESCRIPTION DESCRIPTION, OALV.CHR_ID , OKHFV.ID DNZ_CHR_ID , OALV.LINE_NUMBER , OALV.NAME ASSET_NUMBER, KLE.OEC COST, OKHFV.CONTRACT_NUMBER , OKHFV.START_DATE , OKHFV.END_DATE , OKHFV.ID CONTRACT_ID, okl_am_util_pvt.get_asset_quantity (oalv.id) QUANTITY, OKHFV.STS_CODE CONTRACT_STATUS, sysdate EFFECTIVE_FROM, NULL SPLIT_KLE_NAME FROM OKC_K_LINES_V OALV,OKL_K_LINES KLE,OKC_K_HEADERS_B OKHFV,OKC_LINE_STYLES_B LSE WHERE OALV.ID = KLE.ID AND LSE.LTY_CODE = 'FREE_FORM1' AND OALV.LSE_ID = LSE.ID AND OKHFV.ID = OALV.DNZ_CHR_ID AND OALV.STS_CODE = OKHFV.STS_CODE AND OALV.STS_CODE <> 'ABANDONED'

View Text - HTML Formatted

SELECT OALV.ID ASSET_ID
, OALV.STS_CODE STATUS
, OALV.END_DATE END_DATE_ACTIVE
, OALV.START_DATE START_DATE_ACTIVE
, OALV.DATE_TERMINATED
, OALV.ID ID
, '#' ID2
, OALV.NAME
, OALV.ITEM_DESCRIPTION
, OALV.ITEM_DESCRIPTION DESCRIPTION
, OALV.CHR_ID
, OKHFV.ID DNZ_CHR_ID
, OALV.LINE_NUMBER
, OALV.NAME ASSET_NUMBER
, KLE.OEC COST
, OKHFV.CONTRACT_NUMBER
, OKHFV.START_DATE
, OKHFV.END_DATE
, OKHFV.ID CONTRACT_ID
, OKL_AM_UTIL_PVT.GET_ASSET_QUANTITY (OALV.ID) QUANTITY
, OKHFV.STS_CODE CONTRACT_STATUS
, SYSDATE EFFECTIVE_FROM
, NULL SPLIT_KLE_NAME
FROM OKC_K_LINES_V OALV
, OKL_K_LINES KLE
, OKC_K_HEADERS_B OKHFV
, OKC_LINE_STYLES_B LSE
WHERE OALV.ID = KLE.ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND OALV.LSE_ID = LSE.ID
AND OKHFV.ID = OALV.DNZ_CHR_ID
AND OALV.STS_CODE = OKHFV.STS_CODE
AND OALV.STS_CODE <> 'ABANDONED'