/* Custom Template for extracting Objects Attributes
  #New: 11.08.2014/J.Fes
  Avialable Paramters:
   - :para_ItemPuid
   - :para_IrPuid
   - :para_DsPuid
*/
SELECT at1.* -- mf.* -- pr.rsecondary_objectu -- ir.*,
from infodba.pitemrevision IR
 INNER JOIN infodba.PIMANRELATION pr ON (pr.rprimary_objectu = IR.puid)
 INNER JOIN infodba.PFORM mf ON (mf.puid = pr.rsecondary_objectu)
 INNER JOIN infodba.PM0STGNDCRM at1 ON (at1.puid = mf.puid)
where IR.puid = :para_IrPuid
