[Home] [Help]
View: OKL_LA_VENDORS_UV
Product: | OKL - Lease and Finance Management |
Description: | User interface view for asset vendors lists of values page |
Implementation/DBA Data: |
APPS.OKL_LA_VENDORS_UV
|
View Text
SELECT CHP.ID ID
, PV.SEGMENT1 SEGMENT1
, PV.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, CHP.DNZ_CHR_ID DNZ_CHR_ID
, CHP.OBJECT1_ID1 OBJECT1_ID1
, CHP.OBJECT1_ID2 OBJECT1_ID2
FROM OKC_K_PARTY_ROLES_B CHP
, PO_VENDORS PV
WHERE CHP.RLE_CODE = 'OKL_VENDOR'
AND PV.VENDOR_ID = CHP.OBJECT1_ID1
AND CHP.OBJECT1_ID2 = '#'
AND CLE_ID IS NULL
Columns
Name |
ID |
SEGMENT1 |
VENDOR_ID |
VENDOR_NAME |
DNZ_CHR_ID |
OBJECT1_ID1 |
OBJECT1_ID2 |