VIEW: APPS.OKL_USAGE_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'