STOCK_ACTIONSTOCK_ACTN_SRCH(SQL View) |
Index Back |
|---|---|
Search Record for Work ListThis finds Stock Actions from the work list record. Used as Prompt Table by ST_ACTN_RSN_TBL (Record) Used as Search Record by STOCK_ACTN_TBL (PanelGroup) |
| SELECT A.STOCK_ACTION , A.DESCR FROM PS_STOCK_ACTN_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_STOCK_ACTN_TBL WHERE STOCK_ACTION = A. STOCK_ACTION AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ACTION |
Character(3) | VARCHAR2(3) NOT NULL | Stock Action |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |