OM_COPY_ORD_VW

(SQL View)
 Index Back

Order Completion Vw

111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT oh.business_unit , oh.order_no FROM PS_ORD_HEADER oh , PS_ORD_HEADER_lock k WHERE oh.order_status IN ('C','O','P') AND %Join(COMMON_KEYS, ord_header oh, ord_header_lock k) AND k.background_reqd = 'N' AND k.in_process_flg = 'N' AND (oh.order_type_cd = 'SO' OR (oh.order_type_cd = 'QUO' AND NOT EXISTS ( SELECT 'X' FROM ps_ord_hold h WHERE h.order_no = oh.order_no AND h.business_unit = oh.business_unit AND h.eff_status = 'A')))

# 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