PV_TEMPL_KIT_V2(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 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 | KIT_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Purchasing Kit ID |
| 3 | TEMPLATE_DESC | Character(30) | VARCHAR2(30) NOT NULL | Template Description |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |