View: OKL_FUND_VENDOR_SITES_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for Funding vendor sites
Implementation/DBA Data:	APPS.OKL_FUND_VENDOR_SITES_UV

View Text

SELECT A.ID1
, A.ID2
, A.VENDOR_ID
, PV.SEGMENT1
, PV.VENDOR_NAME
, CHP.DNZ_CHR_ID
, A.NAME
, A.ORG_ID
, A.END_DATE_ACTIVE
, A.START_DATE_ACTIVE
, A.STATUS
, A.DESCRIPTION
, A.PAY_SITE_FLAG
, A.PARTY_ID
, A.PARTY_ID2
FROM OKX_VENDOR_SITES_V A
, OKC_K_PARTY_ROLES_B CHP
, PO_VENDORS PV
WHERE A.VENDOR_ID = PV.VENDOR_ID
AND CHP.RLE_CODE = 'OKL_VENDOR'
AND PV.VENDOR_ID = CHP.OBJECT1_ID1
AND CHP.OBJECT1_ID2 = '#'
AND CHP.CLE_ID IS NULL

Columns