ORDENT_SCH_VW

(SQL View)
 Index Back

Order entry est shipment sched

Order entry estimated shipment schedules display. No peoplecode, no prompts, no defaults!

SELECT DISTINCT s.business_unit , s.order_no , s.order_int_line_no , s.sched_line_nbr , d.business_unit , d.delivery_id , l.prod_id_entered , s.sched_ship_dttm , s.ship_to_cust_id FROM ps_ord_line l , ps_ord_schedule s , PS_IN_DEMAND d WHERE %Join(common_keys, ord_line l, ord_schedule s) AND d.business_unit = s.ship_from_bu AND d.demand_source = 'OM' AND d.source_bus_unit = s.business_unit AND d.order_no = s.order_no AND d.order_int_line_no = s.order_int_line_no AND d.sched_line_nbr = s.sched_line_nbr AND d.in_fulfill_state < '90'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
7 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
8 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer