PV_GHP_PSTS_VW5 (SQL View)	Index Back
eProcurement analysis Status : Number of POs

PV_GHP_PSTS_VW5

(SQL View)

eProcurement analysis

Status : Number of POs

SELECT BUSINESS_UNIT , VENDOR_ID , BUYER_ID , PO_STATUS , COUNT(*) FROM PS_PO_HDR GROUP BY BUSINESS_UNIT , VENDOR_ID , BUYER_ID , PO_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_PO_VW

3 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: %EDIT_BUYER

4 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
Default Value: I

5 NUM_RECORDS Number(15,0) DECIMAL(15) NOT NULL Number of Records

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PO_VW
3	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
4	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled Default Value: I
5	NUM_RECORDS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Records