VCHR_AF_ASST_VW

(SQL View)
 Index Back

Voucher Approval Search

Voucher Approval Search Record

SELECT a.business_unit , a.voucher_id , 'Y' FROM PS_VOUCHER a WHERE a.appr_status <> 'A' AND a.voucher_style <> 'TMPL' AND a.vchr_apprvl_flg = 'W' AND a.close_status <> 'C' AND a.process_man_close <> 'Y' AND EXISTS ( SELECT 'x' FROM ps_distrib_line b WHERE b.business_unit = a.business_unit AND b.voucher_id = a.voucher_id AND b.asset_flg = 'Y') UNION SELECT c.business_unit , c.voucher_id , 'N' FROM PS_VOUCHER c WHERE c.appr_status <> 'A' AND c.voucher_style <> 'TMPL' AND c.vchr_apprvl_flg = 'W' AND c.close_status <> 'C' AND c.process_man_close <> 'Y' AND NOT EXISTS ( SELECT 'x' FROM ps_distrib_line d WHERE c.business_unit = d.business_unit AND c.voucher_id = d.voucher_id AND d.asset_flg = 'Y')

# 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_AP_NONVW

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

Default Value: NEXT

3 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable