RB_MLPB_RULE_VW

(SQL View)
 Index Back

Multilevel Rules

Union of different rule types from various MLPB rule tables for use in other views.

SELECT FAS.SETID , FAS.RULE_ID , FAS.PRODUCT_ID FROM PS_RB_RULE_FAS_TBL FAS UNION SELECT PRG.SETID , PRG.RULE_ID , PRG.PRODUCT_ID FROM PS_RB_RULE_PRG_TBL PRG UNION SELECT ARR.SETID , ARR.RULE_ID , ARR.PRODUCT_ID FROM PS_RB_ATTR_ARR_TBL ARR UNION SELECT RARR.SETID , RARR.RULE_ID , RARR.PRODUCT_ID FROM PS_RB_RULE_ARR_TBL RARR UNION SELECT ERA.SETID , ERA.RULE_ID , ERA.PRODUCT_ID FROM PS_RB_RULE_ERA_TBL ERA UNION SELECT LNK.SETID , LNK.RULE_ID , LNK.SOURCE_PRODUCT_ID FROM PS_RB_RL_LINK_ACT LNK UNION SELECT LNK2.SETID , LNK2.RULE_ID , LNK2.TARGET_PRODUCT_ID FROM PS_RB_RL_LINK_ACT LNK2 UNION SELECT CMTCVR.SETID , CMTCVR.RULE_ID , CMTCVR.PRODUCT_ID FROM PS_RB_RL_CCVR_TBL CMTCVR UNION SELECT CMTTGT.SETID , CMTTGT.RULE_ID , CMTTGT.PRODUCT_ID FROM PS_RB_RL_CTGT_TBL CMTTGT UNION SELECT CMTTGTPROD.SETID , CMTTGTPROD.RULE_ID , CMTTGTPROD.PRODUCT_ID FROM PS_RB_RL_CPRD_TBL CMTTGTPROD UNION SELECT ATR.SETID , ATR.RULE_ID , ATR.PRODUCT_ID FROM PS_RB_RULE_ATR_TBL ATR UNION SELECT BRN.SETID , BRN.RULE_ID , BRN.PRODUCT_ID FROM PS_RB_RULE_BRN_TBL BRN UNION SELECT PRD.SETID , PRD.RULE_ID , PRD.PRODUCT_ID_ALT FROM PS_RB_RULE_PRD_TBL PRD UNION SELECT DDFN.SETID , DDFN.RULE_ID , ' ' FROM PS_RB_RULE_DFN_TBL DDFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing rule id information
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID