WAVE_INV_VW3 (SQL View)	Index Back
Wave Code View Defines the wave codes assigned to an unfullfilled demand line. Used as prompt table for wave code on the Material Reservation Panel.

WAVE_INV_VW3

(SQL View)

Wave Code View

Defines the wave codes assigned to an unfullfilled demand line. Used as prompt table for wave code on the Material Reservation Panel.

SELECT DISTINCT a.business_unit , b.wave_cd FROM PS_IN_DEMAND a , ps_wave_route_inv b WHERE 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) AND a.in_fulfill_State='20'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.