SRM_DB_RTBS_VW

(SQL View)
 Index Back

Reqs to be sourced pagelet


SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID , D.BUYER_ID , E.OPRDEFNDESC , C.APPROVAL_DT , ' ' FROM PS_REQ_LINE_SHIP A , PS_REQ_LN_DISTRIB B , PS_REQ_HDR C , PS_REQ_LINE D , PS_PO_OPRDEFN_VW E , PS_SRM_DB_BU_VW F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_NBR = B.SCHED_NBR AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.REQ_ID = D.REQ_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.REQ_ID = A.REQ_ID AND A.LINE_NBR = D.LINE_NBR AND D.BUYER_ID = E.OPRID AND F.BUYER_ID = D.BUYER_ID AND F.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.BAL_STATUS = 'I' AND C.HOLD_STATUS = 'N' AND C.BUDGET_HDR_STATUS = 'V' AND A.BAL_STATUS = 'I' AND B.KK_CLOSE_FLAG <> 'Y' AND C.IN_PROCESS_FLG = 'N' AND D.CURR_STATUS = 'A' AND D.RFQ_IND = 'N' AND D.IN_PROCESS_FLG = 'N' AND D.SOURCE_STATUS = 'A' GROUP BY A.BUSINESS_UNIT, A.REQ_ID, A.LINE_NBR, A.SCHED_NBR, A.DUE_DT, A.DUE_TIME, A.SHIPTO_SETID, A.SHIPTO_ID, A.QTY_REQ, A.MERCHANDISE_AMT, A.DISTRIB_MTHD_FLG, A.PRICE_REQ, A.BAL_STATUS, A.QTY_REQ_STD, A.UNIT_MEASURE_STD, A.CURRENCY_CD, A.REVISION, A.BUSINESS_UNIT_OM, D.BUYER_ID , E.OPRDEFNDESC, C.APPROVAL_DT HAVING (SUM(B.QTY_OPEN) > 0 OR SUM(B.AMT_OPEN) > 0)

# 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

Default Value: NEXT

3 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
4 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
5 APPROVAL_DT Date(10) DATE Date of Approval
6 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name