RBF_MARTYPE_V_L

(SQL View)
 Index Back

Modify Account Rel Type View

Modify Account Rel Type View - Related language record

SELECT a.REL_TYPE_ID ,b.LANGUAGE_CD , b.DESCR FROM PS_BO_REL_TYPE a , PS_BO_REL_TYPE_LNG b WHERE a.REL_TYPE_ID = b.REL_TYPE_ID AND a.ROLE_TYPE_ID_1 = 12

  • Related Language Record for RBF_MA_RTYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description