DMND_WAVE_VW2

(SQL View)
 Index Back

Picking Wave Prompt View

Determines wave codes assigned to reserved but unpicked demand lines. Used as prompt for wave code from the Picking Plan Run Control Panel. 04/16/04 MEG CN#IN890 Data Model Changes - Replaced DEMAND_INV with IN_DEMAND. Check in_fulfill_state instead of cancel_flag.

SELECT DISTINCT A.BUSINESS_UNIT , B.WAVE_CD FROM PS_IN_DEMAND A , PS_WAVE_ROUTE_INV B , PS_BU_ITEMS_INV C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND (C.ITM_STATUS_CURRENT = '1' OR C.ITM_STATUS_CURRENT = '3') AND A.IN_FULFILL_STATE = '30' AND A.HOLD_FLAG = 'N' AND A.FULFILL_FLAG = 'Y' AND A.CONFIRMED_FLAG = 'N' AND A.PICK_BATCH_ID = 0 AND A.ROUTE_CD <> ' ' AND EXISTS ( SELECT 'X' FROM PS_WAVE_ROUTE_INV D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.WAVE_CD = D.WAVE_CD AND A.ROUTE_CD = B.ROUTE_CD AND B.ROUTE_CD = D.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.