View: OKL_K_LINE_VENDORS_UV

Product:	OKL - Lease and Finance Management
Description:	Lease Contract line vendor summary view
Implementation/DBA Data:	APPS.OKL_K_LINE_VENDORS_UV

View Text

SELECT LTY_CODE
, PARTY.ID ID
, NAME
, DESCRIPTION
, RLE_CODE
, JTOT_OBJECT1_CODE
, OBJECT1_ID1
, OBJECT1_ID2
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.CHR_ID CHR_ID
, LINE.ID CLE_ID
, CPL_ID
FROM OKC_K_PARTY_ROLES_B PARTY
, OKX_VENDORS_V VEN
, OKC_K_LINES_B LINE
, OKC_LINE_STYLES_B STY
WHERE LINE.LSE_ID = STY.ID
AND LINE.ID = PARTY.CLE_ID
AND PARTY.OBJECT1_ID1 = VEN.ID1
AND PARTY.OBJECT1_ID2 = VEN.ID2
AND PARTY.DNZ_CHR_ID = LINE.DNZ_CHR_ID

Columns