PV_REQ_DELV_VW

(SQL View)
 Index Back

Requisition Delivery View


SELECT DISTINCT RH.BUSINESS_UNIT , RH.REQ_ID , H.BUSINESS_UNIT , H.RECEIVER_ID , H.RECV_SOURCE , H.RECEIPT_DT FROM PS_RECV_HDR H , PS_RECV_LN_SHIP RS , PS_PV_RECV_PO_VW RP , PS_REQ_HDR RH WHERE RH.BUSINESS_UNIT = RP.BUSINESS_UNIT_REQ AND RH.REQ_ID = RP.REQ_ID AND RH.BUSINESS_UNIT = RP.BUSINESS_UNIT_PO AND RP.BUSINESS_UNIT_PO = RS.BUSINESS_UNIT_PO AND RP.PO_ID = RS.PO_ID AND RP.BUSINESS_UNIT_RECV = RS.BUSINESS_UNIT AND RP.RECEIVER_ID = RS.RECEIVER_ID AND RS.BUSINESS_UNIT_PO = RP.BUSINESS_UNIT_PO AND RS.PO_ID = RP.PO_ID AND RS.LINE_NBR = RP.LINE_NBR AND RS.SCHED_NBR = RP.SCHED_NBR AND RS.BUSINESS_UNIT = RP.BUSINESS_UNIT_RECV AND RS.RECEIVER_ID = RP.RECEIVER_ID AND RS.BUSINESS_UNIT = H.BUSINESS_UNIT AND RS.RECEIVER_ID = H.RECEIVER_ID AND H.RECV_STATUS <> 'X' AND EXISTS ( SELECT 'X' FROM PS_RECV_LN_SHIP S , PS_RECV_LN_DISTRIB D WHERE S.BUSINESS_UNIT = D.BUSINESS_UNIT AND S.BUSINESS_UNIT = H.BUSINESS_UNIT AND D.BUSINESS_UNIT = H.BUSINESS_UNIT AND S.RECEIVER_ID = H.RECEIVER_ID AND D.RECEIVER_ID = H.RECEIVER_ID AND S.RECEIVER_ID = D.RECEIVER_ID AND S.RECV_LN_NBR = D.RECV_LN_NBR AND S.RECV_SHIP_SEQ_NBR = D.RECV_SHIP_SEQ_NBR AND D.DELIVERED_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
4 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
5 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
1=On-line
2=ASN
3=Data Cllct
4=Mobile
6 RECEIPT_DT Date(10) DATE Received Date