[Home] [Help]
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
Name |
LTY_CODE |
ID |
NAME |
DESCRIPTION |
RLE_CODE |
JTOT_OBJECT1_CODE |
OBJECT1_ID1 |
OBJECT1_ID2 |
DNZ_CHR_ID |
CHR_ID |
CLE_ID |
CPL_ID |