PV_MST_ITEM_LVW(SQL View) |
Index Back |
---|
SELECT A.SETID , A.INV_ITEM_ID , A.LANGUAGE_CD , A.DESCR , A.DESCR254_MIXED , C.DESCR60 , ' ' , ' ' , 'N' FROM PS_PURCH_ITEM_LANG A , PS_MASTER_ITEM_TBL B , PS_ITM_CAT_TBL_LNG C , PS_INSTALLATION_PO F WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.SETID = C.SETID AND B.CATEGORY_ID = C.CATEGORY_ID AND A.LANGUAGE_CD = C.LANGUAGE_CD AND C.CATEGORY_TYPE = F.CATEGORY_TYPE AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ITM_CAT_TBL D WHERE D.SETID = C.SETID AND D.CATEGORY_TYPE = C.CATEGORY_TYPE AND D.CATEGORY_CD = C.CATEGORY_CD AND D.CATEGORY_ID = C.CATEGORY_ID AND D.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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
6 | CATDESCR | Character(60) | VARCHAR2(60) NOT NULL | Category Description |
7 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
8 | NAME1_VENDOR | Character(40) | VARCHAR2(40) NOT NULL | Vendor Name |
9 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |