WM_EPL_SEL_VW4 (SQL View)	Index Back
WM EPL Selection View #3 (WO) Work Management Equipment Parts List Selection View -- this version of the EPL Selection View is maintained for use by the Work Order component (allows access to multiple EPL templates)

WM_EPL_SEL_VW4

(SQL View)

WM EPL Selection View #3 (WO)

Work Management Equipment Parts List Selection View -- this version of the EPL Selection View is maintained for use by the Work Order component (allows access to multiple EPL templates)

SELECT A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , B.SETID , B.EPL_TMPL_ID , B.DESCR100 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , B.PROD_VERSION , (CASE WHEN A.EPL_TMPL_ID = B.EPL_TMPL_ID THEN 'Y' ELSE 'N' END) , 'N' FROM PS_ASSET A , PS_AM_EPL_MASTR B WHERE A.ASSET_TYPE <> ' ' AND B.SETID = ( SELECT J.SETID FROM PS_SET_CNTRL_REC J WHERE J.SETCNTRLVALUE = A.BUSINESS_UNIT AND J.REC_GROUP_ID = 'AM_15' AND J.RECNAME = 'AM_EPL_MASTR') AND B.ASSET_TYPE = A.ASSET_TYPE AND (B.ASSET_SUBTYPE IN (A.ASSET_SUBTYPE, ' ')) AND (B.MFG_ID IN (A.MFG_ID, ' ')) AND (B.MODEL IN (A.MODEL, ' ')) AND B.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

6 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other

7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
Prompt Table: AM_SUBTYPE

8 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
Prompt Table: MANUFACTURER

9 MODEL Character(30) VARCHAR2(30) NOT NULL Model
Prompt Table: MFG_MODEL_VW

10 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version

11 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default
Y/N Table Edit
Default Value: N

12 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit Prompt Table: SP_BU_AM_NONVW
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	EPL_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	Parts List Template
5	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
6	ASSET_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Asset Type 010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other
7	ASSET_SUBTYPE	Character(15)	VARCHAR2(15) NOT NULL	Asset Subtype Prompt Table: AM_SUBTYPE
8	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: MANUFACTURER
9	MODEL	Character(30)	VARCHAR2(30) NOT NULL	Model Prompt Table: MFG_MODEL_VW
10	PROD_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Product Version
11	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
12	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Y/N Table Edit Default Value: N