SHIP_CNFMR_VW (SQL View)	Index Back
Picked,confirmed, route cd This record is used as a prompt view on Route Code for the freight calculation run control panel. 04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

SHIP_CNFMR_VW

(SQL View)

Picked,confirmed, route cd

This record is used as a prompt view on Route Code for the freight calculation run control panel. 04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

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 IN ('50','60','70') 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