OPRIDRUN_CNTL_IDITM_CHG_REC_LISTIN_ITMC_REC_LST(SQL View) |
Index Back |
|---|---|
Item Change - Record ListItem Change Process - Record List |
| SELECT DISTINCT A.OPRID ,A.RUN_CNTL_ID ,A.ITM_CHG_REC_LIST ,B.RECNAME FROM PS_RUN_IN_ITMC_LST A ,PS_IN_ITM_CHG_LN B WHERE A.ITM_CHG_REC_LIST = B.ITM_CHG_REC_LIST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ITM_CHG_REC_LIST |
Character(3) | VARCHAR2(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template.Contains translate value for Record names for Change Value Page in Item Template. |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |