AUC_REQ_HDR_VW

(SQL View)
 Index Back

Eligible REQ Template for Auc


SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID , A.REQ_STATUS , A.HOLD_STATUS , A.REQ_DT , A.REQUESTOR_ID FROM PS_REQ_HDR A , PS_REQ_LINE B , PS_REQ_LINE_SHIP C , PS_AUC_REQ_DST_SUM D WHERE A.IN_PROCESS_FLG = 'N' AND A.HOLD_STATUS = 'N' AND A.BUDGET_HDR_STATUS = 'V' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.REQ_ID = A.REQ_ID AND B.SOURCE_STATUS = 'A' AND B.CURR_STATUS = 'A' AND B.IN_PROCESS_FLG = 'N' AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.REQ_ID = B.REQ_ID AND C.LINE_NBR = B.LINE_NBR AND C.BAL_STATUS = 'I' AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.REQ_ID = C.REQ_ID AND D.LINE_NBR = C.LINE_NBR AND D.SCHED_NBR = C.SCHED_NBR AND B.PRICE_REQ >= 0 AND (D.QTY_OPEN > 0 OR D.AMT_OPEN > 0)

# 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
3 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
4 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

Y/N Table Edit

5 REQ_DT Date(10) DATE NOT NULL Requisition Date
6 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id