VIEW: APPS.OKL_AM_ASSET_LOV_UV

Source

View Text - Preformatted

SELECT OALV.ID KLE_ID , OALV.NAME ASSET_NUMBER , OALV.ITEM_DESCRIPTION ASSET_DESCRIPTION , OALV.CHR_ID CHR_ID , OKHV.CONTRACT_NUMBER CONTRACT_NUMBER , OKHV.START_DATE START_DATE , OKHV.END_DATE EXPIRATION_DATE, STS.CODE LINE_STS_CODE , STS.MEANING LINE_STATUS FROM OKC_K_LINES_V OALV,OKC_K_HEADERS_B OKHV,OKC_LINE_STYLES_B LSE,OKC_STATUSES_V STS WHERE LSE.LTY_CODE = 'FREE_FORM1' AND OALV.LSE_ID = LSE.ID AND OALV.CHR_ID = OKHV.ID AND NOT EXISTS (SELECT KLE_ID FROM OKL_ASSET_RETURNS_V OARV WHERE OARV.KLE_ID = OALV.ID AND OARV.ARS_CODE <> 'CANCELLED') AND OALV.STS_CODE = STS.CODE AND STS.STE_CODE NOT IN ('ENTERED','SIGNED','CANCELLED')

View Text - HTML Formatted

SELECT OALV.ID KLE_ID
, OALV.NAME ASSET_NUMBER
, OALV.ITEM_DESCRIPTION ASSET_DESCRIPTION
, OALV.CHR_ID CHR_ID
, OKHV.CONTRACT_NUMBER CONTRACT_NUMBER
, OKHV.START_DATE START_DATE
, OKHV.END_DATE EXPIRATION_DATE
, STS.CODE LINE_STS_CODE
, STS.MEANING LINE_STATUS
FROM OKC_K_LINES_V OALV
, OKC_K_HEADERS_B OKHV
, OKC_LINE_STYLES_B LSE
, OKC_STATUSES_V STS
WHERE LSE.LTY_CODE = 'FREE_FORM1'
AND OALV.LSE_ID = LSE.ID
AND OALV.CHR_ID = OKHV.ID
AND NOT EXISTS (SELECT KLE_ID
FROM OKL_ASSET_RETURNS_V OARV
WHERE OARV.KLE_ID = OALV.ID
AND OARV.ARS_CODE <> 'CANCELLED')
AND OALV.STS_CODE = STS.CODE
AND STS.STE_CODE NOT IN ('ENTERED'
, 'SIGNED'
, 'CANCELLED')