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

ORD_DSTOP_NONVW

(SQL View)

SELECT 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 WHERE b.business_unit = ds.business_unit_in

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

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

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

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

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

6 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
3	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BUIN_NONVW
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority Default Value: 1
6	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime