SP_DS_BU_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. Date Initials Issue Description 022202 dms 11697201 New view for row level security

SELECT opr.oprid , 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 , ps_sec_bu_opr opr 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 opr.business_unit = d.business_unit_in AND %EffdtCheck(CUST_SHIPTO_OPT, C, %CurrentDateIn) AND c.EFF_STATUS = 'A'

# 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 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
5 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
6 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority