EN_REVISION_REQ

(SQL View)
 Index Back

Item/Revision Used in Reqs


SELECT a.business_unit , b.inv_item_id , c.revision , a.req_id , b.line_nbr , a.req_status , b.qty_req , d.qty_open , d.amt_open FROM PS_REQ_HDR a , ps_req_line b , ps_req_line_ship c , ps_req_ln_distrib d WHERE c.business_unit = a.business_unit AND c.business_unit = b.business_unit AND c.business_unit = d.business_unit AND c.req_id = a.req_id AND c.req_id = b.req_id AND c.req_id = d.req_id AND c.line_nbr = b.line_nbr AND c.line_nbr = d.line_nbr AND c.sched_nbr = d.sched_nbr AND a.req_status NOT IN ('X', 'C') AND b.qty_req > 0 AND (d.qty_open > 0 OR d.amt_open > 0) AND d.distrib_ln_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
4 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 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
7 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
8 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
9 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount