RBC_SBMT_OPR_VW(SQL View) |
Index Back |
---|---|
Submit operator veiwused to retrieve submit operator view |
SELECT A.OPRID ,B.BO_NAME_DISPLAY FROM PSOPRALIAS A ,PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID (+) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SUBMIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Submitted By OPRID......................................... |
2 | DESCR_CM | Character(80) | VARCHAR2(80) NOT NULL | DESCR_CM |