BO_REL_ADREL_LV

(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.LANGUAGE_CD ,D.DESCR FROM PS_BO_REL_CFG2 A , PS_BO_REL_CFG2 B ,PS_BO_REL_CFG3 C ,PS_BO_REL_TYPE_LNG 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 for BO_REL_ADREL_V2 BO_REL_ADREL_V3 BO_REL_ADREL_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description