BO_REQUEST_IDPrompt Table: BO_REQ_ID_VW
USERIDBO_REQ_USER_VW(SQL View) |
Index Back |
|---|---|
FSR User ViewFinancial Structure Request User View |
| SELECT A.BO_REQUEST_ID , A.GL_ENTERED_BY FROM PS_BO_REQUEST A UNION SELECT A1.BO_REQUEST_ID , B1.ROLEUSER FROM PS_BO_REQUEST A1 , PSROLEUSER B1 WHERE B1.ROLENAME IN ('FSR_AUDITOR', 'FSR_SYSTEM_REVIEWER') UNION SELECT A2.BO_REQUEST_ID , B2.ROLEUSER FROM PS_BO_REQUEST A2 , PSROLEUSER B2 , PS_BO_REQUEST_DTL C2 WHERE A2.BO_REQUEST_ID=C2.BO_REQUEST_ID AND C2.GL_ROLENAME=B2.ROLENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Financial Structure Request ID
Prompt Table: BO_REQ_ID_VW |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |