SP_PRDN3_CLSVW

(SQL View)
 Index Back

CP Production View 3

Request for Change Prdn S/O

SELECT DISTINCT a.business_unit , e.oprclass , a.order_no FROM ps_cp_opt_hdr a , PS_ORD_SCHEDULE b , ps_ord_line c , ps_bus_unit_tbl_fs d , ps_sec_bu_cls e WHERE ((a.mfg_process_flg IN ('B','E') AND a.production_id <> ' ') OR a.mfg_process_flg = 'C') AND a.business_unit = b.business_unit AND b.business_unit = c.business_unit AND c.business_unit = d.business_unit AND d.business_unit = e.business_unit AND a.order_no = b.order_no AND a.order_no = c.order_no AND b.order_no = c.order_no AND a.order_int_line_no = b.order_int_line_no AND a.order_int_line_no = c.order_int_line_no AND b.order_int_line_no = c.order_int_line_no AND b.demand_sent = 'Y' AND a.cp_mode = 'S' AND c.ord_line_status = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
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