INRSV_DMDWAV_VW

(SQL View)
Index Back

Wave Code View

Defines the wave codes assigned to an unfullfilled demand line. Used as prompt table for wave code on the Material Reservation Panel.

SELECT DISTINCT a.business_unit , a.wave_cd , a.descr , a.descrshort FROM PS_WAVE_INV a

# 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_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description