SETIDMFG_IDIT_MAPMFGID_VW(SQL View) |
Index Back |
|---|---|
IT - Mapped Mfgs ViewView of Mfgs that exist in the ITAM Code Mappings. Used in as a promp in ITAM Progress Report Template page (Component IT_PRGS_TMPL). |
| SELECT A.SETID , A.MFG_ID , A.DESCR60 FROM PS_MANUFACTURER A WHERE EXISTS ( SELECT 'Y' FROM PS_IT_MAP_CD B WHERE B.IT_MAP_TYPE = '010' AND A.SETID = B.SETID AND A.MFG_ID = B.IT_MAP_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |