DEMAND_CNFMR_VW (SQL View)	Index Back
Picking Pick_Batch Prompt View This record is used as a prompt view on Route Code for the Picking Confirmation run control panel. 05/07/04 MEG CN#IN890: Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

DEMAND_CNFMR_VW

(SQL View)

Picking Pick_Batch Prompt View

This record is used as a prompt view on Route Code for the Picking Confirmation run control panel. 05/07/04 MEG CN#IN890: 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.pick_batch_id > 0 AND a.in_fulfill_state = '40' AND a.fulfill_flag = 'Y' AND a.confirmed_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