SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
TREE_NAMECATEGORY_IDPrompt Table: ITM_CAT_VW
INV_ITEM_IDPrompt Table: INV_ITEMS
PV_PERF_STD_VW(SQL View) |
Index Back |
|---|---|
Item Catalog Search ViewOriginated from ITM_CAT_STD_VW |
| SELECT T.SETID ,T.TREE_NAME ,A.CATEGORY_ID ,A.INV_ITEM_ID ,A.UNIT_MEASURE_STD ,A.DESCR FROM PS_MASTER_ITEM_TBL A , PS_PV_CAT_TREE_TBL T , PS_PURCH_ITEM_ATTR D WHERE A.SETID = T.SETID AND A.SETID = D.SETID AND A.CATEGORY_ID = T.CATEGORY_ID AND A.INV_ITEM_ID = D.INV_ITEM_ID AND D.SUBITEM_ONLY <> 'Y' AND ((%CurrentDateIn >= D.PO_AVAIL_DT) AND (D.PO_UNAVAIL_DT > %CurrentDateIn)) AND A.ITM_STATUS_CURRENT = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: INV_ITEMS |
| 5 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |