[Home] [Help]
View: OKL_COV_PROD_LINES_V
Product: | OKL - Lease and Finance Management |
Description: | This view selects covered product lines from Oracle service contracts |
Implementation/DBA Data: |
APPS.OKL_COV_PROD_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 STS_CODE
, CHR.AUTHORING_ORG_ID ORG_ID
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 = 'COVER_PROD'
AND CLE.DNZ_CHR_ID = CHR.ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND CHR.SCS_CODE = 'SERVICE'
Columns
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
STATUS |
STS_CODE |
ORG_ID |