PROCESS_INSTANCEINV_PRCSINST_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.PROCESS_INSTANCE FROM PS_IN_DEMAND A , PS_IN_DEMAND_LOCK B WHERE A.RESERVE_STATUS=' ' AND A.IN_FULFILL_STATE='20' AND %Join (COMMON_KEYS, IN_DEMAND A, IN_DEMAND_LOCK B ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |