SHIP_WAVE_VW

(SQL View)
 Index Back

Ship Prpt9 - Wave/Add mode

Determines the wave codes assigned to a pick confirmed order line. Used as a prompt table for wave code on the Shipping/Issues Selection Criteria - Add Mode.

SELECT DISTINCT a.business_unit , b.wave_cd FROM PS_IN_DEMAND a , ps_wave_route_inv b WHERE a.IN_FULFILL_STATE BETWEEN '50' AND '70' AND EXISTS ( SELECT 'X' FROM ps_wave_route_inv c WHERE a.business_unit = b.business_unit AND b.business_unit = c.business_unit AND b.wave_cd = c.wave_cd AND a.route_cd = b.route_cd AND b.route_cd = c.route_cd)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.