PV_GHP_PSTS_VW3

(SQL View)
Index Back

eProcurement analysis

Status : Number of POs

SELECT BUSINESS_UNIT , BUYER_ID , PO_STATUS , COUNT(*) FROM PS_PO_HDR GROUP BY BUSINESS_UNIT , 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: %EDIT_BUYER

3 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

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