BO_REL_ADREL_V3

(SQL View)
 Index Back

Add Relationship Drop Down

Drop down list of valid relationships used in Add Relationship page

SELECT A.REL_VIEW ,C.SEQNO ,C.REL_TYPE_ID ,D.DESCR ,A.PARENT_SEQNO ,B.LEVEL_NUM ,A.ROLE_TYPE_ID ,B.ROLE_TYPE_ID FROM PS_BO_REL_CFG2 A , PS_BO_REL_CFG2 B ,PS_BO_REL_CFG3 C ,PS_BO_REL_TYPE D WHERE A.REL_VIEW = B.REL_VIEW AND A.PARENT_SEQNO = B.SEQNO AND C.REL_VIEW=A.REL_VIEW AND C.SEQNO=A.SEQNO AND D.REL_TYPE_ID=C.REL_TYPE_ID

  • Related Language Record: BO_REL_ADREL_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REL_VIEW Character(25) VARCHAR2(25) NOT NULL Relationship View Name...................................
    2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    3 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PARENT_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    6 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
    7 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    8 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID