SAC_PO_UPD1_E1 (SQL View)	Index Back
Update select view

SAC_PO_UPD1_E1

(SQL View)

Update select view

SELECT A.BUSINESS_UNIT ,A.VENDOR_ID , A.PO_ID , A.PO_STATUS FROM PS_PO_HDR A WHERE A.PO_STATUS IN ('A') AND A.CHNG_ORD_BATCH = 0 AND EXISTS ( SELECT 'X' FROM PS_SAC_ERP_PO_STS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LAST_DTTM_UPDATE > B.LAST_DTTM_UPDATE AND B.SAC_INTG_PO_STS <> 'E' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
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