PO_DEMAND_VW1 (SQL View)	Index Back
Distinct networks and items Used by REQINVS. Selects all items and networks being processed

PO_DEMAND_VW1

(SQL View)

Distinct networks and items

Used by REQINVS. Selects all items and networks being processed

select distinct process_instance, inv_item_id, ds_net_setid, ds_network_code from PS_PO_DEMAND_WRK1 where check_inv_qty_flg = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MST_ITM_PRPT_VW

3 DS_NET_SETID Character(5) VARCHAR2(5) NOT NULL Distribution Network SetID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MST_ITM_PRPT_VW
3	DS_NET_SETID	Character(5)	VARCHAR2(5) NOT NULL	Distribution Network SetID
4	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code