PV_CP_SUMM_VW

(SQL View)

SELECT %Substring(A.PV_CP_TP_NAME,1,50) , A.PROCESS_INSTANCE , A.VENDOR_SETID , A.VENDOR_ID , A.PV_MS_SUP_MPID , COUNT(*) FROM PS_PV_CP_LOAD A GROUP BY A.PV_CP_TP_NAME , A.PROCESS_INSTANCE , A.VENDOR_SETID , A.VENDOR_ID , A.PV_MS_SUP_MPID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PV_MS_TP_NAME Character(50) VARCHAR2(50) NOT NULL Marketplace TP Name

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

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

5 PV_MS_SUP_MPID Character(50) VARCHAR2(50) NOT NULL e

6 PV_CP_ITEM_COUNT Number(6,0) INTEGER NOT NULL CUP Item Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PV_MS_TP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Marketplace TP Name
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
6	PV_CP_ITEM_COUNT	Number(6,0)	INTEGER NOT NULL	CUP Item Count