View: OKL_LINE_VENDORS_SITES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view used for vendor site in passthrough related pages
Implementation/DBA Data:	APPS.OKL_LINE_VENDORS_SITES_UV

View Text

SELECT VS.VENDOR_SITE_ID ID1
, '#' ID2
, VS.VENDOR_ID VENDOR_ID
, VS.VENDOR_SITE_CODE NAME
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.ADDRESS_LINE4
, VS.CITY
, VS.COUNTY
, VS.STATE
, VS.PROVINCE
, VS.ZIP
, NULL
, VS.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
, VS.PAY_SITE_FLAG PAY_SITE_FLAG
FROM PO_VENDOR_SITES VS
WHERE NVL(VS.PAY_SITE_FLAG
, 'N') = 'Y'
AND SYSDATE <= NVL(VS.INACTIVE_DATE
, SYSDATE)

Columns