PV_PO_RECV_VW

(SQL View)
 Index Back

receiving status

Replaced PV_RECV_REQ_VW by this view

SELECT A.BUSINESS_UNIT , D.REQ_ID , MIN(A.PO_ID) , MIN(B.LINE_NBR) , MIN(C.REQ_LINE_NBR ) , MIN(A.PO_STATUS) , MIN(A.RECV_STATUS) , MIN(D.REQUESTOR_ID) , MIN(D.REQ_STATUS) FROM PS_PO_HDR A , PS_PO_LINE B , PS_PO_LINE_DISTRIB C , PS_REQ_HDR D WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND B.BUSINESS_UNIT=C.BUSINESS_UNIT AND B.PO_ID=C.PO_ID AND B.LINE_NBR=C.LINE_NBR AND D.REQ_ID=C.REQ_ID AND D.BUSINESS_UNIT=C.BUSINESS_UNIT AND ( A.PO_STATUS = 'D' OR (A.PO_STATUS = 'A' AND A.CHNG_ORD_BATCH > 0)) AND B.CANCEL_STATUS <> 'X' GROUP BY D.REQ_ID , A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

Default Value: NEXT

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
6 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

Default Value: I

7 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

Default Value: N

8 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Default Value: OPR_DEF_TBL_PM.REQUESTOR_ID

Prompt Table: %EDITTABLE16

9 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

Default Value: REQUESTOR_TBL.REQ_STATUS