Supplier certification report in R12

In front end we can see the supplier certifications by following the below navigation

Navigation : Supplier Lifecycle Management –> Search for Supplier "%XX%" –> Click on the            Organization tab -> Click on Supplier Certification Tab

Query:
--------

SELECT  PSPE.PARTY_ID    PARTY_ID
       ,PSPE.C_EXT_ATTR1 CERTIFICATE
       ,PSPE.C_EXT_ATTR2 CERTIFICATE_NUMBER
       ,to_char(to_date(PSPE.D_EXT_ATTR3,'DD-MM-YY'),'DD-MON-YYYY') VALID_FROM
       ,to_char(to_date(PSPE.D_EXT_ATTR4,'DD-MM-YY'),'DD-MON-YYYY') VALID_THROUGH
       ,to_char(to_date(PSPE.D_EXT_ATTR5,'DD-MM-YY'),'DD-MON-YYYY') LAST_VALIDATED
       ,PSPE.REQUEST_ID  REQUEST_ID
       ,AS1.VENDOR_NAME  VENDOR_NAME
       ,AS1.SEGMENT1     VENDOR_NUMBER
FROM POS_SUPP_PROF_EXT_B PSPE
    ,AP_SUPPLIERS AS1
WHERE 1 = 1
  AND PSPE.attr_group_id=221
  AND to_date(PSPE.D_EXT_ATTR4,'DD-MM-YY') BETWEEN SYSDATE and SYSDATE+:P_EXP_DAYS
  AND AS1.PARTY_ID = PSPE.PARTY_ID
ORDER BY TO_DATE(PSPE.D_EXT_ATTR4,'DD-MM-YY')
        ,AS1.VENDOR_NAME