DMND_WAVE_VW (SQL View)	Index Back
Picking Wave Prompt View Determines wave codes assigned to demand lines with an assigned pick batch id. Used as prompt for wave code from the Material Picking Feedback Panel. 04/27/04 MEG CN#IN890 Data Model Changes - Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

DMND_WAVE_VW

(SQL View)

Picking Wave Prompt View

Determines wave codes assigned to demand lines with an assigned pick batch id. Used as prompt for wave code from the Material Picking Feedback Panel. 04/27/04 MEG CN#IN890 Data Model Changes - Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

SELECT DISTINCT a.business_unit , b.wave_cd FROM PS_IN_DEMAND a , ps_wave_route_inv b WHERE a.in_fulfill_state IN ('30','40') AND a.fulfill_flag = 'Y' AND a.route_cd <> ' ' 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
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.