ORDENT_HDSHP_VW

(SQL View)
 Index Back

ordent ship view

ordent ship view Date Initials Issue Description 053102 dms IR68536004 Change SQL to not join ship_from_bu

SELECT s.business_unit , s.order_no , 'Y' FROM ps_in_demand sh , ps_ord_schedule s , PS_MASTER_ITEM_TBL m , ps_set_cntrl_rec c WHERE sh.source_bus_unit = s.business_unit AND sh.order_no = s.order_no AND sh.order_int_line_no = s.order_int_line_no AND sh.sched_line_nbr = s.sched_line_nbr AND sh.demand_source = 'OM' AND (sh.in_fulfill_state IN ('60', '70') OR s.cs_status IN ('S')) AND s.drop_ship_flag = 'N' AND c.setcntrlvalue = s.business_unit AND c.recname = 'MASTER_ITEM_TBL' AND m.setid = c.setid AND m.inv_item_id = sh.inv_item_id AND m.inventory_item = 'Y'

# 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 SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Shipped
B=Both
N=No
Y=Yes