VIEW: APPS.OKL_LA_LN_ITM_UV

Source

View Text - Preformatted

SELECT cle.id line_id, cle.cle_id line_cle_id, cle.sts_code line_sts_code, cle.currency_code line_currency_code, cle.line_number line_line_number, cle.display_sequence line_display_sequence, cle.lse_id line_lse_id, cle.start_date line_start_date, cle.end_date line_end_date, cle.price_negotiated line_price_negotiated, cle.dnz_chr_id line_dnz_chr_id, cle.chr_id line_chr_id, kle.capital_amount line_capital_amount, item.id item_id, item.cle_id item_cle_id, item.OBJECT1_ID1 item_object1_id1, item.OBJECT1_ID2 item_object1_id2, item.JTOT_OBJECT1_CODE item_jtot_object1_code, tl.name item_name, tl.item_description item_description, item.chr_id item_chr_id, item.dnz_chr_id item_dnz_chr_id, item.uom_code item_uom_code, item.exception_yn item_exception_yn, item.number_of_items item_number_of_items, lse.lty_code ls_lty_code, lse.id ls_id, TO_CHAR(null) serv_cov_prd_id, kle.amount line_amount FROM OKC_K_LINES_B CLE,OKC_LINE_STYLES_B LSE,OKC_K_ITEMS ITEM,OKL_K_LINES KLE,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 lse.id = cle.lse_id and kle.id = cle.id and item.cle_id = cle.id and item.dnz_chr_id = cle.dnz_chr_id and item.object1_id1 = fina.id and item.object1_id2 = '#' and chr.id = cle.dnz_chr_id and chr.id = fina.dnz_chr_id AND 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 STS.STE_CODE <> 'CANCELLED' AND TRUNC(SYSDATE) between TRUNC(NVL(STS.START_DATE,SYSDATE)) AND TRUNC(NVL(STS.END_DATE,SYSDATE+1)) AND FINA.DNZ_CHR_ID = CHR.ID AND CHR.SCS_CODE in ('LEASE','LOAN','QUOTE')

View Text - HTML Formatted

SELECT CLE.ID LINE_ID
, CLE.CLE_ID LINE_CLE_ID
, CLE.STS_CODE LINE_STS_CODE
, CLE.CURRENCY_CODE LINE_CURRENCY_CODE
, CLE.LINE_NUMBER LINE_LINE_NUMBER
, CLE.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE
, CLE.LSE_ID LINE_LSE_ID
, CLE.START_DATE LINE_START_DATE
, CLE.END_DATE LINE_END_DATE
, CLE.PRICE_NEGOTIATED LINE_PRICE_NEGOTIATED
, CLE.DNZ_CHR_ID LINE_DNZ_CHR_ID
, CLE.CHR_ID LINE_CHR_ID
, KLE.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT
, ITEM.ID ITEM_ID
, ITEM.CLE_ID ITEM_CLE_ID
, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1
, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2
, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE
, TL.NAME ITEM_NAME
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM.CHR_ID ITEM_CHR_ID
, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID
, ITEM.UOM_CODE ITEM_UOM_CODE
, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN
, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS
, LSE.LTY_CODE LS_LTY_CODE
, LSE.ID LS_ID
, TO_CHAR(NULL) SERV_COV_PRD_ID
, KLE.AMOUNT LINE_AMOUNT
FROM OKC_K_LINES_B CLE
, OKC_LINE_STYLES_B LSE
, OKC_K_ITEMS ITEM
, OKL_K_LINES KLE
, 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 LSE.ID = CLE.LSE_ID
AND KLE.ID = CLE.ID
AND ITEM.CLE_ID = CLE.ID
AND ITEM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND ITEM.OBJECT1_ID1 = FINA.ID
AND ITEM.OBJECT1_ID2 = '#'
AND CHR.ID = CLE.DNZ_CHR_ID
AND CHR.ID = FINA.DNZ_CHR_ID
AND 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 STS.STE_CODE <> 'CANCELLED'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(STS.START_DATE
, SYSDATE))
AND TRUNC(NVL(STS.END_DATE
, SYSDATE+1))
AND FINA.DNZ_CHR_ID = CHR.ID
AND CHR.SCS_CODE IN ('LEASE'
, 'LOAN'
, 'QUOTE')