IN_DLV_DLVID_VW

(SQL View)
 Index Back

Delivry id view for deliveries


SELECT DISTINCT business_unit , delivery_id , carrier_id , ship_type_id , sched_ship_date , delivery_status FROM ps_in_delivery WHERE delivery_status IN ('20','60','70','90','99') AND bill_only = 'N' AND doc_refnum = ' ' AND (demand_source <> 'OM' OR NOT EXISTS ( SELECT 'X' FROM PS_IN_DEMAND d , ps_ord_schedule s WHERE d.business_unit = ps_in_delivery.business_unit AND d.delivery_id = ps_in_delivery.delivery_id AND d.demand_source = 'OM' AND s.business_unit = d.source_bus_unit AND s.order_no = d.order_no AND s.order_int_line_no = d.order_int_line_no AND s.sched_line_nbr = d.sched_line_nbr AND d.in_fulfill_state < '40' AND s.cust_pickup = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
4 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
5 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
6 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned