USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
REQ_IDA=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
SPF_E_RCNTRQ_VW(SQL View) |
Index Back |
|---|---|
Recently Create RequisitionsRecently Create Requisitions view for Pagelets |
| SELECT O.OPRID , R.BUSINESS_UNIT , R.REQ_ID , R.REQ_NAME , R.REQ_DT , R.REQ_STATUS , SUM(L.MERCHANDISE_AMT) , R.CURRENCY_CD FROM PS_REQ_HDR R , PS_REQ_LINE L , PS_OPR_DEF_TBL_FS O WHERE R.BUSINESS_UNIT = L.BUSINESS_UNIT AND R.REQ_ID = L.REQ_ID AND O.OPRID = R.REQUESTOR_ID GROUP BY O.OPRID , R.BUSINESS_UNIT , R.REQ_ID , R.REQ_NAME, R.REQ_DT , R.REQ_STATUS , R.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 4 | REQ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Requisition Name |
| 5 | REQ_DT | Date(10) | DATE NOT NULL | Requisition Date |
| 6 | REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Req status
A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled |
| 7 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |