PV_REQ_SUM_VW

(SQL View)
 Index Back

Approval Requisition Header VW

Used in the PV_APP_MAN_CMP component. Date Initials Reference # Description 112108 PRAG 1807736003 ePro Approve Requisitions page now displays all available requisitions including the requisitions created through Requisition Load process and which are in pending approval status.

SELECT A.BUSINESS_UNIT , A.REQ_ID , B.REQ_NAME , ' ' , B.REQ_STATUS , B.PRIORITY_FLG , B.REQ_DT , B.REQUESTOR_ID , SUM(A.MERCHANDISE_AMT) + COALESCE(D.VAT_AMT , 0) , B.CURRENCY_CD FROM PS_REQ_LINE A , PS_REQ_HDR B LEFT OUTER JOIN PS_PV_REQ_VAT_VW D ON B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.REQ_ID = D.REQ_ID WHERE A.REQ_ID = B.REQ_ID AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.CURR_STATUS <> 'X' GROUP BY A.REQ_ID, A.BUSINESS_UNIT, B.REQ_NAME, B.REQ_STATUS, B.PRIORITY_FLG, B.REQ_DT, B.REQUESTOR_ID, B.CURRENCY_CD, D.VAT_AMT

# 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 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
5 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
6 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low
7 REQ_DT Date(10) DATE Requisition Date
8 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
9 REQ_TOTAL Signed Number(30,5) DECIMAL(28,5) NOT NULL Requisition Total
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code