REQ_ID_ACTG_VW1

(SQL View)
Index Back

Requistion Acctg Ln BU prompt


SELECT DISTINCT B.BUSINESS_UNIT , B.REQ_ID , H.REQ_STATUS , H.ORIGIN , H.REQUESTOR_ID FROM PS_KK_SOURCE_HDR B , PS_REQ_HDR H , PS_KK_ACTIVITY_LOG A WHERE B.BUSINESS_UNIT = H.BUSINESS_UNIT AND B.REQ_ID = H.REQ_ID AND B.KK_TRAN_ID = A.KK_TRAN_ID AND B.KK_TRAN_DT = A.KK_TRAN_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 FROM_REQ Character(10) VARCHAR2(10) NOT NULL From Req
3 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
4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
5 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id