/* Custom Template for extracting Objects Attributes
  #New: 11.08.2014/J.Fes
  Avialable Paramters:
   - :para_ItemPiud
   - :para_IrPiud
   - :para_DsPiud
   Example: MTU 11.08.2014
*/
/* Custom Template for extracting Objects Attributes
  #New: 11.08.2014/J.Fes */
SELECT at1.PM0PARTTYPE
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.PM0CADDOCRM  at1 ON (at1.puid = mf.rdata_fileu)
where IR.puid = :para_IrPuid
