FND Design Data [Home] [Help]

View: OKL_LA_KLE_VENDORS_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_LA_KLE_VENDORS_UV
View Text

SELECT CPL.ID CPL_ID
, CPL.OBJECT1_ID1
, CPL.OBJECT1_ID2
, CPL.RLE_CODE
, POV.VENDOR_NAME
, CPL.CLE_ID
, CPL.DNZ_CHR_ID
, POV.VENDOR_ID
FROM OKC_K_PARTY_ROLES_B CPL
, PO_VENDORS POV
WHERE CPL.RLE_CODE = 'OKL_VENDOR'
AND POV.VENDOR_ID = CPL.OBJECT1_ID1

Columns

Name
CPL_ID
OBJECT1_ID1
OBJECT1_ID2
RLE_CODE
VENDOR_NAME
CLE_ID
DNZ_CHR_ID
VENDOR_ID