PV_PERF_RCV_R0

(SQL View)
 Index Back

PO Line Ship View - Receiving

For SP2 Performance tuning: Added PV_REQ_NAME and removed CATEGORY_CD Date Initials Reference # Description 03/23/2009 SF 1822985003 Resolved the issue so that people code error is not received when requisition is closed and receiving is done second time in eprocurement receipt page.

SELECT DISTINCT DS.BUSINESS_UNIT , DS.PO_ID , DS.LINE_NBR , DS.SCHED_NBR , H.PO_DT , RS.BUSINESS_UNIT , RS.REQ_ID , R.REQUESTOR_ID , R.OPRID_ENTERED_BY , RS.LINE_NBR , RS.SCHED_NBR , RS.QTY_REQ , RS.MERCHANDISE_AMT , H.ERS_ACTION , H.VENDOR_ID , H.VENDOR_SETID , H.VNDR_LOC FROM PS_REQ_HDR R , PS_REQ_LINE_SHIP RS , PS_PO_LINE_DISTRIB DS , PS_PO_HDR H WHERE R.BUSINESS_UNIT = RS.BUSINESS_UNIT AND R.REQ_ID = RS.REQ_ID AND (R.REQ_STATUS = 'A' OR R.REQ_STATUS = 'LA' OR DS.KK_CLOSE_FLAG = 'Y') AND RS.BUSINESS_UNIT = DS.BUSINESS_UNIT_REQ AND RS.REQ_ID = DS.REQ_ID AND RS.LINE_NBR = DS.REQ_LINE_NBR AND RS.SCHED_NBR = DS.REQ_SCHED_NBR AND DS.BUSINESS_UNIT = H.BUSINESS_UNIT AND DS.PO_ID = H.PO_ID AND (H.PO_STATUS = 'D' OR (H.CHNG_ORD_BATCH > 0 AND H.PO_STATUS = 'A' ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 PO_DT Date(10) DATE Date
6 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
7 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
8 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
9 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
10 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
11 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
12 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
N=No
Y=Yes
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
17 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location