IN_ITMEXPRUL_VW

(SQL View)
 Index Back

Item Exception Rules View


SELECT DISTINCT a.setid , a.pv_ruleid , b.descr FROM PS_PV_WF_SETID_ASG a , ps_pv_wf_rule b , ps_pv_wf_crta_val c WHERE a.pv_ruleid = b.pv_ruleid AND c.recname = 'ITEMLOAD_ERR' AND c.pv_appr_fld = 'MESSAGE_SET_NBR' AND c.rte_from_value = c.rte_to_value AND c.rte_from_value = '15225' AND EXISTS( SELECT 'x' FROM ps_pv_wf_crta_val d WHERE d.pv_ruleid = c.pv_ruleid AND d.recname = 'ITEMLOAD_ERR' AND d.pv_appr_fld = 'MESSAGE_NBR' AND d.rte_from_value = d.rte_to_value AND d.rte_from_value IN ('3','4','5','6'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 PV_RULEID Character(12) VARCHAR2(12) NOT NULL Rule Id
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description