SHIP_WAVE_VW3 (SQL View)	Index Back
Picked,confirmed, wave cd 04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

SHIP_WAVE_VW3

(SQL View)

Picked,confirmed, wave cd

04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

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 IN ('50','60','70') 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.