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

ORD_DSNET_OPRVW

(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 opr.oprid , n.setid , n.ds_network_code , n.priority_nbr , n.business_unit_in FROM ps_ds_netdet_tbl n , PS_SEC_BU_OPR opr WHERE opr.business_unit = n.business_unit_in

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
4	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
5	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit