OMBCK_SCDCMP_VW

(SQL View)
 Index Back

Order Completion Vw

111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT DISTINCT h.business_unit , h.source_cd 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' AND h.source_cd <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code