VIEW: APPS.AHL_VENDOR_CERTIFICATIONS_V

Source

View Text - Preformatted

SELECT ahl.VENDOR_CERTIFICATION_ID, ahl.OBJECT_VERSION_NUMBER, ahl.CREATION_DATE, ahl.CREATED_BY, ahl.LAST_UPDATE_DATE, ahl.LAST_UPDATED_BY, ahl.LAST_UPDATE_LOGIN, ven.VENDOR_ID, ven.VENDOR_NAME, ahl.VENDOR_SITE_ID, site.VENDOR_SITE_CODE, con.VENDOR_CONTACT_ID, rtrim(DECODE(con.PREFIX,NULL,'',con.PREFIX||' ')|| DECODE(con.FIRST_NAME,NULL,'',con.FIRST_NAME||' ')|| DECODE(con.MIDDLE_NAME,NULL,'',con.MIDDLE_NAME||' ')||con.LAST_NAME), ahl.ACTIVE_START_DATE, ahl.ACTIVE_END_DATE, ahl.ATTRIBUTE_CATEGORY, ahl.ATTRIBUTE1, ahl.ATTRIBUTE2, ahl.ATTRIBUTE3, ahl.ATTRIBUTE4, ahl.ATTRIBUTE5, ahl.ATTRIBUTE6, ahl.ATTRIBUTE7, ahl.ATTRIBUTE8, ahl.ATTRIBUTE9, ahl.ATTRIBUTE10, ahl.ATTRIBUTE11, ahl.ATTRIBUTE12, ahl.ATTRIBUTE13, ahl.ATTRIBUTE14, ahl.ATTRIBUTE15, ahl.WARRANTY_FLAG FROM AHL_VENDOR_CERTIFICATIONS ahl, PO_VENDORS ven, PO_VENDOR_SITES_ALL site, AP_SUPPLIER_CONTACTS con WHERE ahl.vendor_site_id = site.vendor_site_id AND site.vendor_id = ven.vendor_id AND ahl.vendor_contact_id = con.vendor_contact_id(+)

View Text - HTML Formatted

SELECT AHL.VENDOR_CERTIFICATION_ID
, AHL.OBJECT_VERSION_NUMBER
, AHL.CREATION_DATE
, AHL.CREATED_BY
, AHL.LAST_UPDATE_DATE
, AHL.LAST_UPDATED_BY
, AHL.LAST_UPDATE_LOGIN
, VEN.VENDOR_ID
, VEN.VENDOR_NAME
, AHL.VENDOR_SITE_ID
, SITE.VENDOR_SITE_CODE
, CON.VENDOR_CONTACT_ID
, RTRIM(DECODE(CON.PREFIX
, NULL
, ''
, CON.PREFIX||' ')|| DECODE(CON.FIRST_NAME
, NULL
, ''
, CON.FIRST_NAME||' ')|| DECODE(CON.MIDDLE_NAME
, NULL
, ''
, CON.MIDDLE_NAME||' ')||CON.LAST_NAME)
, AHL.ACTIVE_START_DATE
, AHL.ACTIVE_END_DATE
, AHL.ATTRIBUTE_CATEGORY
, AHL.ATTRIBUTE1
, AHL.ATTRIBUTE2
, AHL.ATTRIBUTE3
, AHL.ATTRIBUTE4
, AHL.ATTRIBUTE5
, AHL.ATTRIBUTE6
, AHL.ATTRIBUTE7
, AHL.ATTRIBUTE8
, AHL.ATTRIBUTE9
, AHL.ATTRIBUTE10
, AHL.ATTRIBUTE11
, AHL.ATTRIBUTE12
, AHL.ATTRIBUTE13
, AHL.ATTRIBUTE14
, AHL.ATTRIBUTE15
, AHL.WARRANTY_FLAG
FROM AHL_VENDOR_CERTIFICATIONS AHL
, PO_VENDORS VEN
, PO_VENDOR_SITES_ALL SITE
, AP_SUPPLIER_CONTACTS CON
WHERE AHL.VENDOR_SITE_ID = SITE.VENDOR_SITE_ID
AND SITE.VENDOR_ID = VEN.VENDOR_ID
AND AHL.VENDOR_CONTACT_ID = CON.VENDOR_CONTACT_ID(+)