Teamcenter: Teamcenter12条件查询

Teamcenter 12  查询 条件：

-- 条件 （N:BMIDE>>扩展>>规则>>条件 ）
-- 条件查询
SELECT  cond.puid as condition_puid, 
       cond.pcondition_name "条件名称",
       cond.pcondition_desc AS "条件描述",
       cond.pexpression as "表达式", 
       COND.VLA_522_3  AS  "参数的个数", 
       pm.pseq AS "序号", 
       CPM.PUID AS  CPM_PUID,
       cpm.pparameter_type "参数类型",
       cpm.pparameter_name "参数名称" 
     --  ,COND.* 
 FROM INFODBA.PCONDITION cond -- 138
 , PPARAMETERS_0  pm ,
 INFODBA.PCONDITIONPARAMETER cpm
 where cond.puid = pm.puid(+) 
  and pm.pvalu_0 = cpm.puid(+) 
   and  UPPER( PCONDITION_NAME ) LIKE UPPER('ISTRUE')
 ORDER BY cond.pcondition_name ,pm.pseq ;