INRSV_DMDRT_VW

(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.

SELECT DISTINCT a.business_unit , a.route_cd , a.descr FROM PS_ROUTE_INV a WHERE a.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 SL_ROUTE_CD Character(6) VARCHAR2(6) NOT NULL Route selection
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description