IN_REQ_DIST_AVW

(SQL View)
 Index Back

IN Pegging Requisition Search

06/29/04 EGS: Created

SELECT d.business_unit , d.req_id , d.line_nbr , d.sched_nbr , d.distrib_line_num , d.distrib_ln_status , s.due_dt , d.qty_open_std FROM ps_req_ln_distrib d , ps_req_line_ship s , ps_req_line l , PS_REQ_HDR h WHERE l.business_unit = h.business_unit AND l.req_id = h.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 = s.business_unit AND d.req_id = s.req_id AND d.line_nbr = s.line_nbr AND d.sched_nbr = s.sched_nbr AND d.business_unit_in <> ' ' AND d.profile_id = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
7 SCHED_DATE Date(10) DATE Schedule Date
8 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested