[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 |