ORD_SUP_PR_VW

(SQL View)
 Index Back

Order Supply Purch Req View


select d.business_unit_in, 'PR', d.req_id, l.inv_item_id, s.due_dt, 'S', l.vendor_id, l.vendor_setid, l.unit_of_measure, d.qty_open from PS_REQ_HDR h, ps_req_line l, ps_req_line_ship s, ps_req_ln_distrib d where d.business_unit_in <> ' ' and s.business_unit = l.business_unit and d.business_unit = l.business_unit and h.business_unit = l.business_unit and s.req_id = l.req_id and d.req_id = l.req_id and h.req_id = l.req_id and s.line_nbr = l.line_nbr and d.line_nbr = l.line_nbr and d.sched_nbr = s.sched_nbr and (h.req_status = 'O' or h.req_status = 'A' or h.req_status = 'P') and d.distrib_ln_status = 'O' and d.qty_open > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 SCHED_DATE Date(10) DATE Schedule Date
6 AVAIL_TYPE Character(1) VARCHAR2(1) NOT NULL Availability Type
D=Demand
S=Supply
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested