DMND_ROUTE_VW (SQL View)	Index Back
Picking Route Prompt View Determines route codes assigned to demand lines with an assigned pick batch id. Used as prompt for route 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_ROUTE_VW

(SQL View)

Picking Route Prompt View

Determines route codes assigned to demand lines with an assigned pick batch id. Used as prompt for route 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 , a.route_cd , b.descr FROM PS_IN_DEMAND a , ps_route_inv b WHERE a.in_fulfill_state IN ('30','40') AND a.fulfill_flag = 'Y' AND a.route_cd <> ' ' AND a.business_unit = b.business_unit AND a.route_cd = b.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 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description