[Home] [Help]
View: 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 |