VIEW: APPS.OKL_LA_TRADEIN_LOV_UV

Source

View Text - Preformatted

SELECT FINA.ID ID, TL.NAME ASSET_NUMBER, substr(TL.ITEM_DESCRIPTION, 1, 200) DESCRIPTION, CHR.ID CHR_ID, FINA.DNZ_CHR_ID DNZ_CHR_ID, LS.LTY_CODE LTY_CODE, LS.LSE_TYPE LSE_TYPE, FINA.LINE_NUMBER LINE_NUMBER, FINA.DATE_TERMINATED DATE_TERMINATED, FINA.START_DATE START_DATE_ACTIVE, FINA.END_DATE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(trunc(FINA.start_date), trunc(sysdate))), -1, 'I', DECODE(SIGN(trunc(sysdate)- NVL(trunc(FINA.end_date), trunc(sysdate))), 1, 'I', 'A')) STATUS, NULL PRIMARY_UOM_CODE, CHR.STS_CODE CONTRACT_STATUS, CHR.AUTHORING_ORG_ID ORG_ID, CHR.INV_ORGANIZATION_ID INV_ORG_ID, FINA.STS_CODE OKL_LINE_STATUS, STS.STE_CODE OKC_LINE_STATUS FROM OKC_K_LINES_TL TL,OKC_K_LINES_B FINA,OKC_LINE_STYLES_B LS,OKC_STATUSES_B STS,OKC_K_HEADERS_B CHR WHERE TL.ID = FINA.ID AND TL.LANGUAGE = USERENV('LANG') AND LS.ID = FINA.LSE_ID AND LS.LTY_CODE = 'FREE_FORM1' AND STS.CODE = FINA.STS_CODE AND TRUNC(SYSDATE) between TRUNC(NVL(STS.START_DATE,SYSDATE)) AND TRUNC(NVL(STS.END_DATE,SYSDATE+1)) AND FINA.CHR_ID = CHR.ID AND CHR.SCS_CODE in ('LEASE','LOAN','QUOTE') AND STS.STE_CODE NOT IN ('EXPIRED','TERMINATED','CANCELLED','HOLD') AND chr.id = fina.dnz_chr_id

View Text - HTML Formatted

SELECT FINA.ID ID
, TL.NAME ASSET_NUMBER
, SUBSTR(TL.ITEM_DESCRIPTION
, 1
, 200) DESCRIPTION
, CHR.ID CHR_ID
, FINA.DNZ_CHR_ID DNZ_CHR_ID
, LS.LTY_CODE LTY_CODE
, LS.LSE_TYPE LSE_TYPE
, FINA.LINE_NUMBER LINE_NUMBER
, FINA.DATE_TERMINATED DATE_TERMINATED
, FINA.START_DATE START_DATE_ACTIVE
, FINA.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(FINA.START_DATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE)- NVL(TRUNC(FINA.END_DATE)
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, CHR.STS_CODE CONTRACT_STATUS
, CHR.AUTHORING_ORG_ID ORG_ID
, CHR.INV_ORGANIZATION_ID INV_ORG_ID
, FINA.STS_CODE OKL_LINE_STATUS
, STS.STE_CODE OKC_LINE_STATUS
FROM OKC_K_LINES_TL TL
, OKC_K_LINES_B FINA
, OKC_LINE_STYLES_B LS
, OKC_STATUSES_B STS
, OKC_K_HEADERS_B CHR
WHERE TL.ID = FINA.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = FINA.LSE_ID
AND LS.LTY_CODE = 'FREE_FORM1'
AND STS.CODE = FINA.STS_CODE
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(STS.START_DATE
, SYSDATE))
AND TRUNC(NVL(STS.END_DATE
, SYSDATE+1))
AND FINA.CHR_ID = CHR.ID
AND CHR.SCS_CODE IN ('LEASE'
, 'LOAN'
, 'QUOTE')
AND STS.STE_CODE NOT IN ('EXPIRED'
, 'TERMINATED'
, 'CANCELLED'
, 'HOLD')
AND CHR.ID = FINA.DNZ_CHR_ID