WM_EPL_SEL_VW2

(SQL View)
 Index Back

EPL Selection view

Equipment Parts List Selection view

SELECT DISTINCT B.SETID , A.BUSINESS_UNIT , A.ASSET_ID , B.EPL_TMPL_ID , B.STATUS , B.DESCR100 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL , B.PROD_VERSION FROM PS_ASSET A , PS_AM_EPL_MASTR B WHERE A.ASSET_TYPE = B.ASSET_TYPE AND A.ASSET_SUBTYPE = B.ASSET_SUBTYPE AND B.STATUS = 'A' AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND REC_GROUP_ID = 'AM_15' AND RECNAME = 'AM_EPL_MASTR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template
5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
7 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
8 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE

9 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

10 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: MFG_MODEL_VW

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