OMBCK_CSTCMP_VW

(SQL View)
 Index Back

Order Completion Vw

111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT DISTINCT h.business_unit , h.sold_to_cust_id FROM PS_ORD_HEADER h , PS_ORD_HEADER_lock k WHERE h.order_status NOT IN ('C','X') AND %Join(COMMON_KEYS, ord_header h, ord_header_lock k) AND k.background_reqd <> 'N' AND k.in_process_flg = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer