RQ_APR_PNDNG_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT ,A.REQ_ID ,(CASE WHEN A.line_nbr > 0 THEN 'L' ELSE 'H' END) AS PENDING_STATUS FROM PS_PV_REQ_AW A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWTHREAD_ID=( SELECT MAX(D.EOAWTHREAD_ID) FROM PS_PV_REQ_AW D WHERE D.EOAWPRCS_ID=A.EOAWPRCS_ID AND D.EOAWDEFN_ID=A.EOAWDEFN_ID AND D.BUSINESS_UNIT=A.BUSINESS_UNIT AND D.REQ_ID=A.REQ_ID AND D.LINE_NBR=A.LINE_NBR) AND B.EOAWTHREAD_ID=A.EOAWTHREAD_ID AND A.EOAWPRCS_ID=B.EOAWPRCS_ID AND A.EOAWDEFN_ID=B.EOAWDEFN_ID AND B.EOAWSTEP_STATUS= 'P' ORDER BY A.BUSINESS_UNIT,A.REQ_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | PENDING_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
ACT=Active PEN=Pending |