View: OKL_USAGE_LINES_V

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

View Text

SELECT CLE.ID ID1
, '#' ID2
, TL.NAME NAME
, TL.ITEM_DESCRIPTION DESCRIPTION
, CLE.START_DATE START_DATE_ACTIVE
, CLE.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(CLE.START_DATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(TRUNC(CLE.END_DATE)
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, CLE.STS_CODE LINE_STATUS
FROM OKC_K_LINES_B CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LSE
, OKC_K_HEADERS_B CHR
WHERE CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'USAGE'
AND CLE.CHR_ID = CHR.ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND CHR.SCS_CODE = 'SERVICE'

Columns