ORDENT_DSBU_VW (SQL View)	Index Back
Ship From IBU Hierarchy This child table to the DS_NETHDR_TBL stores the warehouses (Inventory Business Units - IBU) in the order of priority. Material would be supplied from the first IBU in this list, and if not available, the processing would take the next IBU into consideration.

ORDENT_DSBU_VW

(SQL View)

Ship From IBU Hierarchy

This child table to the DS_NETHDR_TBL stores the warehouses (Inventory Business Units - IBU) in the order of priority. Material would be supplied from the first IBU in this list, and if not available, the processing would take the next IBU into consideration.

SELECT c.setid , c.cust_id , d.business_unit_in , c.ds_network_code , d.priority_nbr FROM ps_set_cntrl_rec sc , ps_ds_netdet_tbl d , PS_BUS_UNIT_TBL_IN a , ps_bus_unit_tbl_fs b , ps_cust_shipto_opt c WHERE sc.recname = 'DS_NETHDR_TBL' AND sc.setcntrlvalue = c.setid AND d.setid = sc.setid AND d.ds_network_code = c.ds_network_code AND a.business_unit = b.business_unit AND a.bu_status = '1' AND d.business_unit_in = a.business_unit AND %EffdtCheck(CUST_SHIPTO_OPT, C, %CurrentDateIn) AND c.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

3 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

4 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

5 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
3	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
4	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
5	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority