RQSTR_RCTORD_VW

(SQL View)
 Index Back

Requester Recently Ordered


SELECT REQUESTOR_ID , ITM_SETID , INV_ITEM_ID , DESCR254_MIXED , CATEGORY_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , LN_TYPE , MFG_ID , ITM_ID_VNDR , MFG_ITM_ID , UNIT_OF_MEASURE , PRICE_REQ , CURRENCY_CD , BUSINESS_UNIT , REQ_ID , LINE_NBR , SERVICE_METHOD , ROLE_TYPE , PROJ_ROLE , ENTERED_DT , UPN_TYPE_CD , UPN_ID FROM ( SELECT H.REQUESTOR_ID , L.ITM_SETID , L.INV_ITEM_ID , L.DESCR254_MIXED , L.CATEGORY_ID , L.VENDOR_SETID , L.VENDOR_ID , L.VNDR_LOC , L.LN_TYPE , L.MFG_ID , L.ITM_ID_VNDR , L.MFG_ITM_ID , L.UNIT_OF_MEASURE , L.PRICE_REQ , L.CURRENCY_CD , L.BUSINESS_UNIT , L.REQ_ID , L.LINE_NBR , S.SERVICE_METHOD , S.ROLE_TYPE , S.PROJ_ROLE , H.ENTERED_DT , L.UPN_TYPE_CD , L.UPN_ID , ROW_NUMBER () over (partition BY H.REQUESTOR_ID , L.INV_ITEM_ID , L.DESCR254_MIXED ORDER BY H.LAST_DTTM_UPDATE DESC) AS "LNUM" FROM PS_REQ_HDR H , PS_REQ_LINE L LEFT OUTER JOIN PS_SP_PV_REQLN_VW S ON L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.REQ_ID = S.REQ_ID AND L.LINE_NBR = S.LINE_NBR WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.REQ_ID = L.REQ_ID AND L.CURR_STATUS = 'A') R WHERE LNUM = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
2 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
5 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
9 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
10 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
11 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
12 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
17 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
18 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
19 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
20 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
21 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
22 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
24 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number