PV_TEMPL_KIT_VW(SQL View) |
Index Back |
|---|---|
Template View/* Victor Ramirez Dec.1,2006 ICE #1591234000/693784 "Purchasing Kit - Search Results do not Apply EffDt" */ Effective Date logic included |
| SELECT DISTINCT K.SETID , K.KIT_ITEM , M.DESCR , P.DESCR254_MIXED ,'KIT' , ' ' , ' ' FROM PS_PURCH_KIT_TBL K , PS_PURCH_ITEM_ATTR P , PS_PURCH_KIT_MSTR M WHERE K.SETID = P.SETID AND K.CHILD_ITM = P.INV_ITEM_ID AND K.SETID = M.SETID AND K.KIT_ITEM = M.KIT_ITEM AND M.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PURCH_KIT_MSTR WHERE SETID = M.SETID AND KIT_ITEM = M.KIT_ITEM AND EFFDT <= %CurrentDateIn) AND M.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR5 | Character(5) | VARCHAR2(5) NOT NULL | Identifier |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | TEMPLATE_DESC | Character(30) | VARCHAR2(30) NOT NULL | Template Description |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 5 | PV_TEMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
KIT=Company Templates PER=Templates |
| 6 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |