VIEW: APPS.AHL_ITEM_VENDOR_RELS_V

Source

View Text - Preformatted

SELECT ahl.item_vendor_rel_id, ahl.OBJECT_VERSION_NUMBER, ahl.CREATION_DATE, ahl.CREATED_BY, ahl.LAST_UPDATE_DATE, ahl.LAST_UPDATED_BY, ahl.LAST_UPDATE_LOGIN, ahl.inv_service_item_rel_id, ahl.vendor_certification_id, ven.vendor_id, ven.vendor_name, ven.vendor_site_id, ven.vendor_location, ven.vendor_contact_id, ven.vendor_contact, ahl.ACTIVE_START_DATE, ahl.ACTIVE_END_DATE, ahl.rank, ahl.service_duration, 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 FROM ahl_item_vendor_rels ahl, ahl_vendor_certifications_v ven WHERE ahl.vendor_certification_id = ven.vendor_certification_id

View Text - HTML Formatted

SELECT AHL.ITEM_VENDOR_REL_ID
, AHL.OBJECT_VERSION_NUMBER
, AHL.CREATION_DATE
, AHL.CREATED_BY
, AHL.LAST_UPDATE_DATE
, AHL.LAST_UPDATED_BY
, AHL.LAST_UPDATE_LOGIN
, AHL.INV_SERVICE_ITEM_REL_ID
, AHL.VENDOR_CERTIFICATION_ID
, VEN.VENDOR_ID
, VEN.VENDOR_NAME
, VEN.VENDOR_SITE_ID
, VEN.VENDOR_LOCATION
, VEN.VENDOR_CONTACT_ID
, VEN.VENDOR_CONTACT
, AHL.ACTIVE_START_DATE
, AHL.ACTIVE_END_DATE
, AHL.RANK
, AHL.SERVICE_DURATION
, 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
FROM AHL_ITEM_VENDOR_RELS AHL
, AHL_VENDOR_CERTIFICATIONS_V VEN
WHERE AHL.VENDOR_CERTIFICATION_ID = VEN.VENDOR_CERTIFICATION_ID