View: OKX_COVERED_ASSET_V

Product:	OKX - Contracts Integration
Description:	This view stores information about financial asset lines
Implementation/DBA Data:	APPS.OKX_COVERED_ASSET_V

View Text

SELECT FINA.ID ID1
, '#' ID2
, TL.NAME NAME
, TL.ITEM_DESCRIPTION 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(FINA.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(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
FROM OKC_K_LINES_TL TL
, OKC_K_LINES_B FINA
, OKC_LINE_STYLES_B LS
, 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 FINA.CHR_ID = CHR.ID
AND CHR.SCS_CODE IN ('LEASE'
, 'LOAN')

Columns