OMD_SRC_PR_VW

(SQL View)
 Index Back

OMDEMAND Prompt Table

Date Init. Issue # Description 061502 JJM F-CJORGENS-47 React to Retirement of Tools Features 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT DISTINCT OH.BUSINESS_UNIT , OH.SOURCE_CD FROM PS_ORD_HEADER OH , PS_ORD_HEADER_LOCK K WHERE %Join(COMMON_KEYS, ORD_HEADER OH, ORD_HEADER_LOCK K) AND K.BACKGROUND_REQD = 'N' AND K.HOLD_REQD = 'N' AND K.CREDIT_REQD = 'N' AND OH.ORDER_TYPE_CD = 'SO' AND OH.ORDER_STATUS <> 'X' AND OH.ORDER_STATUS <> 'C' AND K.PROCESS_INSTANCE = 0 AND EXISTS ( SELECT 'X' FROM PS_ORD_SCHEDULE OS WHERE OS.BUSINESS_UNIT = OH.BUSINESS_UNIT AND OS.ORDER_NO = OH.ORDER_NO AND OS.DEMAND_SENT = 'N' AND OS.DROP_SHIP_FLAG = 'N' AND OS.ORD_SCH_STATUS = 'O')

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