PO_VET_PO_LG_VW(SQL View) |
Index Back |
|---|---|
PO Purchasing Event Language |
| SELECT A.TILE_EVENT_ID , L.LANGUAGE_CD , L.TILE_EVENT_NAME FROM PS_PO_TILE_E_LNG L ,PS_PO_TILE_EVENTS A WHERE A.TILE_EVENT_TYPE='PO' AND L.TILE_EVENT_ID=A.TILE_EVENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Event Short Name | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | TILE_EVENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |