Date Initials Issue Description 022202 dms 11697201 New view for row level security

ORD_DSTOP_OPRVW

(SQL View)

SELECT opr.oprid , ds.setid , ds.ds_network_code , ds.business_unit_in , b.inv_item_id , ds.priority_nbr , %DateTimeNull FROM PS_BU_ITEMS_INV b , ps_ds_netdet_tbl ds , ps_sec_bu_opr opr WHERE b.business_unit = ds.business_unit_in AND opr.business_unit = b.business_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
Prompt Table: SP_SETID_NONVW

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

4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Prompt Table: SP_BUIN_NONVW

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

6 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
Default Value: 1

7 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

#	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 Prompt Table: SP_SETID_NONVW
3	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
4	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BUIN_NONVW
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority Default Value: 1
7	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime