Teamcenter12:系统标准视图脚本

Siemens PLM Teamcenter12 系统标准视图脚本，共31个视图，这些视图功能主要以本地化语言表
CREATE OR REPLACE FORCE VIEW INFODBA.ALL_BACKPOINTER_REFERENCES
  AS 
select from_uid, to_uid from POM_BACKPOINTER UNION ALL (select puid from_uid, rprimary_objectu to_uid FROM PIMANRELATION)  UNION ALL (select puid from_uid, rsecondary_objectu  to_uid FROM PIMANRELATION)
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.POM_LOCK
  AS 
SELECT ref_uid,vuid,process,ref_class,type,aspace_uid FROM POM_M_LOCK UNION SELECT ref_uid,vuid,process,ref_class,type,aspace_uid FROM POM_R_LOCK
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_ACL_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_ACL_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pACL_Name AS pval_0 FROM PAM_ACL WHERE pACL_Name IS NOT NULL AND VLA_22_6=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_CONDITION_DESC
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,2000) as pval_0 FROM PL10N_CONDITION_DESC UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pcondition_desc AS pval_0 FROM PCONDITION WHERE pcondition_desc IS NOT NULL AND VLA_530_6=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_DISCIPLINE_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_DISCIPLINE_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pdiscipline_name AS pval_0 FROM PDISCIPLINE WHERE pdiscipline_name IS NOT NULL AND VLA_136_5=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0DESCRIPTION
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,512) as pval_0 FROM PL10N_FND0DESCRIPTION UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Description AS pval_0 FROM PFND0COMMAND WHERE pfnd0Description IS NOT NULL AND VLA_552_9=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0ENTRY
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,512) as pval_0 FROM PL10N_FND0ENTRY UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0entry AS pval_0 FROM PFND0LOVDICTIONARYENTRY WHERE pfnd0entry IS NOT NULL AND VLA_796_3=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0EVENTTYPE_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,256) as pval_0 FROM PL10N_FND0EVENTTYPE_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0eventtype_name AS pval_0 FROM PIMANEVENTTYPE WHERE pfnd0eventtype_name IS NOT NULL AND VLA_252_4=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0FORMATSTRING
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,512) as pval_0 FROM PL10N_FND0FORMATSTRING UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0formatString AS pval_0 FROM PFND0PROPERTYFORMATTER WHERE pfnd0formatString IS NOT NULL AND VLA_212_4=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0MNEMONIC
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,32) as pval_0 FROM PL10N_FND0MNEMONIC UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Mnemonic AS pval_0 FROM PFND0COMMAND WHERE pfnd0Mnemonic IS NOT NULL AND VLA_552_10=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0MNEMONIC_0
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,32) as pval_0 FROM PL10N_FND0MNEMONIC_0 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Mnemonic AS pval_0 FROM PFND0COMMANDCOLLECTION WHERE pfnd0Mnemonic IS NOT NULL AND VLA_553_6=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_FND0NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Name AS pval_0 FROM PFND0CLIENT WHERE pfnd0Name IS NOT NULL AND VLA_547_3=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0NAME_0
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_FND0NAME_0 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Name AS pval_0 FROM PFND0COMMAND WHERE pfnd0Name IS NOT NULL AND VLA_552_11=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0NAME_1
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_FND0NAME_1 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0Name AS pval_0 FROM PFND0COMMANDCOLLECTION WHERE pfnd0Name IS NOT NULL AND VLA_553_7=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_FND0TOOLTIP
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,240) as pval_0 FROM PL10N_FND0TOOLTIP UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pfnd0ToolTip AS pval_0 FROM PFND0COMMAND WHERE pfnd0ToolTip IS NOT NULL AND VLA_552_12=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_IDCXT_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_IDCXT_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pidcxt_name AS pval_0 FROM PIDCONTEXT WHERE pidcxt_name IS NOT NULL AND VLA_247_3=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pname AS pval_0 FROM PPOM_GROUP WHERE pname IS NOT NULL AND VLA_12_6=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_NAME_0
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_NAME_0 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pname AS pval_0 FROM PCHANGETYPEDATA WHERE pname IS NOT NULL AND VLA_111_7=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_NAME_1
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_NAME_1 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pname AS pval_0 FROM PNOTETYPE WHERE pname IS NOT NULL AND VLA_357_4=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_NAME_2
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_NAME_2 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pname AS pval_0 FROM PPSOCCURRENCETYPE WHERE pname IS NOT NULL AND VLA_372_2=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_NAME_3
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_NAME_3 UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pname AS pval_0 FROM PPSVIEWTYPE WHERE pname IS NOT NULL AND VLA_378_4=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_PROPERTY_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_PROPERTY_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pproperty_name AS pval_0 FROM PPROPERTYINFO WHERE pproperty_name IS NOT NULL AND VLA_392_4=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_PUBR_OBJECT_DESC
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,240) as pval_0 FROM PL10N_PUBR_OBJECT_DESC UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, ppubr_object_desc AS pval_0 FROM PPUBLICATIONRECORD WHERE ppubr_object_desc IS NOT NULL AND VLA_397_21=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_QUERY_DESC
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,512) as pval_0 FROM PL10N_QUERY_DESC UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pquery_desc AS pval_0 FROM PIMANQUERY WHERE pquery_desc IS NOT NULL AND VLA_257_8=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_QUERY_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_QUERY_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, pquery_name AS pval_0 FROM PIMANQUERY WHERE pquery_name IS NOT NULL AND VLA_257_9=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_RD_DESCRIPTION
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,512) as pval_0 FROM PL10N_RD_DESCRIPTION UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, prd_description AS pval_0 FROM PREPORTDEFINITION WHERE prd_description IS NOT NULL AND VLA_1160_17=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_RD_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_RD_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, prd_name AS pval_0 FROM PREPORTDEFINITION WHERE prd_name IS NOT NULL AND VLA_1160_18=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_ROLE_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,32) as pval_0 FROM PL10N_ROLE_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, prole_name AS pval_0 FROM PROLE WHERE prole_name IS NOT NULL AND VLA_415_5=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_TASKTYPE_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_TASKTYPE_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, ptasktype_name AS pval_0 FROM PTASKTYPE WHERE ptasktype_name IS NOT NULL AND VLA_465_7=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_TCCAL_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,256) as pval_0 FROM PL10N_TCCAL_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, ptccal_name AS pval_0 FROM PTCCALENDAR WHERE ptccal_name IS NOT NULL AND VLA_447_13=0
;
/
CREATE OR REPLACE FORCE VIEW INFODBA.VL10N_TYPE_NAME
  AS 
SELECT puid,  SUBSTR (pval_0,1,5) as locale,  SUBSTR (pval_0,7,1) as preference,  SUBSTR (pval_0,9,1) as status,  SUBSTR (pval_0,11,4) as sequence_no,  SUBSTR (pval_0,49,128) as pval_0 FROM PL10N_TYPE_NAME UNION ALL SELECT puid, 'NONE' as locale, 'M' as preference, 'M' as status, '0000' as sequence_no, ptype_name AS pval_0 FROM PIMANTYPE WHERE ptype_name IS NOT NULL AND VLA_258_8=0
;
/
posted @ 2025-05-10 22:36 samrv 阅读(32) 评论(0) 收藏举报
刷新页面返回顶部
Teamcenter12:系统标准视图脚本

公告
