EM_HOLD_PAY_VW (SQL View)	Index Back
Voucher Inquiry Retreiving Vie This view is used by the Market Pay Module to retrieve all of the PYMNT_VCHR_XREF rows that have a payment made on them. It, in turn, is used on the Vouchers Inquiries panel group to determine if the payment information button should appear. The view and processing logic for it can be removed if scheduled payments are used in the module - the logic will then have to direct the user to the ..... rather than the payment information panel.

EM_HOLD_PAY_VW

(SQL View)

Voucher Inquiry Retreiving Vie

This view is used by the Market Pay Module to retrieve all of the PYMNT_VCHR_XREF rows that have a payment made on them. It, in turn, is used on the Vouchers Inquiries panel group to determine if the payment information button should appear. The view and processing logic for it can be removed if scheduled payments are used in the module - the logic will then have to direct the user to the ..... rather than the payment information panel.

SELECT DISTINCT a.business_unit , c.oprid , a.voucher_id FROM PS_VOUCHER a , ps_vendor b , ps_sec_bu_opr c , ps_pymnt_vchr_xref d WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.business_unit = c.business_unit AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND d.pymnt_hold = 'Y' AND a.entry_status <> 'X' AND d.pymnt_selct_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AP_NONVW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AP_NONVW
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID