WM_PM_ARM_LVW(SQL View) |
Index Back |
---|---|
PM Maintainable Assets RL ViewView on AM Asset Repository (ASSET) table -- related language view |
SELECT B.SETID , A.BUSINESS_UNIT AS BUSINESS_UNIT_AM , A.ASSET_ID , C.LANGUAGE_CD , C.DESCR , C.DESCR_LONG , C.DESCRSHORT FROM PS_ASSET A , PS_SET_CNTRL_REC B , PS_ASSET_LANG C WHERE A.REPAIRABLE_FLG IN ('Y','N',' ') AND B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.REC_GROUP_ID = 'AM_13' AND B.RECNAME = 'MAINT_TYPE_TBL' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ASSET_ID = A.ASSET_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
3 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |