RDM_MBL_REL_VW

(SQL View)
Index Back

Relationship View for Mobile

This is used for relationship view in mobile.

SELECT ROLE_TYPE_ID , A.REL_VIEW , DESCR FROM PS_BO_REL_CFG2 A , PS_BO_REL_CFG1 B WHERE A.LEVEL_NUM = 1 AND A.REL_VIEW = B.REL_VIEW

  • Related Language Record: RDM_MBL_REL_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    2 REL_VIEW Character(25) VARCHAR2(25) NOT NULL Relationship View Name...................................
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description