ROUTE_INV_VW5 (SQL View)	Index Back
Route Code View Defines the route codes that have been assigned to unfulfilled demand lines. Used as prompt table for route code on the Material Reservation Panel. 08/11/04 PWF F-KNANN-V59N4 Change demand table from DEMAND_INF_INV to IN_DEMAND

ROUTE_INV_VW5

(SQL View)

Route Code View

Defines the route codes that have been assigned to unfulfilled demand lines. Used as prompt table for route code on the Material Reservation Panel. 08/11/04 PWF F-KNANN-V59N4 Change demand table from DEMAND_INF_INV to IN_DEMAND

SELECT DISTINCT a.business_unit , a.route_cd , b.descr FROM PS_IN_DEMAND a , ps_route_inv b WHERE a.route_cd <> ' ' AND a.business_unit = b.business_unit AND a.route_cd = b.route_cd AND a.in_fulfill_state IN ('20')

# 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