EM_VLN_BU_VW

(SQL View)
 Index Back

Invoice Line Approval

AF - Invoice Line Approval: Used to filter Business Unit that have Line Level Approvals turned on.

SELECT a.BUSINESS_UNIT ,a.VOUCHER_ID ,LINE.VOUCHER_LINE_NUM ,DIST.DISTRIB_LINE_NUM ,'Y' FROM PS_VOUCHER a , PS_VOUCHER_LINE LINE , PS_DISTRIB_LINE DIST WHERE a.BUSINESS_UNIT = LINE.BUSINESS_UNIT AND LINE.BUSINESS_UNIT = DIST.BUSINESS_UNIT AND a.VOUCHER_ID = LINE.VOUCHER_ID AND LINE.VOUCHER_ID = DIST.VOUCHER_ID AND LINE.VOUCHER_LINE_NUM = DIST.VOUCHER_LINE_NUM AND a.BUSINESS_UNIT IN ( SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_AP BUAP WHERE BUAP.BUSINESS_UNIT = a.BUSINESS_UNIT AND BUAP.PROCESS_LINES_FLAG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 PROCESS_LINES_FLAG Character(1) VARCHAR2(1) NOT NULL Process order lines online