BO_REQUEST_VW

(SQL View)
 Index Back

FSR Search View

Financial Structure Request Search View

SELECT A.BO_REQUEST_ID , A.BO_REQ_STATUS , A.BO_REQ_SECURITY , C.OPRDEFNDESC , A.BO_REQ_REASON , A.REQUESTOR_ID , COUNT(B.BO_REQUEST_ID) FROM PS_BO_REQUEST A LEFT OUTER JOIN PS_BO_REQUEST_DTL B ON A.BO_REQUEST_ID=B.BO_REQUEST_ID , PSOPRDEFN C WHERE A.GL_ENTERED_BY=C.OPRID GROUP BY A.BO_REQUEST_ID, A.BO_REQ_SECURITY, A.BO_REQ_STATUS, C.OPRDEFNDESC, A.BO_REQ_REASON, A.REQUESTOR_ID

# 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 BO_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Status
C=Canceled
E=Error
F=Completed
N=New
P=In Progress
3 BO_REQ_SECURITY Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Security Flag

Y/N Table Edit

4 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By
5 BO_REQ_REASON Character(20) VARCHAR2(20) NOT NULL Financial Structure Request Reason

Prompt Table: BO_REQ_RSN_VW

6 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
7 BO_REQ_DTL_COUNT Number(3,0) SMALLINT NOT NULL Financial Structure Request Detail Total