Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PO_VENDOR_LIST_ENTRIES_V |
SELECT POVL.ROWID
, POV.VENDOR_NAME
, POVS.VENDOR_SITE_CODE
, DECODE(POVL.VENDOR_CONTACT_ID
, NULL
, NULL
, POVC.LAST_NAME||'
, '|| POVC.FIRST_NAME)
, POVL.VENDOR_LIST_ENTRY_ID
, POVL.VENDOR_LIST_HEADER_ID
, POVL.LAST_UPDATE_DATE
, POVL.LAST_UPDATED_BY
, POVL.LAST_UPDATE_LOGIN
, POVL.CREATION_DATE
, POVL.CREATED_BY
, POVL.VENDOR_ID
, POVL.VENDOR_SITE_ID
, POVL.VENDOR_CONTACT_ID
, POVL.ATTRIBUTE_CATEGORY
, POVL.ATTRIBUTE1
, POVL.ATTRIBUTE2
, POVL.ATTRIBUTE3
, POVL.ATTRIBUTE4
, POVL.ATTRIBUTE5
, POVL.ATTRIBUTE6
, POVL.ATTRIBUTE7
, POVL.ATTRIBUTE8
, POVL.ATTRIBUTE9
, POVL.ATTRIBUTE10
, POVL.ATTRIBUTE11
, POVL.ATTRIBUTE12
, POVL.ATTRIBUTE13
, POVL.ATTRIBUTE14
, POVL.ATTRIBUTE15
, POVL.REQUEST_ID
, POVL.PROGRAM_APPLICATION_ID
, POVL.PROGRAM_ID
, POVL.PROGRAM_UPDATE_DATE
, POVS.ORG_ID
FROM PO_VENDORS POV
, PO_VENDOR_SITES POVS
, PO_VENDOR_CONTACTS POVC
, PO_VENDOR_LIST_ENTRIES POVL
WHERE POV.VENDOR_ID = POVL.VENDOR_ID
AND POV.ENABLED_FLAG = 'Y'
AND (SYSDATE BETWEEN NVL(POV.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(POV.END_DATE_ACTIVE
, SYSDATE+1))
AND POVS.VENDOR_SITE_ID = POVL.VENDOR_SITE_ID
AND POVC.VENDOR_CONTACT_ID(+) = POVL.VENDOR_CONTACT_ID
AND SYSDATE < NVL(POVS.INACTIVE_DATE
, SYSDATE+1)