AR_WC_GPID_F_VW

(SQL View)
 Index Back

Pend Item Grp ID View


SELECT DISTINCT a.GROUP_ID FROM PS_GROUP_CONTROL a , PS_ORIGIN_TBL b WHERE a.group_type <> 'P' AND a.group_type <> 'D' AND a.group_type <> 'M' AND a.group_type <> 'T' AND a.group_type <> 'U' AND a.post_status <> 'C' AND a.origin_id=b.origin_id AND b.setid=( SELECT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue = a.business_unit AND recname = 'ORIGIN_TBL') AND b.effdt=( SELECT MAX(effdt) FROM PS_ORIGIN_TBL WHERE setid = b.setid AND origin_id = b.origin_id AND effdt <= %CurrentDateIn AND eff_status = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.