PRCR_VIEW_IDPRCR_VALID_VIEW(SQL View) |
Index Back |
|---|---|
Procurement Valid Views View |
| SELECT recname FROM PSRECDEFN WHERE recname IN ('PRCR_HST_AAA_VW', 'PRCR_HST_SVN_VW', 'PRCR_HST_VND_VW', 'PRCR_LST_APO_VW', 'PRCR_LST_AAP_VW','PRCR_LST_ARC_VW' , 'PRCR_LST_ARQ_VW' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCR_VIEW_ID |
Character(15) | VARCHAR2(15) NOT NULL | View ID |