zOs/SKELS/NAKPCKG

select
        collid, Name, version, conToken, timeStamp, pcTimestamp, type,
        validate, isolation, valid, operative, owner, qualifier
from
    ( select  p.*
        from sysibm.syspackdep d join sysibm.syspackage p
                on p.location = d.dLocation and p.collid = d.dCollid
                    and p.name = d.dName and  p.conToken = d.dConToken
        where bType in ('R', 'P')
              and bQualifier $DBIN
      union all select p.*
        from sysibm.syspackdep d join sysibm.syspackage p
              on p.location = d.dLocation and p.collid = d.dCollid
                  and p.name = d.dName and  p.conToken = d.dConToken
            join sysibm.systables t
                on bType = 'T' and bQualifier = t.creator
                             and d.bName = t.name
        where dbName $DBIN
      union all select p.*
        from sysibm.syspackdep d join sysibm.syspackage p
              on p.location = d.dLocation and p.collid = d.dCollid
                  and p.name = d.dName and  p.conToken = d.dConToken
            join sysibm.sysIndexes i
                on bType = 'I' and bQualifier = i.creator
                               and d.bName = i.name
        where dbName $DBIN
    ) u
group by collid, Name, version, conToken, timeStamp, pcTimestamp, type,
         validate, isolation, valid, operative, owner, qualifier
order by name, pcTimestamp, collid, version