SRM_REQ2SRC_VW

(SQL View)
 Index Back

Approved Req Not Sourced

Requisitions that are approved and not sourced.

SELECT DISTINCT L.BUYER_ID , L.VENDOR_SETID , L.VENDOR_ID , H.BUSINESS_UNIT , H.REQ_ID , L.LINE_NBR , S.SCHED_NBR , H.APPROVAL_DT FROM PS_REQ_HDR H , PS_REQ_LINE L , PS_REQ_LINE_SHIP S , PS_REQ_LN_DISTRIB D WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.REQ_ID = L.REQ_ID AND S.BUSINESS_UNIT = L.BUSINESS_UNIT AND S.REQ_ID = L.REQ_ID AND S.LINE_NBR=L.LINE_NBR AND D.BUSINESS_UNIT = L.BUSINESS_UNIT AND D.REQ_ID = L.REQ_ID AND D.LINE_NBR=L.LINE_NBR AND D.SCHED_NBR=S.SCHED_NBR AND H.IN_PROCESS_FLG = 'N' AND H.HOLD_STATUS = 'N' AND H.BUDGET_HDR_STATUS = 'V' AND L.CURR_STATUS='A' AND L.SOURCE_STATUS='A' AND L.RFQ_IND = 'N' AND L.IN_PROCESS_FLG = 'N' AND L.SOURCE_STATUS = 'A' AND L.SOURCE_DATE <= %CurrentDateIn AND S.BAL_STATUS = 'I' AND D.KK_CLOSE_FLAG <> 'Y' AND (D.QTY_OPEN > 0 OR D.AMT_OPEN > 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 APPROVAL_DT Date(10) DATE Date of Approval