PV_GHP_PSTS_VW3(SQL View) |
Index Back |
---|---|
eProcurement analysisStatus : 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 |