DMND_WAVE_VW3 (SQL View)	Index Back
Picking Conf. Wave Prompt View Determines wave codes assigned to reserved but unpicked demand lines. Used as prompt for wave code from the Picking Confirmation Run Control Panel. 05/07/04 MEG CN#IN890: Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

DMND_WAVE_VW3

(SQL View)

Picking Conf. Wave Prompt View

Determines wave codes assigned to reserved but unpicked demand lines. Used as prompt for wave code from the Picking Confirmation Run Control Panel. 05/07/04 MEG CN#IN890: 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.pick_batch_id > 0 AND a.in_fulfill_state = '40' AND a.hold_flag = 'N' AND a.fulfill_flag = 'Y' AND a.confirmed_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.