View: POFV_RFQ_SUPPLIER_LIST_ENTRIES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES

View Text

SELECT SE.VENDOR_LIST_ENTRY_ID
, SE.VENDOR_LIST_HEADER_ID
, '_DF:PO:PO_VENDOR_LIST_ENTRIES:SE'
, SE.VENDOR_ID
, VE.VENDOR_NAME
, SE.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, VS.ORG_ID
, OP.NAME
, SE.VENDOR_CONTACT_ID
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME
, SE.CREATION_DATE
, SE.CREATED_BY
, SE.LAST_UPDATE_DATE
, SE.LAST_UPDATED_BY
FROM PO_VENDOR_LIST_ENTRIES SE
, PO_VENDORS VE
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
, HR_ALL_ORGANIZATION_UNITS OP
WHERE SE.VENDOR_ID = VE.VENDOR_ID
AND SE.VENDOR_SITE_ID = VS.VENDOR_SITE_ID
AND VS.ORG_ID = OP.ORGANIZATION_ID
AND SE.VENDOR_CONTACT_ID = VC.VENDOR_CONTACT_ID(+)
AND '_SEC:VS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns