[Home] [Help]
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
Name |
VENDOR_SITE_ID |
ID2 |
VENDOR_ID |
VENDOR_NUMBER |
VENDOR_NAME |
DNZ_CHR_ID |
VENDOR_SITE_CODE |
ORG_ID |
END_DATE_ACTIVE |
START_DATE_ACTIVE |
STATUS |
VENDOR_SITE_ADDRESS |
PAY_SITE_FLAG |
PARTY_ID |
PARTY_ID2 |