VIEW: APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES

Source

View Text - Preformatted

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(+) WITH READ ONLY

View Text - HTML Formatted

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(+) WITH READ ONLY