USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
REQ_IDLINE_NBRSPF_E_REQAPR_VW(SQL View) |
Index Back |
|---|---|
Recently Create RequisitionsRecently Create Requisitions view for Pagelets |
| SELECT U.OPRID , X.BUSINESS_UNIT , X.REQ_ID , X.LINE_NBR , H.REQ_DT , H.REQ_NAME , R.MERCHANDISE_AMT , R.CURRENCY_CD FROM PS_PV_REQ_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_PV_REQLIN_AW_VW R , PS_REQ_HDR H WHERE S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND S.EOAWPRCS_ID = 'Requisition' AND (S.EOAWTHREAD_ID = X.EOAWPARENT_THREAD OR S.EOAWTHREAD_ID = X.EOAWTHREAD_ID) AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND R.REQ_ID = X.REQ_ID AND R.LINE_NBR = X.LINE_NBR AND R.BUSINESS_UNIT = X.BUSINESS_UNIT AND H.BUSINESS_UNIT = R.BUSINESS_UNIT AND H.REQ_ID = R.REQ_ID AND S.EOAWSTEP_NBR = ( SELECT MIN(S_S.EOAWSTEP_NBR) FROM PS_EOAW_STEPINST S_S WHERE S_S.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE AND S_S.EOAWDEFN_ID = S.EOAWDEFN_ID AND S_S.EOAWPRCS_ID = S.EOAWPRCS_ID AND S_S.EOAWSTEP_STATUS = 'P') |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | REQ_DT | Date(10) | DATE NOT NULL | Requisition Date |
| 6 | REQ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Requisition Name |
| 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 |