PV_RTVCHKREQ_VW

(SQL View)

SELECT DISTINCT L.BUSINESS_UNIT , L.PO_ID , L.LINE_NBR , S.SCHED_NBR , L.RECV_REQ , DIS.BUSINESS_UNIT_REQ , DIS.REQ_ID FROM PS_PO_HDR H , PS_PO_LINE L , PS_PO_LINE_SHIP S , PS_PO_LINE_DISTRIB DIS WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.PO_ID = L.PO_ID AND L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR AND S.BUSINESS_UNIT = DIS.BUSINESS_UNIT AND S.PO_ID = DIS.PO_ID AND S.LINE_NBR = DIS.LINE_NBR AND S.SCHED_NBR = DIS.SCHED_NBR AND ((H.PO_STATUS IN ('D','C')) OR (H.CHNG_ORD_BATCH > 0 AND H.PO_STATUS IN( 'O','A','PA') )) AND L.CANCEL_STATUS = 'A' AND S.CANCEL_STATUS = 'A' AND S.SHIP_TO_CUST_ID = ' ' AND (( (H.RECV_STATUS = 'R' OR H.RECV_STATUS = 'P') AND L.RECV_REQ = 'Y') OR L.RECV_REQ <> 'Y')

# 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 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required

6 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

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

#	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	RECV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Receiving Required N=Optional X=Do Not Y=Required
6	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
7	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID