SETIDINV_ITEM_IDEM_ITM_CATEG_VW(SQL View) |
Index Back |
|---|---|
Item Category View |
| SELECT DISTINCT a.setid , a.inv_item_id , f.category_id , F.CATEGORY_CD FROM PS_MASTER_ITEM_TBL A , PS_ITM_CAT_TBL F WHERE A.SETID = F.SETID AND A.CATEGORY_ID = F.CATEGORY_ID AND F.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL F1 WHERE F.SETID = F1.SETID AND F.CATEGORY_TYPE = F1.CATEGORY_TYPE AND F.CATEGORY_CD = F1.CATEGORY_CD AND F.CATEGORY_ID = F1.CATEGORY_ID AND F.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 4 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |