FO_VT_CUR_VW (SQL View)	Index Back
Current Supplier-Transactions Shows the supplier transactions associated with the current version of the supplier

FO_VT_CUR_VW

(SQL View)

Current Supplier-Transactions

Shows the supplier transactions associated with the current version of the supplier

SELECT A.FO_VNDR_TRANS_ID , A.FO_OI_VENDOR_ID , A.FO_OI_VERSION , A.FO_TRANSACT_ID , A.MSGNODENAME FROM PS_FO_VNDR_TRANS A , PS_FO_VENDOR B WHERE A.FO_OI_VERSION IN ( SELECT MAX(C.FO_OI_VERSION) FROM PS_FO_VENDOR C WHERE C.FO_OI_VENDOR_ID=A.FO_OI_VENDOR_ID) AND A.FO_OI_VENDOR_ID=B.FO_OI_VENDOR_ID AND A.FO_OI_VERSION=B.FO_OI_VERSION AND B.FO_OI_VENDOR_STS='10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FO_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction

2 FO_OI_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID

3 FO_OI_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects

4 FO_TRANSACT_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID

5 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FO_VNDR_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Id specific to a Vendor and Transaction
2	FO_OI_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Vendor ID
3	FO_OI_VERSION	Number(15,0)	DECIMAL(15) NOT NULL	used as version for numerous integration objects
4	FO_TRANSACT_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction ID
5	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).