SRM_POC2APR_VW (SQL View)	Index Back
PO Changes to Approve Purchase Order Change Requests that are to be approved.

SRM_POC2APR_VW

(SQL View)

PO Changes to Approve

Purchase Order Change Requests that are to be approved.

SELECT B.BUYER_ID , A.BUSINESS_UNIT , A.PO_ID , A.CHNG_SOURCE , A.CHNG_DTTM , V.NAME1 , C.OPRDEFNDESC , B.PO_DT , B.PO_STATUS , B.RECV_STATUS , B.VENDOR_ID , B.VNDR_LOC , 'C' FROM PS_CHNG_RQST A , PS_PO_HDR B , PS_PO_BUYER_VW C , PS_VENDOR V WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.APPROVED_FLG = 'N' AND B.BUYER_ID = C.BUYER_ID AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

4 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

5 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

7 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

8 PO_DT Date(10) DATE NOT NULL Date
Default Value: %date

9 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

10 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

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

12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

13 APPROVE_PB Character(1) VARCHAR2(1) NOT NULL Approve

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
5	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
7	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
8	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
9	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
10	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
12	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
13	APPROVE_PB	Character(1)	VARCHAR2(1) NOT NULL	Approve