GRP_APAM_VW

(SQL View)
 Index Back

Control Groups - APAM

Control Groups Eligible for AP/AM Interface.

SELECT A.BUSINESS_UNIT , A.GRP_AP_ID , A.ASSIGNED_TO_OPRID FROM PS_GRP_AP A WHERE EXISTS ( SELECT 'X' FROM PS_VOUCHER B , PS_VCHR_ACCTG_LINE C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.GRP_AP_ID = A.GRP_AP_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND ((B.MATCH_ACTION='N') OR (B.MATCH_ACTION='Y' AND B.MATCH_STATUS_VCHR IN ('M','O')) OR (B.MATCH_ACTION = 'Y' AND B.MATCH_STATUS_VCHR = 'T' AND B.CLOSE_STATUS = 'C')) AND C.ASSET_FLG = 'Y' AND C.AM_DISTRIB_STATUS IN ('M', 'N'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
3 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned to