WM_WO_IPSRCH_LV (SQL View)	Index Back
WO Insp Plan Search RL View Work Order Inspection Plan Search View (related language) -- used to search for all WO Inspection Plan template definitions, i.e., regardless of active/effective status

WM_WO_IPSRCH_LV

(SQL View)

WO Insp Plan Search RL View

Work Order Inspection Plan Search View (related language) -- used to search for all WO Inspection Plan template definitions, i.e., regardless of active/effective status

SELECT A.SETID , A.WO_TEMPLATE_ID , A.LANGUAGE_CD , A.DESCR50 FROM PS_WM_WO_TMPLT_LG A

Related Language Record for WM_WO_IPSRCH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	WO_TEMPLATE_ID	Character(25)	VARCHAR2(25) NOT NULL	Work Order Task/Job Template ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50