Teamcenter: BMIDE 设置传统LOV后，通过SQL 查询 传统LOV

在Teamcenter 12 的 BMIDE 设置传统LOV后，通过SQL 查询 传统LOV

-- N: BMIDE>>扩展>>LOV>>传统LOV.之LOV值 
SELECT LOV.PUID AS LOV_PUID,
       LOV.PLOV_NAME AS "LOV名称",
       LOV.PLOV_TYPE AS "LOV类型",
       LOV.VLA_606_21 AS "LOV选项数量",
       LV.PSEQ AS "序号",
       LV.PVAL_0 AS "LOV值",
       COND.PCONDITION_NAME AS "LOV值条件"
      -- ,COND.* 
  FROM INFODBA.PLISTOFVALUES LOV,  -- LOV名称
       INFODBA.PLOV_VALUES_3 LV , -- LOV列表选项值 
	   INFODBA.PLOV_VALUE_DESCRIPTIONS_3 LVD, -- -- LOV列表选项描述 
       INFODBA.PLOV_VALUE_CONDITIONS LVC, -- LOV条件
       INFODBA.PCONDITION COND  -- 条件
 WHERE LOV.PLOV_NAME LIKE 'K8%'
  AND LOV.PUID = LV.PUID 
  AND LV.PUID = LVD.PUID
  AND LV.PSEQ = LVD.PSEQ
  AND LV.PUID = LVC.PUID 
  AND LV.PSEQ = LVC.PSEQ 
  AND LVC.PVALU_0 = COND.PUID
 ORDER BY LOV.PLOV_NAME , LV.PSEQ ;